I tried deleting all tabs in the excel file step by step and tried at last with no data also and I still have same error. But when I try create empty excel on my machine(office 2000) and used it, program works fine. Could this be the issue with office 2003 compatibility? If it is, any patches available? I am confused because it is failing even with no data in the file that was created/updated on the machine which has office 2003. Since no data and no array formulas, I don't understand why it is still going to Ptg and ArrayPtg and calling readTokenValues().
FYI - I am testing now latest poi jar file (poi-3.0-rc3-20070402.jar.) Please help. Thanks for your help. Sara Sara Uppalapati/Cincinnati/IBM 04/25/2007 12:42 PM To "POI Users List" <poi-user@jakarta.apache.org> cc POI Users List <poi-user@jakarta.apache.org> Subject Re: Please help - unknown grbit '16' I tried with latest rc file - "poi-3.0-rc3-20070402.jar". Now I am getting below exception - similar one but only last line from the old exceptions. Before HSSFWorkbook Initiation Error in Reading : org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance "Andrew C. Oliver" <[EMAIL PROTECTED]> 04/25/2007 11:26 AM Please respond to "POI Users List" <poi-user@jakarta.apache.org> To POI Users List <poi-user@jakarta.apache.org> cc Subject Re: Please help - unknown grbit '16' the 2000 format should be okay. IF this is Excel 2000. The grbit sounds like something we don't support in included graphics. Try with the latest RC and go from there. Sara Uppalapati wrote: > I don't see just 97-2000 option in the save type drop down. I also tried > save as type Mirosft excel workbook (*.xls) with no luck - assumed that > has to be Excel 2000 format since I have office 2000. > > > > > "Andrew C. Oliver" <[EMAIL PROTECTED]> > 04/25/2007 09:53 AM > Please respond to > "POI Users List" <poi-user@jakarta.apache.org> > > > To > POI Users List <poi-user@jakarta.apache.org> > cc > > Subject > Re: Please help - unknown grbit '16' > > > > > > > That means it saved as a pre 1997 version of excel file format. HSSF > only supports Biff8+ (Excel97 + not 5.0/95 which is different) > > Sara Uppalapati wrote: > >> Hi Tahir, Thanks for your response. I opened user's version of excel >> file on my machine(which has office 2000) and saved as of type Microsoft >> > > >> Excel 97-2000 & 5.0/95 Workbook. I am still geting same errors when I >> tried to run my program with that excel file. >> >> Sara >> >> >> >> >> "Tahir Akhtar" <[EMAIL PROTECTED]> >> 04/25/2007 01:52 AM >> Please respond to >> "POI Users List" <poi-user@jakarta.apache.org> >> >> >> To >> "'POI Users List'" <poi-user@jakarta.apache.org> >> cc >> >> Subject >> RE: Please help - unknown grbit '16' >> >> >> >> >> >> >> It could be because of version incompatibility. May be user machine have >> upgraded to newer version of excel. Try opening the file in excel and >> save-as a new file paying attention to format (Excel 97 etc). Then try >> running your program on newly saved file. >> >> >> >>> -----Original Message----- >>> From: Sara Uppalapati [mailto:[EMAIL PROTECTED] >>> Sent: Tuesday, April 24, 2007 11:28 PM >>> To: POI Users List >>> Cc: POI Users List >>> Subject: RE: Please help - unknown grbit '16' >>> >>> Hi Justin, Thank you very much for the response. This Excel file is >>> >>> >> not >> >> >>> password protected. I double checked. >>> >>> FYI - My application runs on HP UX and downloads the excel file >>> > everyday > >>> from user machine(Windows) and reads it. >>> >>> >>> >>> >>> >>> "Justin Warren" <[EMAIL PROTECTED]> >>> 04/24/2007 03:20 PM >>> Please respond to >>> "POI Users List" <poi-user@jakarta.apache.org> >>> >>> >>> To >>> "POI Users List" <poi-user@jakarta.apache.org> >>> cc >>> >>> Subject >>> RE: Please help - unknown grbit '16' >>> >>> >>> >>> >>> >>> >>> I get a similar error when I attempt to read a password protected Excel >>> file. I'm not sure if that's what you have, but it's a possibility. >>> >>> -----Original Message----- >>> From: Sara Uppalapati [mailto:[EMAIL PROTECTED] >>> Sent: Tuesday, April 24, 2007 2:53 PM >>> To: poi-user@jakarta.apache.org >>> Subject: Please help - unknown grbit '16' >>> >>> Hi, We are using POI_3.0_Alpha.jar file and trying to read spread >>> > sheet > >>> in the code. It was working fine until few days back. Spread sheet >>> > was > >>> updated with more tabs and more data and after that getting below >>> errors. >>> I spent long time and still no clue. Spread sheet was updated on >>> windows >>> machine with office 2003. Please help. >>> >>> Exceptions: >>> java.lang.reflect.InvocationTargetException >>> at >>> > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > >>> Method) >>> at >>> >>> > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA > >>> ccessorImpl.java:39) >>> at >>> >>> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons > >>> tructorAccessorImpl.java:27) >>> at >>> java.lang.reflect.Constructor.newInstance(Constructor.java:274) >>> at >>> >>> > org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java > >>> :213) >>> at >>> >>> > org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav > >>> a:149) >>> at >>> >>> > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:183) > >>> at >>> >>> > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:230) > >>> at >>> >>> > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:211) > >>> at ReadInvSheet.main(ReadInvSheet.java:47) >>> Caused by: org.apache.poi.hssf.record.RecordFormatException: Unknown >>> grbit >>> '16' >>> at >>> >>> > org.apache.poi.hssf.record.formula.ArrayPtg.readTokenValues(ArrayPtg.jav > >>> a:98) >>> at >>> >>> > org.apache.poi.hssf.record.formula.Ptg.createParsedExpressionTokens(Ptg. > >>> java:109) >>> at >>> org.apache.poi.hssf.record.NameRecord.fillFields(NameRecord.java:739) >>> at org.apache.poi.hssf.record.Record.<init>(Record.java:55) >>> at >>> org.apache.poi.hssf.record.NameRecord.<init>(NameRecord.java:142) >>> ... 10 more >>> Error in Reading : org.apache.poi.hssf.record.RecordFormatException: >>> Unable to c >>> onstruct record instance, the following exception occured: null >>> >>> >>> Code snippet: >>> try >>> { >>> fs = new FileInputStream(fileToBeRead); >>> System.out.println(" file read" ); >>> FI = new FileInputStream(propertyFile) ; >>> FW = new FileWriter(fileToBeWritten); >>> } >>> catch(FileNotFoundException e) >>> { >>> throw new Exception(e); >>> } >>> catch(IOException e) >>> { >>> throw new Exception(e); >>> } >>> System.out.println("Before HSSFWorkbook Initiation"); >>> HSSFWorkbook workbook = new HSSFWorkbook(fs); >>> System.out.println("After HSSFWorkbook Initiation"); >>> >>> >>> Exception are right at initializing HSSFWorkbook() - HSSFWorkbook >>> workbook >>> = new HSSFWorkbook(fs); >>> >>> I really appreciate the help. >>> >>> Thanks, >>> Sara >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>> Mailing List: http://jakarta.apache.org/site/mail2.html#poi >>> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ >>> >>> >>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> Mailing List: http://jakarta.apache.org/site/mail2.html#poi >> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ >> >> >> >> >> > > > -- Catch us at Linuxfest Northwest (4/28-4/29) http://linuxfestnorthwest.org Buni Meldware Communication Suite Email, Calendaring, ease of configuration/administration http://buni.org --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
