I found an XLS file that throws an Exception when read: D:\temp4>java -classpath .;D:\eclipsews\gatepost\poke-post\tools\poi-2.5.1-final-20040804.jar Test D:\eclipsews\gatepost\poke-post\tools\PokTCG.xls java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:80) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java(Compiled Code)) at java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled Code)) at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java(Compiled Code)) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java(Compiled Code)) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130) at Test.main(Test.java:12) Caused by: java.lang.ArrayIndexOutOfBoundsException at java.lang.System.arraycopy(Native Method) at org.apache.poi.hssf.record.UnknownRecord.<init>(UnknownRecord.java:62) at org.apache.poi.hssf.record.SubRecord.createSubRecord(SubRecord.java:57) at org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:99) at org.apache.poi.hssf.record.Record.fillFields(Record.java(Compiled Code)) at org.apache.poi.hssf.record.Record.<init>(Record.java(Compiled Code)) at org.apache.poi.hssf.record.ObjRecord.<init>(ObjRecord.java:61) ... 9 more Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the following exception occured: null at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java(Compiled Code)) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java(Compiled Code)) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130) at Test.main(Test.java:12)
The source for Test.java which demonstrates this failure is: import java.io.FileInputStream; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem; public class Test { public static void main(String[] args) throws Exception { String filename = args[0]; FileInputStream fis = new FileInputStream(filename); POIFSFileSystem fs = new POIFSFileSystem(fis); HSSFWorkbook hssfwb = new HSSFWorkbook(fs); } } Since I'm not sure how well attachments make it through this mailing list, the XLS file is the only content of: http://www.pokepedia.net/pokTCG.zip I can export this file in CSV format and use other tools to read it, but it sure would be nice to read the XLS directly! Chris Internet: [EMAIL PROTECTED]