I have a scenario where i am creating a very large xlsx files using SXSSF workbook(around 1-2 million).
While writing to the sheet , i have to dynamically populate some values say Headers only in Row 1 of the sheet PROBLEM: Since its streaming api , if i am in 100000 th row ,and wanted to populate some value in Row1, by this time my Row 1 got flushed out and try to write its not available. Questions: 1. can i block any row from flushing? 2. Any solution you can think of? I am thinking to hold the Row1 values , flush the whole workbook, read in the workbook again, create the Row1 and flush again. Better solution Please .... -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-SXSSFWorkbook-Block-a-row-from-flushing-tp5712721.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]
