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]
