Show me the code you used to instantiate the workbook and write it back
to disk.
-Andy.
Jared Walker wrote:
>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]>
>
>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
