On 17 May 2013, at 15:51, Nick Burch <[email protected]> wrote: > On Fri, 17 May 2013, Raja Garlapati wrote: >> Questions: 1. can i block any row from flushing? 2. Any solution you can >> think of? > > No. SXSSF is append-only. Once a row is outside the buffer, that's it, it > gets written to disk. Other rows have been written after it > > If you want random access read+write, you need to use XSSFWorkbook. > > Nick If I understand SXSSF correctly it would be possible to modify it to suite the use case (and it would make it useful n far more circumstances if it were). Currently SXSSF writes all of the (fully prepared) row data to the temp file, then copies that file into the XLSX file at write time. If SXSSF maintained a second, in memory, copy of 'locked' rows and then merged them with the contents of the fie at write time it would be possible to modify those locked rows at any time prior to the write. The downside would be a performance hit at write time as the locked rows get checked.
Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
