I don't think creating the sheet is appropriate in this scenario. I have 3
sheets in a brand new workbook. The 1st sheet has some data on it and I
need to write to the 2nd sheet leaving the 3rd sheet blank. If I do a
createSheet("Sheet2") I end up with two Sheet2's where the one I create in
POI is at the end. There is no method createSheetAt(int idx) available to
create a sheet over an existing sheet. Now if there was some easy way to
test for this condition then maybe I could delete/rewrite the sheet in
question but it would be a good solution. I'd have problems getting the new
sheet in the correct order. If you consider a workbook with these "new"
sheets intermingled and sporadically placed throughout other used sheets
then it becomes a real nightmare. What do I do?
-Cliff
"Steve"
<[EMAIL PROTECTED] To: "POI Users List" <[EMAIL
PROTECTED]>
M> cc:
Subject: Re: Cannot write to extra
sheets
06/16/2003 10:34
AM
Please respond to
"POI Users List"
it doesn't create extra sheets. only the space for them.
you need to create all sheets that you want,
as far as I know.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 16, 2003 8:59 AM
Subject: Cannot write to extra sheets
> Hello all,
>
> I am having a problem writing to the extra sheets that Excel creates by
> default when you create a new workbook. I'm using the
> jakarta-poi1.8.0-dev-20020919.jar version. I've developed a conversion
> program that allows data to be merged with existing spreadsheets. The
merge
> works when I attempt to write on a sheet that has already been written
on.
> However, whenever I attempt to write to one of the blank sheets (sheets 2
> and 3) that Excel creates automatically with an empty workbook it doesn't
> work. I can adjust the width of cells in these sheets but they do not
> retain any info from the cell.setCellValue() method calls. I verified in
> debug that these methods are not failing. My debugger (Eclipse) allows me
> to see the cell values before and after the method calls. I've attempted
> many tests where I enter the exact same parameters to merge data to an
> existing workbook changing only the sheet number. The data is retained
only
> on the 1st sheet where I've already added data. This is the only variance
> in my test runs. In all cases I obtain references to the sheet, row and
> cell objects the same way. I do a Workbook.getSheetAt(int num) to get the
> existing sheet. (I've tried with Workbook.getSheet(String name) as well.)
I
> am using Worksheet.createRow(short row) to create the row and
> Row.createCell(short cell) to create cell references. In my code I verify
> that the rows and cells do not exist prior to creating. In the latter
case
> I use the corresponding methods to obtain references to the existing
> objects. What am I missing?
>
> -Cliff
>
>
>
> ---------------------------------------------------------------------
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
