Hi,
I am using POI to convert an Excel file containing multiple worksheets into an
ASCII file that is
to be loaded into a database.
The Excel file has one worksheet with two pull-down lists for the user to
select some parameters.
If I try to open this workbook with POI HSSF, it throws an exception:
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:274)
at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:224)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:160)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:210)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:191)
at utils.TransformExcelWkToAscii.<init>(TransformExcelWkToAscii.java:25)
at test.main(test.java:6)
Caused by: java.lang.IllegalArgumentException: Illegal length
at org.apache.poi.util.StringUtil.getFromUnicodeHigh(StringUtil.java:76)
at org.apache.poi.hssf.record.FontRecord.fillFields(FontRecord.java:135)
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.FontRecord.<init>(FontRecord.java:88)
... 11 more
Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException:
Unable to construct
record instance, the following exception occured: nul
l
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:163)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:210)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:191)
at utils.TransformExcelWkToAscii.<init>(TransformExcelWkToAscii.java:25)
at test.main(test.java:6)
However, if I remove the drop down lists, then it works fine.
Any suggestion to solve this problem would be welcomed.
Thanks.
Regis
=====
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
---------------------------------------------------------------------
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/
