Hi world.
Without shelter measures we receive an out of memory error now.
So I've the following questions:
Which Excel things doesn't POI allow?
Up to about what size normally Excel files can be opened without
increasing the Java VM memory and without having problems?
Regards, Karl-Heinz.
-----Urspr�ngliche Nachricht-----
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 15. M�rz 2004 16:42
An: [EMAIL PROTECTED]
Betreff: can't open workbook
Hi world,
When our application processed the following command
this.oiWB = new HSSFWorkbook(fs);
the exception below is thrown.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java
:257)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav
a:193)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:207)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:174)
<-- POI
at webCRT.XlCRTImport.<init>(XlCRTImport.java:120)
<-- our application
at webCRT.XlCRTImport.importCRTFile(XlCRTImport.java:324)
at webCRT.XlCRTTstImp.TestImportFiles(XlCRTTstImp.java:275)
at webCRT.XlCRTImport.main(XlCRTImport.java:186)
Caused by: java.lang.IllegalArgumentException: Illegal length
at
org.apache.poi.util.StringUtil.getFromUnicodeHigh(StringUtil.java:114)
at
org.apache.poi.hssf.record.FontRecord.fillFields(FontRecord.java:172)
at org.apache.poi.hssf.record.Record.fillFields(Record.java:127)
at org.apache.poi.hssf.record.Record.<init>(Record.java:92)
at
org.apache.poi.hssf.record.FontRecord.<init>(FontRecord.java:125)
... 12 more
Does anybody have an idea of possible reasons? Opening the workbook is
the first POI action. So it can't be in our application.
Since several months small files where all sheets are visible and not
locked in any way the application runs without problems. Now the Excel
file has grown very much (around our basic handling) and some sheets are
hidden and some sheets are locked.
Regards,
Karl-Heinz Zengerle
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
