https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337428#M105772 <P>If this issue is solved, PLEASE mark it as solved. This has the advantage we do not have to take care of it and others recognise a solution here!</P> Fri, 09 Dec 2022 10:07:05 GMT jlolling 2022-12-09T10:07:05Z https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337424#M105768 <P>jxl.read.biff.BiffException: Unable to recognize OLE stream</P><P> at jxl.read.biff.CompoundFile.&lt;init&gt;(CompoundFile.java:116) ~[jxl-6.0.0.jar:?]</P><P> at jxl.read.biff.File.&lt;init&gt;(File.java:127) ~[jxl-6.0.0.jar:?]</P><P> at jxl.Workbook.getWorkbook(Workbook.java:268) ~[jxl-6.0.0.jar:?]</P><P> at dataprocess_fs_metadata_test_0_1.DataProcess_FS_Metadata_Test.tFileInputExcel_2Process(DataProcess_FS_Metadata_Test.java:3117) [classes/:?]</P><P> at dataprocess_fs_metadata_test_0_1.DataProcess_FS_Metadata_Test.tLibraryLoad_4Process(DataProcess_FS_Metadata_Test.java:4132) [classes/:?]</P><P> at dataprocess_fs_metadata_test_0_1.DataProcess_FS_Metadata_Test.runJobInTOS(DataProcess_FS_Metadata_Test.java:5995) [classes/:?]</P><P> at dataprocess_fs_metadata_test_0_1.DataProcess_FS_Metadata_Test.main(DataProcess_FS_Metadata_Test.java:4395) [classes/:?]</P><P>Exception in component tFileInputExcel_2 (DataProcess_FS_Metadata_Test)</P> Fri, 15 Nov 2024 22:17:18 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337424#M105768 guruswaami 2024-11-15T22:17:18Z https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337425#M105769 <P>It sounds like you are not selecting the "Read Excel 2007 File Format" option</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000aEzgtAAC.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149602iF283EC1F48A9C2D5/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000aEzgtAAC.png" alt="0695b00000aEzgtAAC.png" /></span></P> Thu, 08 Dec 2022 15:50:17 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337425#M105769 Anonymous 2022-12-08T15:50:17Z https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337426#M105770 <P>Thats it. It would be a huge advantage if Talend could do the same as in my components: detecting the type of file simply by the file extension and use automatically the right API. It would so easy!</P> Fri, 09 Dec 2022 09:54:40 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337426#M105770 jlolling 2022-12-09T09:54:40Z https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337427#M105771 <P>Talend use for the very out-dated OLE based Excel files an also out-dated excel library which is not maintained anymore.</P><P>I strongly recommend using the Apache POI library also for the OLE based files. In this case an automatic switch of the internal workbook type would be easy to implement.</P> Fri, 09 Dec 2022 09:57:09 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337427#M105771 jlolling 2022-12-09T09:57:09Z https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337428#M105772 <P>If this issue is solved, PLEASE mark it as solved. This has the advantage we do not have to take care of it and others recognise a solution here!</P> Fri, 09 Dec 2022 10:07:05 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-2-Unable-to-recognize-OLE-stream-jxl-read-biff/m-p/2337428#M105772 jlolling 2022-12-09T10:07:05Z