Turns out, one of my tabs was corrupted. I made a new tab, copied over the contents of the old tab, deleted the old tab then renamed the new tab to the old tab name. Now it works.
-----Original Message----- From: Dobson, Paul L CTR USAF AFMC 416 SCMS/OBN [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2008 1:38 PM To: POI Users List Subject: RE: IllegalStateException: "Cannot create value records before row records exist" Sorry, I forgot to include the stack trace. java.lang.IllegalStateException: Cannot create value records before row records exist at org.apache.poi.hssf.model.Sheet.checkCells(Sheet.java:497) at org.apache.poi.hssf.model.Sheet.createSheet(Sheet.java:335) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:257) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:169) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:151) I have a program that was working great with I think with POI 2.5. Right after upgrading to poi-3.1-FINAL-20080629, I get an IllegalStateException: "Cannot create value records before row records exist" when executing the following lines: POIFSFileSystem tmpFs = new POIFSFileSystem(new FileInputStream(masterPath)); // masterPath is a String HSSFWorkbook tmpWb = new HSSFWorkbook(tmpFs); I found the following which I guess may or may not be related to this problem. http://www.mail-archive.com/[EMAIL PROTECTED]/msg00622.html https://issues.apache.org/bugzilla/show_bug.cgi?id=45145 In the bug report it says "Re-serializing a workbook fixes the incorrect INDEX record." How does one go about "Re-serializing" a workbook? Any ideas on other possible workarounds? Many thanks for any input. Paul --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
