To handle over 65536 xslx lines using POI
I need to load an xslx file with more than 65536 rows with 25 columns in one sheet and write to a DB table. I am using the XSSF Reader Event Handler API OPCpacakage
for both loading and reading. When the file is 65536 lines or less, it works fine, but when it exceeds 65536 lines, it becomes corrupted without any exception and the table loads with many rows missing.
Using:
POI 3.9 jars
poi 3.9
poi xml 3.9
poi ooxml schemas 3.9
ooxml_schemas 1.1
xmlbeans 2.3
Is there a limit to the number of lines these libraries can handle?
source to share
What book are you using to analyze your file?
I see you are using the poi ooxml schemas lib which offers a thread-safe version of the poi
Starting with 3.8-beta3, POI provides a low-memory SXSSF API built on top of XSSF. SXSSF is an API-compatible XSSF streaming extension that should be used when very large spreadsheets are to be created and white space is limited.
In this case, I suggest you try with SXSSFWorkbook and see if some of the lines are missing
source to share