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
signature.asc
Description: OpenPGP digital signature
