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. |
|
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"?> <book> <sheet><![CDATA[Sheet1]]></sheet> <sheet><![CDATA[Sheet2]]></sheet> <sheet><![CDATA[Sheet3]]></sheet> : : </book>
Component variable name | Description | Remarks |
---|---|---|
count | The number of read sheets is stored. |
|
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. |
|
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]. |
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.
|
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. |