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. |
|
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 | Stores the count of the sheets. |
|
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. |
|
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]. |
java.io.FileNotFoundException | Please check [File]. | 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. |