Okay, send us the minimum amount of code to replicate the error and post it
to bugzilla, include output files.
see: http://jakarta.apache.org/poi/getinvolved/index.html for details.

Mark Shipley wrote:

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>





--
To unsubscribe, e-mail:   <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>

Reply via email to