Ah, sorry, I should have used some caps when i wrote my message or something. What I was saying is that the small class I just wrote works GREAT, it does exactly what the code should do. The problem is that the production code I'm using (which I emailed earlier if you need it again ask) does not work. For some reason it decides not to create the first row I want with the cells "TOOL ID" and "OBJECT ID". I haven't a clue whats going on. Like I said earlier, when I did a biffview the strings were there, but weren't linked in to any cell. I didn't try explicitly casting the values as strings and that didn't help either.
thanks, -Jared -----Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:14 PM To: POI Users List Subject: Re: Cell content not saving One question. You're using setValue and passing a *double* to a String Cell. (which I think its a bug that HSSF isn't throwing an exception or something). If you do setValue((""+1234)) what happens? (or even create a NUMERIC cell) -Andy Jared Walker wrote: >Hello all, > I made this small test class to see if I could isolate the problem I'm >having. The test class seems to work fine when it is run by itself, however >my original code still has problems. I do not understand the differences >between this test case and my production code. Perhaps its an underlying API >issue? I've also tried this with the 1.7 dev release and I get the same >behavior. Anyone got any ideas at all? > >test class: >import java.util.List; >import java.util.Iterator; >import java.util.ResourceBundle; >import java.io.BufferedInputStream; >import java.io.IOException; >import java.io.FileWriter; >import java.io.File; >import java.io.FileOutputStream; >import java.io.FileInputStream; >import java.util.zip.ZipOutputStream; >import java.util.zip.ZipEntry; > >import org.apache.poi.hssf.usermodel.HSSFSheet; >import org.apache.poi.hssf.usermodel.HSSFRow; >import org.apache.poi.hssf.usermodel.HSSFCell; >import org.apache.poi.hssf.usermodel.HSSFWorkbook; >import org.apache.poi.hssf.usermodel.HSSFCellStyle; >import org.apache.poi.hssf.usermodel.HSSFFont; > >class textExport{ > > public static void main(String args[]) throws IOException { > > // create a new workbook > HSSFWorkbook wb = new HSSFWorkbook(); > // create a new sheet > HSSFSheet theSheet = wb.createSheet(); > // declare a row object reference > HSSFRow theRow = null; > // declare a cell object reference > HSSFCell theCell = null; > // create cell style > HSSFCellStyle cs = wb.createCellStyle(); > // create font object > HSSFFont f = wb.createFont(); > f.setFontHeightInPoints((short) 10); > //set cell stlye > cs.setFont(f); > wb.setSheetName(0, "Tool Map"); > > int j=0; > > theRow = theSheet.createRow((short)j); > theRow.setHeight(( short ) 0x249); > > System.out.println("Row created at :"+j); > System.out.println("Row is actually: "+theRow.getRowNum()); > > 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); > > System.out.println("Row created at :"+j); > System.out.println("Row is actually: "+theRow.getRowNum()); > > j++; > > theCell = theRow.createCell((short)0,HSSFCell.CELL_TYPE_STRING); > theCell.setCellStyle(cs); > theCell.setCellValue(12343); > > theCell = theRow.createCell((short)1,HSSFCell.CELL_TYPE_STRING); > theCell.setCellStyle(cs); > theCell.setCellValue("HELLO" + 123425423); > > File file = new File("export.xls"); > > file.delete(); > > FileOutputStream out = new FileOutputStream(file); > > wb.write(out); > > out.close(); > } > >} > >thanks, >-Jared > >-----Original Message----- >From: Jared Walker [mailto:[EMAIL PROTECTED]] >Sent: Monday, July 22, 2002 4:00 PM >To: 'POI Users List' >Subject: RE: Cell content not saving > > >Heres the stuff: > >Shamelessly ripped from the test class: > // create a new workbook > HSSFWorkbook wb = new HSSFWorkbook(); > // create a new sheet > HSSFSheet theSheet = wb.createSheet(); > // declare a row object reference > HSSFRow theRow = null; > // declare a cell object reference > HSSFCell theCell = null; > // create cell style > HSSFCellStyle cs = wb.createCellStyle(); > // create font object > HSSFFont f = wb.createFont(); > f.setFontHeightInPoints((short) 10); > //set cell stlye > cs.setFont(f); > >Then to write it out: > File file = new File(fileRoot+"export.xls"); > FileOutputStream out = new FileOutputStream(file); > wb.write(out); > >Straight and simple... and probably wrong. > >thanks, >-Jared > >-----Original Message----- >From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] >Sent: Monday, July 22, 2002 3:53 PM >To: POI Users List >Subject: Re: Cell content not saving > > >Show me the code you used to instantiate the workbook and write it back >to disk. > >-Andy. > >Jared Walker wrote: ><-----SNIP----> > > >-- >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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
