I'm trying to read an excel worksheet (80 col x 80 row) from an excel file which is about 1MB in size and it contains other worksheets which I am not required to read.
I kept hitting a zip bomb detected exception (see image attached) when opening up this particular sheet. How can I troubleshoot what caused this exception and is there any configurations which I can tweak to handle this file?
Could you please try to extract data from specific Excel cells rather than all of the data in the file to see if it works?
Here is a related article about:https://community.talend.com/t5/Design-and-Development/Extracting-data-from-specific-Excel-cells/ta-...
Thanks for your reply. I think I'm not even able to open the excel file in the first place. The IO exception was thrown upon opening the file. However, when I copied the required worksheet and save into a new file, I'm able to read the worksheet properly.
You cannot open file by using tFileInputExcel component? Excel 2007 file format? Have you tried to create a file excel metadata to see if it works?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables