Getting errors while using tFileExcelWorkbookOpen: org.apache.commons.compress.archivers.zip.ZipArchiveInputStream is not implementing InputStreamStatistics

[Anonymous]

Excel files are actually zip files and therefore zipping and unzipping is an normal task in processing excel files.

The error message: ERROR: Initialise workbook from file failed: InputStream of class class org.apache.commons.compress.archivers.zip.ZipArchiveInputStream is not implementing InputStreamStatistics.

[Anonymous · Accepted solution]

This is caused by the component tFileArchive and tFileUnarchive. Both build-in components are shipping with an out dated lib commons-compress.

To solve that the component suite tFileExcel* ships with cloned and up-to-date components tFileArchive2 and tFileUnarchive2 components.

Both components works in the exactly same way as the original components but use the current version of commons-compress lib which is compatible with the compression in tFileExcelWorkbookOpen.

This problem only affects Talend 6.x. Newer versions (Talend 7.x) ships with updated tFileArchive and tFileUnarchive components.

[Anonymous]

This is caused by the component tFileArchive and tFileUnarchive. Both build-in components are shipping with an out dated lib commons-compress.

To solve that the component suite tFileExcel* ships with cloned and up-to-date components tFileArchive2 and tFileUnarchive2 components.

Both components works in the exactly same way as the original components but use the current version of commons-compress lib which is compatible with the compression in tFileExcelWorkbookOpen.

This problem only affects Talend 6.x. Newer versions (Talend 7.x) ships with updated tFileArchive and tFileUnarchive components.