Item name | Required / Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Name | Required | Not available | Enter the name on the script canvas. |
Item name | Required / Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
File | Required | Available | Enter the path of the Excel file.
Click [Browse] button to activate the file Selectr and Select the file. |
|
Range name | Required | Available | Select or input predefined range of Excel file specified in [File]. |
|
Column list | Optional | - | Specify the column.
Each column can be operated with the following buttons.
|
|
Column list / Column name | Required | Available | Input column name.
You can set the first line of the file specified in [File] in property action of [Update column list] as the column name. |
|
Column list / Type | Required | Not available | Select [Column name] type.
|
Item name | Description | Remarks |
---|---|---|
Update column list | Get column name and type value from the first line of file specified in [File], and set in [Column list]. |
|
Item name | Required / Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Do not get first row as a value | Optional | Not available | Select whether to treat the first line of the specified file as the data.
|
|
Read formula of the cell | Optional | Not available | Select whether to read the formula in the cell as data.
|
|
Item name | Required / Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Mass data processing | Required | Not available | Select a data processing method.
|
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. |
Component variable name | Description | Remarks |
---|---|---|
count | Stores the count of the data. |
|
filePath | Return file path. |
|
message_category | Stroes the category to which corresponding message code belongs to, when an error occurs. |
|
message_code | Stores its corresponding message code of occured error. |
|
message_level | Stores the severity of the corresponding message code of the occured error. |
|
error_type | Returns the error type when error occurred. |
|
error_message | Return the error message when error occurred. |
|
error_trace | Return trace information when error occurred. |
|
The result of the formula (Number of decimal places) |
Reading | How to Read |
---|---|---|
1234567890123456.123 (2 digits) |
1234567890123460 | Round digit value beyond valid decimal places. |
1234567890.1234567 (10 digits) |
1234567890.12346 | Round digit value beyond valid decimal places. |
12345.123 (2 digits) |
12345.12 | Round digits beyond 'number of decimal places'. |
The result of the formula | Reading | How to Read |
---|---|---|
1234567890123456.123 | 1234567890123460 | Round digit value beyond valid decimal places. |
1234567890.1234567 | 1234567890.12346 | Round digit value beyond valid decimal places. |
1.12345678944 | 1.123456789 | Round the 10th decimal digit |
0.0001234567894444 | 0.000123456789 | treat 9-digit from the first non-zero digit as the valid digit, and round the 10th decimal digit. |
Exception name | Causes | Solution |
---|---|---|
InvalidPropertyConfigurationException
<Property name> is not specified. |
[<Property name>] is not specified. | Specify [<Property name>]. |
FileIsDirectoryException | Path input in [File] is directory. | Input file path in [File]. |
NoDefinitionAreaException | [Range name] is not specified, or does not exist. | Please confirm [Range name]. |
java.io.FileNotFoundException | File specified in [File] does not exist. | Please check [File]. |
jxl.read.biff.PasswordException | Excel 2003 workbook specified in [File] is set with read password. | Please input Excel 2003 workbook whose read password is not set in [File] |
jxl.read.biff.BiffException
Unable to recognize OLE stream |
Excel 2003 workbook specified in [File] is not correct. | Check the following.
|
jxl.read.biff.BiffException
The file format is corrupt |
The Excel 2003 workbook specified in [File] may be damaged. | Check the following.
|
ZipEntryBrokenException: Working ZIP files entries are corrupt. |
Excel workbook specified in [File] is not correct. | Check the following.
|
ZipEntryNotFoundException: Entry of specified name didn't exist in zip file. |
Excel workbook specified in [File] is set with a read password or is not correct. | Please confirm if the Excel workbook specified in [File] is set with a read password or not, or if the file is damaged or not. |