Dear All,
the new 4.0 seems to have a problem when writing large XLSX files (e.g.
>100k rows but less than 1 Mill. rows) using SXSSFWorkbook:
java.io.IOException: This archive contains unclosed entries.
at
org.apache.commons.compress.archivers.zip.ZipArchiveOutputStream.finish
(ZipArchiveOutputStream.java:467)
at
org.apache.poi.xssf.streaming.SXSSFWorkbook.injectData(SXSSFWorkbook.ja
va:406)
at
org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:93
6)
Please note, small files (e.g. less than 100k rows seem to work fine)
and also everything works fine with 3.18 (same code, same data).
Also, other people seem to have this problem:
https://stackoverflow.com/questions/53080171/java-apache-poi-and-large-result-set-from-db2-runs-into-exception
My suspision is that the Workbook is closed before the ZIP stream is
ready?
Thank you already for helping, best regards
Andreas
