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 an Excel file.
Click [Browse] button to activate the file chooser and select the file. |
|
Cell settings | Optional | Specify cells to be read.
Each column can be operated with the following buttons.
|
||
Cell settings/Sheet name | Required | Available | Select or enter a sheet name of the Excel file specified in [File]. |
|
Cell settings/Cell address | Required | Available | Enter the cell address to be read. Example: A1 |
|
Cell settings/Cell name | Optional | Available | Enter the name of the cell. |
|
Cell settings/Type | Required | Not available | Specify the type of the cell.
|
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 |
---|---|---|
filePath | Stores the file path. |
|
message_category | Stores the category of message code corresponding to the occurred error. |
|
message_code | Stores the code of message code corresponding to the occurred error. |
|
message_level | Stores the severity of message code corresponding to the occurred error. |
|
error_type | Stores the error type of occurred error. |
|
error_message | Stores the error message of occurred error. |
|
error_trace | Stores the trace information of occurred error. |
|
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 | The path entered in [File] is directory. | Enter a file path in [File]. |
java.io.FileNotFoundException | The file specified in [File] does not exist. | Check [File]. |
InvalidPropertyConfigurationException
Cells to be read are not specified. |
[Cell setting] is not specified. | Specify [Cell setting]. |
InvalidPropertyConfigurationException
Cell address is not specified. |
[Cell setting/Cell address] is not specified. | Specify [Cell setting/Cell address]. |
InvalidCellAddressException
The specified cell address is invalid. |
The cell address entered in [Cell setting/Cell address] is invalid. | Check [Cell setting/Cell address] and enter a new cell address. |
jxl.read.biff.PasswordException | Read password is set for the Excel 2003 workbook specified in [File]. | Input a Excel 2003 workbook to [File], for which read password is not set. |
jxl.read.biff.BiffException
Unable to recognize OLE stream |
Excel 2003 workbook specified in [File] is in false condition. | Check the following.
|
jxl.read.biff.BiffException
The file format is corrupt |
The Excel 2003 workbook specified in [File] may be broken. | Check the following.
|
jxl.read.biff.BiffException
The input file was not found |
The Excel 2003 workbook specified in [File] is in false condition. | Check the following.
|
ZipEntryBrokenException Entry of operating ZIP file is broken |
Excel workbook specified in [File] is in false condition. | Check the following.
|
ZipEntryNotFoundException Entry of specified name does not exist in zip file |
A read password is set to the Excel workbook specified in [File], or the workbook is in false condition. | Check whether read password is set to the Excel workbook specified in [File], or the file is not broken. |