https://bz.apache.org/bugzilla/show_bug.cgi?id=61371
--- Comment #4 from Greg Woolsey <gwool...@apache.org> --- To clarify: 1. even empty hidden cells are still cells, and as such require object allocations when read using the XSSFWorkbook API. no space is allocated if they are truly missing from the workbook - not even defined in the OOXML file. 2. OOXML files are ZIP packages containing mostly XML files. Cells defined but empty compress extremely well, so a 9k file can actually unzip to hundreds of megabytes. Unzip your sample file and see just how big it really is. This will give you a good rough start for estimating the heap space required to read it using the XSSFWorkbook API. I'd say double the unzipped size as a good first guess. If the result turns out to be too big for the available heap, try using the streaming API as mentioned by PJ Fanning in comment 3. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
