With this piece of code I can't figure out what's the problem; could you send more 
code ( declaration of oiWB, fs and so on) ?

-----Mensaje original-----
De: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] 
Enviado el: Miércoles, 17 de Marzo de 2004 08:15 a.m.
Para: 'POI Users List'
Asunto: AW: can't open workbook

Hi world.

We could improve the situation to the following one:

        The things are running being called from a JSP page.
        Being run or debugged in Ecplipse it still crashes with the out
of
        memory error whatever VM memory we use.

All that happens at
      this.oiWB = new HSSFWorkbook(fs);
i.e. when opening the Excel file and not having processed anything in
our application.

Does anybody have a further idea?

Regards,        Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] 
Gesendet: Montag, 15. März 2004 16:52
An: 'POI Users List'
Betreff: AW: can't open workbook

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]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to