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]
