Unless I am mistaken - and I am by no means an expert with the SAXParser, you will have the same problem as the event driven approach using SAX is read only. As with all of these things, I could very well be wrong but I believe that you will need to use the document object model approach if you want to create new/update existing markup. If you use the DOM, then you will have to read the whole file into memory. This will obviously not require the same amount of memory as would creating and XSSFWorkbook object but it might still be significant.
If you feel very brave, there is another alternative but it will not be scalable and it does require manipulating the low level xml markup directly. It is possible to unzip the .xlsx archive, open the file of markup directly using Java's own file handling techniques and then to update/change the markup 'manually'. This is similar to the approach that was proposed by Yegor with his BigGridDemo class and whihc used to be the preferred technique employed to create larger files in the time before Alex proposed the SXSSF approach. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-SXSSFWorkbook-Block-a-row-from-flushing-tp5712721p5712724.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]
