error while reading excel file through poi 3.0.2 Final

[sunil tiwari]

Hi 

I am using poi 3.0.2 Final .jar ,

While reading an excel file which has lot's of drop down type of fields it
is giving exception bellow

 

Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException:
Unable to construct record instance

      at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:199
)

      at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:11
7)

      at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:207)

      at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:148)

      at com.hedder.main(hedder.java:29)

Caused by: java.lang.reflect.InvocationTargetException

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)

      at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)

      at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:187
)

      ... 4 more

Caused by: java.lang.ArrayIndexOutOfBoundsException

      at
org.apache.poi.hssf.record.RecordInputStream.checkRecordPosition(RecordInput
Stream.java:132)

      at
org.apache.poi.hssf.record.RecordInputStream.readShort(RecordInputStream.jav
a:152)

      at
org.apache.poi.hssf.util.HSSFCellRangeAddress.fillFields(HSSFCellRangeAddres
s.java:77)

      at
org.apache.poi.hssf.util.HSSFCellRangeAddress.<init>(HSSFCellRangeAddress.ja
va:65)

      at org.apache.poi.hssf.record.DVRecord.fillFields(DVRecord.java:207)

      at org.apache.poi.hssf.record.Record.<init>(Record.java:55)

      at org.apache.poi.hssf.record.DVRecord.<init>(DVRecord.java:134)

      ... 9 more

 

Can anybody give me solution for it

We are shaped and fashioned by what we love.

Regards,

sunil tiwari