Excel Tools

Goodmorning

using the function excelreadcellsbyname in file more than 500kb i get the error below:

ERROR com.appiancorp.ps.exceltools.util.ExcelHelperUtils - Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data.

Please could you fix the plugin?

Thank You

Gianluca

There is nothing to fix, it is working as expected. The error is coming from Apache POI. Please refer to their documentation for potential fixes to your excel file.

I would also suggest trying the readexcelsheetpaging function.

Hello Mike,

Thank You for your answer. Ii know this error coming from POI but in the plug in version 2.2.11 i didn't get the Zip Bomb error.

The reason is in the setting for this variable that by default in the version 2.2.14 shoud be 0.01.

ZipSecureFile.setMinInflateRatio();

 If possible could you set this variable to 0 or with the same value used in the version 2.2.11?.

Hello Mike,

Thank You for your answer. Ii know this error coming from POI but in the plug in version 2.2.11 i didn't get the Zip Bomb error.

The reason is in the setting for this variable that by default in the version 2.2.14 shoud be 0.01.

ZipSecureFile.setMinInflateRatio();

 If possible could you set this variable to 0 or with the same value used in the version 2.2.11?.