Hello all,
I'm currently using an old version of POI, (namely 2.5.1) and I'm having
a problem with an excel file. I'm getting a few different kinds of
exceptions:
1) Caused by: java.lang.ArrayIndexOutOfBoundsException
2) org.apache.poi.hssf.record.RecordFormatException: Unable to
construct record instance, the following exception occured: null
3) java.lang.reflect.InvocationTargetException
For some reason the other XL files work fine. These exceptions happen
in POI code and I don't know how to fix the xl file. Can anyone help me
with this?
Here's some of the full exeption list:
[java] java.lang.reflect.InvocationTargetException
[java] at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[java] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
[java] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
[java] at
java.lang.reflect.Constructor.newInstance(Constructor.java:494)
[java] at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java
:224)
[java] at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav
a:160)
[java] at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163)
[java] at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130)
[java] at
org.snbw.util.excel.ExcelConnection.readWorkbook(ExcelConnection.java:20
6)
[java] at
org.snbw.util.excel.ExcelConnection.<init>(ExcelConnection.java:43)
[java] at
org.snbw.monthly_tasks.shelter.ParseShelterResidents.<init>(ParseShelter
Residents.java:30)
[java] at
org.snbw.monthly_tasks.shelter.ParseShelterResidents.main(ParseShelterRe
sidents.java:117)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
[java] at
java.lang.reflect.Method.invoke(Method.java:585)
[java] at
org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:202)
[java] at
org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:134)
[java] at
org.apache.tools.ant.taskdefs.Java.run(Java.java:710)
[java] at
org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:178)
[java] at
org.apache.tools.ant.taskdefs.Java.execute(Java.java:84)
[java] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[java] at
org.apache.tools.ant.Task.perform(Task.java:364)
[java] at
org.apache.tools.ant.Target.execute(Target.java:341)
[java] at
org.apache.tools.ant.Target.performTasks(Target.java:369)
[java] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[java] at
org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[java] at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecut
or.java:40)
[java] at
org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[java] at
org.apache.tools.ant.Main.runBuild(Main.java:668)
[java] at
org.apache.tools.ant.Main.startAnt(Main.java:187)
[java] at
org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[java] at
org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
[java] Caused by: java.lang.ArrayIndexOutOfBoundsException
[java] at java.lang.System.arraycopy(Native Method)
[java] at
org.apache.poi.hssf.record.UnknownRecord.<init>(UnknownRecord.java:62)
[java] at
org.apache.poi.hssf.record.SubRecord.createSubRecord(SubRecord.java:57)
[java] at
org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:99)
[java] at
org.apache.poi.hssf.record.Record.fillFields(Record.java:90)
[java] at
org.apache.poi.hssf.record.Record.<init>(Record.java:55)
[java] at
org.apache.poi.hssf.record.ObjRecord.<init>(ObjRecord.java:61)
[java] ... 33 more
John Byrne
Support Network for Battered Women
(408) 541-6100 x 138
Fax: (408) 541-3333
