For reading large documents use https://github.com/monitorjbl/excel-streaming-reader or https://github.com/apache/poi/blob/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
If you run into issues with shared strings table being too large, you might also want https://github.com/pjfanning/poi-shared-strings You can then use SXSSFWorkbook to save the modified sheets. This is obviously not as straightforward as parsing into an XSSFWorkbook and modifying it in place before saving it. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
