You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Tom Schindl <to...@gmx.at> on 2006/03/09 21:47:24 UTC
Re: HSSF - Exception thrown when processing Outlook export
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
Re: HSSF - Exception thrown when processing Outlook export
Posted by "Andrew C. Oliver" <ac...@apache.org>.
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: HSSF - Exception thrown when processing Outlook export
Posted by Nick Heudecker <nh...@gmail.com>.
Tom,
I think you're right. I'm going to have to switch to CSV. Thanks for your
help.
On 3/9/06, Tom Schindl <to...@gmx.at> 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
>
>
>
>