Cell content not saving

[Jared Walker]

Hello,
        I've started to use POI to provide data export. I've run into the following
problem using POI 1.5.1 final with jdk 1.4.0. Here is the code I'm running:
int j=0;
try{
        wb.setSheetName(sheetIndex, "Tool Map");
        theRow = theSheet.createRow((short)j);
        theRow.setHeight(( short ) 0x249);
        j++;
        theCell = theRow.createCell((short)0,HSSFCell.CELL_TYPE_STRING);
        theCell.setCellStyle(cs);
        theCell.setCellValue("TOOL ID");
        theCell = theRow.createCell((short)1,HSSFCell.CELL_TYPE_STRING);
        theCell.setCellStyle(cs);
        theCell.setCellValue("OBJECT ID");

        theRow = theSheet.createRow((short)j);
        j++;
        theCell = theRow.createCell((short)0,HSSFCell.CELL_TYPE_STRING);
        theCell.setCellStyle(cs);
        theCell.setCellValue(this.getToolKey(object));
        theCell = theRow.createCell((short)1,HSSFCell.CELL_TYPE_STRING);
        theCell.setCellStyle(cs);
        theCell.setCellValue(this.getPrimaryKey(object));
        sheetCreated = true;
}catch(Exception e){
        System.out.println(e.getMessage());
        e.printStackTrace();
}


the code runs great and produces the excel file as expected, but the rows
are not correct. All I get is:

2451,   object200207091106457542

I'm missing the TOOL ID,OBJECT ID portions. I've used biffview tool and the
SST strings do exist but for some reason they aren't linked into the cells.

I know this is probably some newbie mistake, but any help would be
appriciated.

thanks,
-Jared


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