Cannot write to extra sheets

[Cl...@rrd.com]

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

Re: Cannot write to extra sheets

[Steve <st...@Basit.COM>]

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: <Cl...@rrd.com>
To: <po...@jakarta.apache.org>
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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>