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 <[EMAIL PROTECTED]> 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 > > > >
