topic Hit Zip bomb detected when using tFileInputExcel in Talend Studio

Hit Zip bomb detected when using tFileInputExcel

Anonymous — Tue, 02 Jan 2018 02:52:31 GMT

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?

Re: Hit Zip bomb detected when using tFileInputExcel

Anonymous — Tue, 02 Jan 2018 07:54:45 GMT

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?

Best regards

Sabrina

Re: Hit Zip bomb detected when using tFileInputExcel

Anonymous — Tue, 02 Jan 2018 08:02:40 GMT

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.

Re: Hit Zip bomb detected when using tFileInputExcel

Anonymous — Tue, 02 Jan 2018 08:46:33 GMT

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

Re: Hit Zip bomb detected when using tFileInputExcel

Anonymous — Fri, 01 May 2020 13:16:27 GMT

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.

Re: Hit Zip bomb detected when using tFileInputExcel

Luiz_Filipe — Tue, 17 Oct 2023 12:52:30 GMT

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: