Hi, I’m trying to read an Excel file that contains a pivot table in KNIME, but I’m getting the following error: “The file would exceed the maximum allowed inflation ratio. This may indicate that the file is used to inflate zip bombs.” After some research, I found that I should add the following line to the knime.ini file: “-Dorg.apache.poi.util.ZipSecureFile.setMinInflateRatio=0.001” I added this line to the end of the knime.ini file. When I run the workflow via the KNIME GUI, it works without any issues. However, when I run the same workflow using a .bat file, I still get the same error. It seems like the JVM argument is not being applied when running from the .bat file. How can I fix this? Thanks in advance.

Getting zip bomb error when reading Excel file with pivot table via .bat file

mlauber71 June 10, 2025, 12:07pm 3

@misguzar welcome to the KNIME forum. have you tried this approach?

Another option could be to use the integrated Python extension with OpenPyxl

2 Likes