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 path of the Excel workbook file.
If [View] is checked, file chooser starts, and file selection will be available. |
|
Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Set password to modify | Optional | Not available | Specify password to modify and choose whether the workbook will be protected.
|
|
User name | Required | Available | Enter user name which protects workbook. |
|
Password to modify | Required | Available | Enter password to modify which protects workbook. |
|
Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Protect the content of the sheet and locked cells | Optional | Not available | Select whether to protect the content of the sheet and locked cells.
|
|
Sheet name | Required | Not available | Enter or select protection target sheet in the Excel file specified in [File]. |
|
Password to unprotect sheet | Optional | Available | Enter password for unlocking sheet protection. |
|
Operations all users of this worksheet are allowed to perform | Optional | - | Select operation which allows all sheet users specified in [Sheet name]. |
|
Operations all users of this worksheet are allowed to perform/Permission | Optional | - | Select operations to permit from [Operation] in the protected sheet.
|
|
Operations all users of this worksheet are allowed to perform/Operation | - | - | Operation to select whether to permit or not will be shown in the protected sheet.
|
Item name | Required/Optional | Use of variables | Description | Remarks |
---|---|---|---|---|
Execute transaction processing | Optional | Not available | Select whether to perform transaction processing.
|
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 |
---|---|---|
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. |
|
Exception name | Cause | Solution |
---|---|---|
InvalidPropertyConfigurationException
File path is not specified. |
[File] is not specified. | Specify [File]. |
InvalidPropertyConfigurationException
The specified book is not supported. |
Book which format does not correspond with [File] is specified. | Specify book which format corresponds with [File]. |
InvalidPropertyConfigurationException
User name is not specified. |
[User name] is not specified. | Specify [User name]. |
InvalidPropertyConfigurationException
Password to modify is not specified. |
[Password to modify]is not specified. | Specify [Password to modify]. |
InvalidPropertyConfigurationException
Sheet name is not specified. |
[Sheet name]is not specified. | Specify [Sheet name]. |
FileIsDirectoryException | Path specified in [File] is directory. | Specify a file path in [File]. |
FileIsLockedException | The file specified in [File] is locked. | Unlock from explorer or CLI. |
java.io.FileNotFoundException
The file is being used by another process. |
The file specified in [File] is being used in another process. | Confirm whether it is being used or not. |
SheetNotFoundException
A non-existent sheet name is specified. |
The sheet specified in [Sheet name] does not exist. | Specify the name of a existing sheet in [Sheet name]. |