You can read the xslx file using the SAX approach you highlighted and you can use a SXSSFWorkbook to write out a new xlsx file. SXSSFWorkbook is for writing large xlsx files and it avoids keeping all the data in memory (by storing the data in temp files).
You're probably going to have to use a newer version of POI to get all the features (4.1.0 was just released). There are a couple of other solutions for streaming the input but if you are happy with the SAX approach, go with that. https://github.com/pjfanning/poi-shared-strings-sample has 2 examples (1 for streaming read and 1 for string write). https://github.com/pjfanning/excel-streaming-reader-sample has an alternative streaming read that uses an API similar to XSSFWorkbook. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
