I'm new to Knime but really enjoying learning it.
I'm using the Excel Sheet Appender to add a sheet to an existing workbook. Fine with a blank workbook, but with the rather large existing workbook, I get this error:
Execute failed: Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data. This may indicate that the file is used to inflate memory usage and thus could pose a security risk. You can adjust this limit via ZipSecureFile.setMinInflateRatio() if you need to work with files which exceed this limit. Counter: 602112, cis.counter: 6011, ratio: 0.0099831924957483Limits: MIN_INFLATE_RATIO: 0.01
I know I need to set the limit as follows : ZipSecureFile.setMinInflateRatio(0); but where do I do that? I've tried a Java Snippet before the Appender to make the adjustment, but no luck, and various other possibilitites and I've run out of ideas. Any help would be greatly appreciated.
Thanks in advance!