Excel and ZIP64
Deep dive into ZIP file format in the context of .xlsx
TL;DR; Excel has requires specific ZIP flag values in .xlsx that Java’s ZIP implementation does not provide when streaming.
Problem with huge XLSX files The standard in Excel file creation in Java is Apache POI. It works fine, a bit slow, but still fine. As it turns out up to some size limit, arbitrary at first sight. You can try it yourself. Just run this piece of code:
try (SXSSFWorkbook wb = new SXSSFWorkbook(new XSSFWorkbook())) { SXSSFSheet sheet = wb.
[Read More]