Improved error message of file is empty

Improved error message if incoming file is empty.

Append rows works now in memory saving mode

You can now combine append and memory saving mode (streaming workbook).
The necessary changes are done in the apache poi library locally.
Will provide a pull request for the apache poi project.

Security update: Update to Apache POI 5.2.3

Update Apache POI to version 5.2.3
Xalan lib dependency removed.

Improvement for cell formats in the tFileExcelSheetOutput

The format of a cell will now also configured based on the schema information if the column format is not explicitly set in the column configuration table.
This simplifies the formats.

Bug fix for NullPointerException in tFileExcelSheetInput

Bug solved: When configuring the columns based on a header row and this row does not exist: this has caused a NullPointerException and not a meaningful error message.
Now the component throws an exception with sheet name and the expected header row index to support file investigation.

Bug fixes for tFileExcelReferencedCellOutput

missing error handling for invalid addresses
wrong calculated cell address if cell reference is given

Thanks a lot to Severine for notifying me about this bug!

Output format also for Object typed columns

In the tFileExcelSheetOutput columns can be Object typed and the format will be applied anyway.

Bug fix release

tFileExcelSheetInput bug solved: In case the cell contains a broken formula and the actual cell type is NUMERIC and the job wants to have the value as String - in this case the component returned the formula instead of the cached numeric value.

New component unpivot and output bug fix

The new component tFileExcelSheetInputUnpivot provides the feature to unpivot (or normalize) data provided in a variable number of columns. Please refer to the documentation of tFileExcelSheetInput.

tFileExcelSheetInput has now the option to tolerant find a sheet even if it is not exactly named as expected.
Spaces, - _ and case will be ignored optionally

tFileExcelSheetOutput: set data formats has been fixed.

Bug fix for tFileExcelSheetOutput

Bug solved: In case of no styles should be copied the component has damaged existing styles for text typed fields.
Thanks to Manuel for notifying me about this bug.