Firstly, please try the latest build from trunk. There have been many changes in SXSSF since 3.8-beta5 and there is a good chance your problem is already fixed.
If the problem is still there, please try to write an isolated test program that demonstrates it and post its source code. It might be a bug or you are doing something wrong or both. In any case we need more information to help you. Yegor On Thu, Mar 8, 2012 at 9:14 PM, dhwanipatel <[email protected]> wrote: > Hello, > > I am using POI-3.8-beta5 SXSSFWorkbook to generate a .xlsx sheet of about > 50K lines in a for loop of Info A, B, C and D lines. > > It works great but when I see generated file into OpenOffice / MS Excel - It > displays Info A, B, C and D lines correctly until 32769 lines. After that > line I can only see Info A and D and the lines where should be B and C info > are displayed empty. (In debug it should have written the info there). > > Workbook wb = new SXSSFWorkbook(100); // Auto flush for previous to 100 > lines > ((SXSSFWorkbook)wb).setCompressTempFiles(true); // with or without it > produce same result > > I wonder if this is the bug to the API - do we have certain limit on number > of lines ? > > Any help would be helpful. > > Thanks, > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/POI-3-8-beta5-SXSSFWorkbook-sheet-blank-lines-tp5548164p5548164.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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
