Hi all,
I am trying to read a MS Excel file through my POI code. The file contains Filters, Macros & Pivot tables. By trying to do so, I get an "InvocationTargetException" when I try to instantiate a new workbook, with an instance of "POIFSFileSystem" class. My code is something like: public static synchronized HSSFWorkbook getWorkbook(String filePath) throws FileNotFoundException, IOException { FileInputStream fis = new FileInputStream(filePath); InputStream inputStream = new BufferedInputStream(fis); POIFSFileSystem fs = new POIFSFileSystem(fis); HSSFWorkbook workbook = new HSSFWorkbook(fs); inputStream.close(); return workbook; } The stack trace is as follows: [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R java.lang.reflect.InvocationTargetException: java.lang.ArrayIndexOutOfBoundsException [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at java.lang.System.arraycopy(Native Method) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.record.UnknownRecord.<init>(UnknownRecord.java:62) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.record.SubRecord.createSubRecord(SubRecord.java:57) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:99) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.record.Record.fillFields(Record.java(Compiled Code)) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.record.Record.<init>(Record.java(Compiled Code)) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.record.ObjRecord.<init>(ObjRecord.java:61) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at java.lang.reflect.Constructor.newInstance(Native Method) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java (Compiled Code)) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav a(Compiled Code)) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163) [5/3/07 12:02:19:003 IST] 26b9ee4c SystemErr R at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130) Is its possible to bypass the problem? Thanks for your time. With best regards, Anjishnu. **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***