Re: POI, Java and RNX0301

["Aaron Bartell" <aaronbartell@xxxxxxxxx>]

> 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