Hit Zip bomb detected when using tFileInputExcel

[Anonymous]

Hi

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?

[Anonymous]

Hello,

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-...

Best regards

Sabrina

[Anonymous]

Hi Sabrina

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.

[Anonymous]

Hello,

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?

TalendHelpCenter:Centralizing File Excel metadata

Best regards

Sabrina

[Anonymous]

Hello,

You can bypass this safety mechanism by adding a tJava with the following content.

org.apache.poi.openxml4j.util.ZipSecureFile.setMinInflateRatio(-1.0d);

Please note that this will not affect the Excel Metadata browser, so that might not work, but the actual ETL jobs should.

[Luiz_Filipe]

Adding my 2 cents here, maybe someone is having this issue, I am using Talend 8 and this setup did the trick for me, when getting the zip bomb error reading excel files: