Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Name | Required | Not available | Enter the name to show on the script canvas. | |
Input data | Required | Not available | Select a component on the script canvas. |
Item name | Required/Optional | Use of variables | Description | Remarks | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File | Required | Available | Enter the Excel file path.
You can click [Browse] button to launch file chooser and find the file. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sheet name | Optional | Available | Select or enter a sheet of the Excel file specified in [File]. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Column list | Optional | - | Specify column names.
Each column can be operated with the following buttons.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Column list/Column name | Required | Available | Enter the column name. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Column list/Style | Required | Not available | Select whether or not to write type / format information.
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Column list/Type | Required | Not available | Select the type of [Column name].
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Column list/Format | Optional | Available | Select or enter a format.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Specify format/comment in Mapper to write | Optional | Not available | Select whether or not to set elements for writing format/comment in input schema.
|
|
Item name | Description | Remarks |
---|---|---|
Open Excel Wizard | Open the Excel Wizard with the file specified in [File].
For how to configure, refer to "Excel Write Wizard". |
|
Update column list | Get column names and types from the first row values of the file specified in [File] and set them in [Column list]. |
|
Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Insert column names in the first row | Optional | Not available | Select whether or not to insert column names in the first row of the specified file.
|
|
Overwrite | Optional | Not available | Select whether or not to overwrite when data exists in the specified file.
|
|
Insert | Optional | Not available | Select whether or not to insert data.
|
|
Delete target sheet | Optional | Not available | Select whether or not to delete the specified sheet before writing data to the specified file.
|
|
Specify write position | Optional | Not available | Select whether or not to specify the position to start writing.
|
|
Condition to specify starting cell | Optional | Not available | Select a condition to specify a cell where writing starts.
|
|
Starting cell address | Optional | Available | Enter the cell address to start writing. Example: A1 |
|
Value of starting cell | Optional | Available | Enter the cell value to start writing. |
|
Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Execute transaction processing | Optional | Not available | Select whether or not to execute transaction processing.
|
Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Comment | Optional | Not available | You can write a short description of this adapter. The description will be reflected in the specifications. |
<?xml version="1.0" encoding="UTF-8"?> <table> <row> <column> <format></format> </column> <column> <format></format> </column> : </row> <row> : </row> : </table>
Element name | Attribute name | Description | Remarks |
---|---|---|---|
table | - | ||
row | - | ||
column | - | Shows the value to be written in the cell. |
|
format | - | Shows the format/comment to be written in the cell. |
|
Component variable name | Description | Remarks |
---|---|---|
count | The number of written data is stored. |
|
message_category | When an error occurs, the corresponding message code's category is stored. |
|
message_code | When an error occurs, the corresponding message code is stored. |
|
message_level | When an error occurs, the corresponding message code's severity is stored. |
|
error_type | When an error occurs, the error type is stored. |
|
error_message | When an error occurs, the error message is stored. |
|
error_trace | When an error occurs, the error's trace information is stored. |
|
Format | Example |
---|---|
yyyy-MM-dd'T'HH:mm:ss.SSSZZ | 2007-05-10T15:32:12.708+0900 |
yyyy-MM-dd'T'HH:mm:ss.SSS | 2007-05-10T15:32:12.708 |
yyyy-MM-dd'T'HH:mm:ssZZ | 2007-05-10T15:32:12+0900 |
yyyy-MM-dd'T'HH:mm:ss | 2007-05-10T15:32:12 |
yyyy-MM-dd'T'HH:mm | 2007-05-10T15:32 |
yyyy-MM | 2007-05 |
yyyy/M/d K:m a | 2007/5/10 3:32 PM |
yyyy/M/d H:m:s | 2007/05/10 15:32:12 |
yyyy/M/d H:m | 2007/05/10 15:32 |
yyyy/M/d | 2007/05/10 |
Type of date format | Example | Remarks |
---|---|---|
[$-411]ge.m.d;@ | h13.3.14 | |
[$-409]yyyy/m/d h:mm AM/PM;@ | 13/3/14 1:30 PM | When the destination cell contains any data, it can be written as date. |
Exception name | Cause | Solution |
---|---|---|
InputDataNotFoundException | [Input data] is not specified. | Specify [Input data] or draw a data flow. |
InputDataReadException Failed to read a format from input data. |
A value entered in format element of input schema is invalid. | Input a value output from "Generate Excel Format" logic in Mapper, or do not input any value if not necessary. |
InvalidPropertyConfigurationException
<property name> is not specified. |
[<property name>] is not specified. | Specify [<property name>]. |
FileIsDirectoryException | The path entered in [File] is directory. | Enter a file path in [File]. |
FileAlreadyExistedException | The specified file does not exist in [File]. | Change the file name of [File], or put a check in [Overwrite] of [Write settings]. |
IllegalFormatException | [Format] for [Type] specified in [Column list] is invalid. | Check the combination of type and format. |
ColumnIndexOutofBoundsException | This is an exception that occurs when attempting to write more than the columns specified in [Column list]. | Check the number of columns of the list and the input source. |
InvalidStartCellAddressException: The specified starting cell address is invalid. |
The cell address entered in [Starting cell address] is invalid. | Check [Starting cell address] and enter a valid cell address. |
IllegalTargetWorkbookException | The specified workbook is in a state cannot be written to. | Another program might be using the file or the format of the workbook might be corrupted. |
FileIsLockedException | The file specified in [File] is being locked. | Unlock it from Explorer or CLI. |
java.io.FileNotFoundException
Some other process is using the file. |
The file specified in [File] is being used by some other process. | Make sure that it is not being used by some other process. |
jxl.read.biff.PasswordException | A password to open is set in the Excel 2003 workbook specified in [File]. | Enter an Excel 2003 workbook in which a password to open is not set in [File]. |
jxl.write.biff.RowsExceededException | The row number specified in [Starting cell address] exceeds the maximum value. | Check the value of [Starting cell address]. |
jxl.read.biff.BiffException
Unable to recognize OLE stream |
The Excel 2003 workbook specified in [File] is in an invalid state. | Check the following.
|
jxl.read.biff.BiffException
The file format is corrupt |
The Excel 2003 workbook specified in [File] might be corrupted. | Check the following.
|
jxl.read.biff.BiffException
The input file was not found |
The Excel 2003 workbook specified in [File] is in an invalid state. | Check the following.
|
IndentExceedsMaxException
The specified indent exceeds the maximum value that can be specified. |
The value of [Indent] specified in “Generate Excel Format” logic exceeds the maximum value that can be specified for an Excel 2003 workbook. | Check the value of [Indent] specified in “Generate Excel Format” logic. |
ZipEntryBrokenException: The entry of the operating ZIP file is broken. |
The Excel workbook specified in [File] is in an invalid state. | Check the following.
|
ZipEntryNotFoundException: Entry of the specified name does not exist in the zip file |
The Excel workbook specified in [File] is protected with password to open or is in an invalid state. | Check whether password to open is set to the Excel workbook specified in [File], and whether the file is corrupted. |