Re: Cannot write to extra sheets

[Danny Mui]

can you provide a snippet of the code so we can help you diagnose your 
problem?

[EMAIL PROTECTED] wrote:

But POI says the sheets already exist. Workbook.getNumberOfSheets()
includes them in the count. I apologize but I don't think we understand one
another. I'm trying to figure out why the data is not retained on new
sheets that have not been touched. Once I touch the sheet then the data
seems to "stick". If the sheet is brand new and untouched then the value of
each cell after it is set disappears or is not retained once the workbook
is serialized. If I so much as key a single space character on the sheet
then the data "sticks". Is there some sort of hidden attribute that is set
once a worksheet is touched? Are you saying that Excel doesn't create the
sheets until data is written to them? If so then that would explain my
problem. If this is the case, then how do I test for this condition? In
other words, how would I program for when Workbook.getNumberOfSheets()
returns 3 and only one sheet has data on it? My code needs to know under
this circumstance to create sheets instead of retrieving these sheets that
Excel "only creates the space for". Help!
Thank you for your assistance,
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]
 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]