Hi Regis. Make a countertest using POI 2.0.
Regards, Karl-Heinz. Am Do 03.02.2005 12:34 schrieb CABARET Regis <[EMAIL PROTECTED]>: > 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/ > > --------------------------------------------------------------------- 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/
