java - To process more than 65536 rows xslx using POI -
I upload more 65536 lines xslx than file with 25 columns in a single sheet and write to the DB table Need for I use the Using:. Is there a limit? OPCpacakage classes for both the XSSF reader event handler API and the upload and read. When a file is 65536 rows or less it works fine, but when it exceeds 65536 lines, it is corrupted with no exceptions and many rows in the table are filled with missing
What kind of workbook are you using to parse your file? I see you using poi OOXML schema, which provides a stream-oriented version of Poi Since 3.8-beta 3, the top of the Poi XSSF Built on low memory footprint SXSSF API provides. Expansion of an API compatible streaming of SXSSF XSSF when submitting a large spreadsheet is to be used, and the heap space is limited. In that case I try to suggest SXSSFWorkbook and try to see that some lines are still missing
Comments
Post a Comment