Re: POI, Java and RNX0301

I believe POI loads the whole file into memory before it does anything

else.

Maybe the original poster could clarify, but I think this was a case of
building an Excel document vs. processing an existing one.

or change your program to write the file in Open XML. I have never done the

later, but I suppose it should be fairly straight forward.

Here's an XML Excel tutorial I put together for my product RPG-XML Suite:
http://www.rpg-xml.com/2008EmailCampaigns/080108/Jan08.html

Of course you could substitute other text replacement engines in there if
you don't have RPG-XML Suite. Note the finished product only works in
Microsoft Office 2003 and greater. With that said, I don't know how
prevalent Open XML is because there was such controversy about the spec
(worldwide). I get the feeling some groups aren't pursuing it as fast as
they could/should because of the initial controversy.

Back to my hole,
Aaron Bartell
http://mowyourlawn.com

On Wed, Sep 10, 2008 at 10:14 PM, James Perkins <jrperkinsjr@xxxxxxxxx>wrote:

I believe POI loads the whole file into memory before it does anything
else.
I've hit this several times when playing with it in Java. So that could
possibly be the issue. To see if this is the issue you could decrease the
memory on the JVM start-up and see if you get the error sooner.

Now I don't think there is a real good solution for this though. You could
either increase the memory the JVM uses on start-up or change your program
to write the file in Open XML. I have never done the later, but I suppose
it
should be fairly straight forward.

This is all just a guess, so I hope it might help at least a little.

HTH,
James R. Perkins