I've not experienced that with any excel I've saved with Excel. I have
seen that other office programs actually save some records in the 95
format which does cause this error. However if that is true we should
fix it and support alternative record lengths for newer stuff. This is
easy to look at. Just change biffviewer and comment out records so that
you get UnknownRecord instead of Bof and then look at the hex dumps.
Tom Schindl wrote:
I think that your problem is that the XLS is saved into a too new format
I think I can remember this exception when loading Spreadsheets created
with a new excel and saved them to the current excel format. Try saving
it as Excel an older Excel Format.
Tom
Nick Heudecker wrote:
I'm encountering the following exception when I upload an Excel spreadsheet
created by Outlook:
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(
NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at org.apache.poi.hssf.record.RecordFactory.createRecord(
RecordFactory.java:237)
at org.apache.poi.hssf.record.RecordFactory.createRecords(
RecordFactory.java :160)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java
:183)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java
:230)
at org.apache.poi.hssf.usermodel.HSSFWorkbook .<init>(HSSFWorkbook.java
:211)
at example.service.impl.ContactServiceImpl.uploadContacts(
ContactServiceImpl.java:137)
// WEB STACK OMITTED
Caused by: java.lang.ArrayIndexOutOfBoundsException: 11
at org.apache.poi.util.LittleEndian.getNumber(LittleEndian.java:491)
at org.apache.poi.util.LittleEndian.getInt(LittleEndian.java:139)
at org.apache.poi.hssf.record.BOFRecord.fillFields(BOFRecord.java:133)
at org.apache.poi.hssf.record.Record.fillFields(Record.java:90)
at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
at org.apache.poi.hssf.record.BOFRecord.<init>(BOFRecord.java:98)
... 48 more
I don't seem to have this problem if I open the spreadsheet and save it
before uploading. However, it dies if I try to process the file straight
from Outlook. I save the entire file to a temp location before trying to
process it.
I realize this is a little off the wall, but any help would be appreciated.
Worst case, I'll fall back to CSV format.
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.1/278 - Release Date: 09.03.2006
--
Andrew C. Oliver
SuperLink Software, Inc.
Java to Excel using POI
http://www.superlinksoftware.com/services/poi
Commercial support including features added/implemented, bugs fixed.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
