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. > > Sara Uppalapati > IBM Global Services > 513 277 4869 > [EMAIL PROTECTED] > > > > "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/
