Fw: Unknown grbit '16'

[Sara Uppalapati <su...@us.ibm.com>]

Please help.

Sara Uppalapati
IBM Global Services
513 277 4869
suppalap@us.ibm.com
----- Forwarded by Sara Uppalapati/Cincinnati/IBM on 04/23/2007 01:10 PM 
-----

Sara Uppalapati/Cincinnati/IBM 
04/23/2007 01:04 PM

To
poi-user-info@jakarta.apache.org
cc

Subject
Unknown grbit '16'





Hi, I am using POI_3.0_Alpha.jar file and trying to read spread sheet and 
getting below errors.  Any ideas?

Before HSSFWorkbook Initiation
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
Method)
        at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.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.java: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.java: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


part of code where it is trying to read spread sheet -
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().

Any help is appreciated.

Sara Uppalapati
IBM Global Services
513 277 4869
suppalap@us.ibm.com