Messages and limitations of the Excel(POI) connector
Message code list of Excel(POI) category
The following message codes correspond to errors that occur in Excel POI Connector.
This message code is output when an undefined error occurs.
|
Cause |
Solution |
|---|---|
|
An undefined error occurred. |
Check the error message or the help of the operation in which the error has occurred. |
Corresponding error
-
None
This message code outputs when a password is set in an Excel file.
|
Cause |
Solution |
|---|---|
|
A password to open is set in the Excel file specified in File path. |
Enter an Excel file in which a password to open isn't set in File path. |
Corresponding error
-
org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException
This message code is output when the Excel file is in an invalid state.
|
Cause |
Solution |
|---|---|
|
The Excel file specified in File path is in an invalid state. |
Check the following:
|
Corresponding error
-
org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException
-
org.apache.poi.EmptyFileException
-
org.apache.poi.openxml4j.exceptions.InvalidFormatException
This message code is output when failed to read a format from input data.
|
Cause |
Solution |
|---|---|
|
In write operation, when Specify format/comment in Mapper to write is selected, a value entered in format element of input schema is invalid. |
In format element, input a value that is output from "Generate Excel Format" logic in Mapper, or don't input any value if not necessary. |
Corresponding error
-
ToFormatException
-
javax.json.JsonException
This message code is output when the sheet already exists.
|
Cause |
Solution |
|---|---|
|
The sheet specified in Sheet name already exists. |
Change the sheet name of Sheet name, or select Overwrite of Write settings. |
Corresponding error
-
SheetAlreadyExistsException
This message code is output when the processing can't be started because the start condition doesn't match.
|
Cause |
Solution |
|---|---|
|
The processing couldn't be started because the start condition doesn't match. |
Check the settings of Start condition settings. |
Corresponding error
-
CannotStartException
Exception messages of Excel(POI) category
|
Exception name |
Cause |
Solution |
|---|---|---|
|
CannotStartException Could not start the operation as the start condition does not match. |
The processing couldn't be started because the start condition doesn't match. |
Check the settings of Start condition settings. |
|
FileIsDirectoryException |
The path entered in File path is a directory. |
Enter a file path in File path. |
|
FileIsLockedException |
The file specified in File path is locked. |
Unlock it from Explorer or CLI. |
|
InputDataNotFoundException |
Input data isn't specified. |
Specify Input data or draw data flow. |
|
InvalidPropertyConfigurationException <Property name> is not specified. |
<Property name> isn't specified. |
Specify <property name>. |
|
InvalidPropertyConfigurationException The cell address exceeds the range. [<cell address>] |
The cell address specified in Cell list/Cell address exceeds the maximum value. |
Check values of Cell list/Cell address. |
|
InvalidPropertyConfigurationException The specified cell address is invalid. |
The cell address entered in Cell list/Cell address is invalid. |
Check Cell list/Cell address and enter a valid cell address. |
|
InvalidPropertyConfigurationException The column number exceeds the range. [<column number>] |
The column number specified in Column list/Columns exceeds the maximum value. |
Check values of Column list/Columns. |
|
java.io.FileNotFoundException Some other process is using the file. |
The file specified in File path is being used by another process. |
Make sure that it's not being used by another process. |
|
ToFormatException |
A value entered in format element of input schema is invalid. |
Input a value that is output from "Generate Excel Format" logic in Mapper, or don't input any value if not necessary. |
|
javax.json.JsonException |
||
|
org.apache.poi.EmptyFileException |
The Excel file specified in File path is in an invalid state. |
Check the following: - Whether a file which isn't an Excel file is specified in File path - Whether the file is corrupted |
|
org.apache.poi.openxml4j.exceptions.InvalidFormatException |
||
|
org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException |
||
|
org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException |
A password to open is set in the Excel file specified in File path. |
Enter an Excel file in which a password to open isn't set in File path. |
|
SheetAlreadyExistsException The specified sheet already exists. |
The sheet specified in Sheet name already exists. |
Change the sheet name of Sheet name, or select Overwrite of Write settings. |
Limitations of Excel(POI) category
Specification limits
-
When you enter null in the column element of the input schema, it's written as empty characters.
-
The number format of the cell may be not yet determined when written.
-
You can't write data to a file that is encrypted with a password.
-
Writing formula isn't supported.
-
Writing to a file with digital signature added isn't supported.
-
When writing to a file with sheet protection and book protection set, data will be written, and if a password is set, the password will be maintained.
-
When specifying Background color in "Generate Excel Format" logic, items other than background color will be set as default value.
-
When writing to a file with a write password set, writing will be performed and the password will be maintained.
When a file with large size is specified in File path, OutOfMemoryError may occur.
Specification limits
-
When you enter null in the column element of the input schema, it's written as empty characters.
-
When input data has more than two rows, only the input data in the first row will be written.
-
The number format of the cell may be not yet determined when written.
-
You can't write data to a file that is encrypted with a password.
-
Writing formula isn't supported.
-
Writing to a file with digital signature added isn't supported.
-
When writing to a file with sheet protection and book protection set, data will be written, and if a password is set, the password will be maintained.
-
When specifying Background color in "Generate Excel Format" logic, items other than background color will be set as default value.
-
When writing to a file with a write password set, writing will be performed and the password will be maintained.
When a file with large size is specified in File path, OutOfMemoryError may occur.