Well I'm at a loss. My guess is you must be swallowing a database exception of some sort or you're not writing out to the file you think you are. Send me (personally) your .java file and I'll look it over and see if there is anything obvious to me. (email the whole thing)
Thanks, Andy Jared Walker wrote: >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]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
