No, there is data in the row. For each new row, I set the first four cell values (the data is present when I call setCellValue). However, whatever data I set in the 142nd row, using createRow( 141 ), appears in the 64th row of the .xls file, and whatever was in the 64th row is gone. There is also no data in the 142nd row.
--- "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote: > I'm betting your confused between physical rows and > logical rows. > Rows with NO data (not physically represented in the > file) do not get > represented. So when you get the next physical > row...its the next one that > has some data associated with it. Get the row > number, use that. > > -Andy > > Mark Shipley wrote: > > >I'm using HSSF 1.5.1 to generate a file containing > >data stored in a database table where each row of > the > >generated file corresponds to a row of the > database. > >However, the problem I'm facing is that row 142 > (row > >number in Excel, 1-based) of the generated spread > >sheet is blank and its data is in row 64. The same > is > >true for row 398 which overwrites row 320. No > matter > >the data set being printed, it is always the same > row > >numbers that cause the problem. > > > >I'm just looping through the result set and calling > >createRow( rowCtr++ ) repeatedly. Is this a known > >HSSF problem, or might it be something that I'm > doing? > > > >Thanks, > >-Mark > > > >__________________________________________________ > >Do you Yahoo!? > >HotJobs - Search new jobs daily now > >http://hotjobs.yahoo.com/ > > > >-- > >To unsubscribe, e-mail: > <mailto:poi-user-unsubscribe@;jakarta.apache.org> > >For additional commands, e-mail: > <mailto:poi-user-help@;jakarta.apache.org> > > > > > > > > > > > > -- > To unsubscribe, e-mail: > <mailto:poi-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: > <mailto:poi-user-help@;jakarta.apache.org> > __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
