https://community.qlik.com/t5/Talend-Studio/Getting-errors-while-using-tFileExcelWorkbookOpen-org-apache/m-p/2253043#M36504 <P>Excel files are actually zip files and therefore zipping and unzipping is an normal task in processing excel files.</P> <P>The error message:&nbsp;<SPAN>ERROR: Initialise workbook from file failed: InputStream of class class org.apache.commons.compress.archivers.zip.ZipArchiveInputStream is not implementing InputStreamStatistics.</SPAN></P> <P><SPAN>&nbsp;</SPAN></P> Sat, 16 Nov 2024 01:57:15 GMT Anonymous 2024-11-16T01:57:15Z https://community.qlik.com/t5/Talend-Studio/Getting-errors-while-using-tFileExcelWorkbookOpen-org-apache/m-p/2253043#M36504 <P>Excel files are actually zip files and therefore zipping and unzipping is an normal task in processing excel files.</P> <P>The error message:&nbsp;<SPAN>ERROR: Initialise workbook from file failed: InputStream of class class org.apache.commons.compress.archivers.zip.ZipArchiveInputStream is not implementing InputStreamStatistics.</SPAN></P> <P><SPAN>&nbsp;</SPAN></P> Sat, 16 Nov 2024 01:57:15 GMT https://community.qlik.com/t5/Talend-Studio/Getting-errors-while-using-tFileExcelWorkbookOpen-org-apache/m-p/2253043#M36504 Anonymous 2024-11-16T01:57:15Z https://community.qlik.com/t5/Talend-Studio/Getting-errors-while-using-tFileExcelWorkbookOpen-org-apache/m-p/2253044#M36505 <P><SPAN>This is caused by the component tFileArchive and tFileUnarchive. Both build-in components are shipping with an out dated lib commons-compress.</SPAN></P> <P><SPAN>To solve that the component suite tFileExcel* ships with cloned and up-to-date components tFileArchive2 and tFileUnarchive2 components.</SPAN></P> <P><SPAN>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.</SPAN></P> <P>&nbsp;</P> <P><SPAN>This problem only affects Talend 6.x. Newer versions (Talend 7.x) ships with updated tFileArchive and tFileUnarchive components.</SPAN></P> Wed, 08 Jul 2020 10:46:34 GMT https://community.qlik.com/t5/Talend-Studio/Getting-errors-while-using-tFileExcelWorkbookOpen-org-apache/m-p/2253044#M36505 Anonymous 2020-07-08T10:46:34Z https://community.qlik.com/t5/Talend-Studio/Getting-errors-while-using-tFileExcelWorkbookOpen-org-apache/m-p/2253045#M36506 <P><SPAN>This is caused by the component tFileArchive and tFileUnarchive. Both build-in components are shipping with an out dated lib commons-compress.</SPAN></P> <P><SPAN>To solve that the component suite tFileExcel* ships with cloned and up-to-date components tFileArchive2 and tFileUnarchive2 components.</SPAN></P> <P><SPAN>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.</SPAN></P> <P>&nbsp;</P> <P><SPAN>This problem only affects Talend 6.x. Newer versions (Talend 7.x) ships with updated tFileArchive and tFileUnarchive components.</SPAN></P> Wed, 08 Jul 2020 10:46:34 GMT https://community.qlik.com/t5/Talend-Studio/Getting-errors-while-using-tFileExcelWorkbookOpen-org-apache/m-p/2253045#M36506 Anonymous 2020-07-08T10:46:34Z