Help! "Invalid header signature"?

[Phil Desrosiers <ph...@airborne-e.com>]

I'm getting the following error when attempting to instantiate a
POIFSFileSystem using a correctly opened inputStream to my Excel file. I
have previously used the exact same code on multiple occasions, with no
problem, so I'm assuming this is an issue with my Excel file. Can anyone
help me?

java.io.IOException: Invalid header signature; read 7888090397404325948,
expected -2226271756974174256
        at
org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.java
:88)
        at
org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:
83)

-----Original Message-----
From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com] 
Sent: Wednesday, November 17, 2004 12:37 PM
To: 'POI Users List'
Subject: AW: Large Excel Files and java.lang.OutOfMemoryError

Hi Dave.

Then you'ld have to use the event model which is quite different from the
user model.

Regards,	Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: Hamu, Dave [mailto:Dave.Hamu@Avnet.com]
Gesendet: Mittwoch, 17. November 2004 18:30
An: POI Users List
Betreff: RE: Large Excel Files and java.lang.OutOfMemoryError

Yes.  This is my greatest concern.

- Dave 

-----Original Message-----
From: Pravin Pillai [mailto:Pravin.Pillai@neoforma.com]
Sent: Wednesday, November 17, 2004 10:29 AM
To: POI Users List; karl-heinz.zengerle@sawag.com
Subject: RE: Large Excel Files and java.lang.OutOfMemoryError

If ur memory setting is so high, none of the other processes on ur machine
will be able to run. U might end up crashing something else. 

-----Original Message-----
From: Hamu, Dave [mailto:Dave.Hamu@Avnet.com]
Sent: Wednesday, November 17, 2004 6:33 AM
To: POI Users List; karl-heinz.zengerle@sawag.com
Subject: RE: Large Excel Files and java.lang.OutOfMemoryError

Karl-Heinz,

Thank you.  This suggestion worked.  However, I remain concerned that it
will not be a wholly reliable solution, because I've yet to attempt the
largest file that I have to work with to meet the requirements of my
application.  My largest file must support about 65K rows  (32 columns
wide) spread across 5 tabs.

In order to meet the memory needs of 41K of these rows, I had to set the
-Xmx setting to 2048m!!!  Thoughts?

It seems that the next version of POI-HSSF needs to invest some time in
memory management.

Thanks again,

David 

-----Original Message-----
From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com]
Sent: Wednesday, November 17, 2004 2:42 AM
To: 'POI Users List'
Subject: AW: Large Excel Files and java.lang.OutOfMemoryError

Hi Dave.

E.g. -Xmx256m (or more). In Eclipse you would declare it per main(). In
Tomcat it would be in a configuration file.

In other systems it would surely work similar.

Regards,	Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: Hamu, Dave [mailto:Dave.Hamu@Avnet.com]
Gesendet: Dienstag, 16. November 2004 23:11
An: poi-user@jakarta.apache.org
Betreff: Large Excel Files and java.lang.OutOfMemoryError

I have noticed that several people have run into this problem, but I have
not found any solutions.

In short, I receive a java.lang.OutOfMemoryError when I am writing
particularly large Excel Files (several thousand rows of data).  Has anyone
found a clean solution to this problem that does not involve adding more
memory (I have 3Gig on my workstation).


- Dave



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org