I am by no means an expert but I fear that you cannot use SXSSF in this manner. It is intended to be used to write files and not read from them. All that happens when you open an existing file is that XSSF's reading support is used to parse the files contents and this will, of course, not save you any memory at all. Further, you cannot look to the event driven model either as that is aimed at reading binary Excel workbooks (.xls) and not SpreadsheetML (.xlsx) ones.
What do you need to recover from the cells? is formatting important to you at all? If not, it may be possible to work directly with the raw xml itself. You will need to navigate around the shared strings table of course but it should be possible to look at the extising POI code to work out how to do this. If you do need formatting or if you need to recovers pictures, charts and the like then the problem becomes, of course, a lot more complex. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Poi-3-8-Beta-5-Streaming-XSSF-Question-tp5490691p5492410.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]
