Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Name | Required | Not available | Enter the name to show 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. |
|
Cell settings | Optional | Specify cells to be read.
Each column can be operated with the following buttons.
|
||
Cell settings/Sheet name | Optional | Available | Select or enter a sheet 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 cell name. |
|
Cell settings/Type | Required | Not available | Select a cell type.
|
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 | The file path 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. |
|
Result value of formula (Number of decimal places) |
Read value | Read method |
---|---|---|
1234567890123456.123 (2 digits) |
1234567890123460 | Round off the digits that exceed the number of significant digits |
1234567890.1234567 (10 digits) |
1234567890.12346 | Round off the digits that exceed the number of significant digits |
12345.123 (2 digits) |
12345.12 | Round off the digits that exceed the specified number of decimal places |
Result value of formula | Read value | Read method |
---|---|---|
1234567890123456.123 | 1234567890123460 | Round off the digits that exceed the number of significant digits |
1234567890.1234567 | 1234567890.12346 | Round off the digits that exceed the number of significant digits |
1.12345678944 | 1.123456789 | Round off the decimal places to 9 digits. |
0.0001234567894444 | 0.000123456789 | The 9 digits from the first non-zero digit will be counted as significant digits, and the value will be rounded off to 9 decimal places |
Exception name | Cause | 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
Read target cell is not specified. |
[Cell settings] is not specified. | Specify [Cell settings]. |
InvalidPropertyConfigurationException
Cell address is not specified. |
[Cell settings/Cell address] is not specified. | Specify [Cell settings/Cell address]. |
InvalidStartCellAddressException:
The specified cell address is invalid. |
The cell address entered in [Cell settings/Cell address] is invalid. | Check [Cell settings/Cell address] and enter a valid cell address. |
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.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.
|
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. |