Update. After working with Jared, we established this was an application error rather than a problem with POI.
On Tue, 2002-07-23 at 13:43, 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]> > -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
