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" <tahir@spec...>
> 04/25/2007 01:52 AM
> Please respond to
> "POI Users List" <poi-user@jaka...>
>
>
> To
> "'POI Users List'" <poi-user@jaka...>
> 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:suppalap@us.i...]
>> 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
>> suppalap@us.i...
>>
>>
>>
>> "Justin Warren" <justin_warren@cons...>
>> 04/24/2007 03:20 PM
>> Please respond to
>> "POI Users List" <poi-user@jaka...>
>>
>>
>> To
>> "POI Users List" <poi-user@jaka...>
>> 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:suppalap@us.i...]
>> Sent: Tuesday, April 24, 2007 2:53 PM
>> To: poi-user@jaka...
>> 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: poi-user-unsubscribe@jaka...
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>>    
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jaka...
> 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: poi-user-unsubscribe@jaka...
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/