poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Barlock <barl...@us.ibm.com>
Subject Exception Reading XLS File
Date Thu, 21 Dec 2006 01:56:38 GMT
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:  barlock@us.ibm.com
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message