poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raja Garlapati <rajureddy.garlap...@gmail.com>
Subject Apache POI- SXSSFWorkbook - Block a row from flushing
Date Fri, 17 May 2013 14:34:28 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message