I need to upload xslx file having more than 65536 lines with 25 columns in a
single sheet and write in to DB table. I use XSSF Reader event handler API
and OPCpacakage classes for both upload and read. When a file contains
exactly 65536 rows or less it works fine, but when it exceeds 65536 rows,
it's getting corrupted without any exception and table gets loaded 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 limitation on the number of rows that these libraries can
process?
Code:
OPCPackage pkg = OPCPackage.open(System.getProperty("java.io.tmpdir")
+ "/" + demande.getNomFichierDisque());
XSSFReader r = new XSSFReader( pkg );
SharedStringsTable sst = r.getSharedStringsTable();
XMLReader parser = fetchSheetParser(sst);
Iterator<InputStream> sheets = r.getSheetsData();
if(sheets.hasNext()) {
InputStream sheet = sheets.next();
InputSource sheetSource = new InputSource(sheet);
parser.parse(sheetSource);
sheet.close();
}
where event handler startElement and endElement methods will read each cell
and process.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/To-process-more-than-65536-rows-in-XSLX-file-using-XSSF-reader-tp5716872.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
