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>
