Re: POI, Java and RNX0301 -- RPG400-L

Arron,
I thought he was writing it as well, but that could still give you a out of
memory error. I believe this is why, can't remember for sure, I determined
that POI loads the whole spread sheet into memory. I wrote a class to write
a ResultSet to a spreadsheet and would occasionally get an out of memory
error. In these cases, as far as I can remember, the spreadsheets were never
written.

Anyhow, thanks for the link to the XML tip. I'm not really a fan either of
Open XML because OpenOffice and other have been using a different one for a
while. It would be nice to have a standard so tools like RPG-XML suite could
easily be used to write spreadsheets for ANYONE to open.

Now that I'm totally off topic, I'll just quit writing now ;-)

--
James R. Perkins

On Thu, Sep 11, 2008 at 4:11 AM, Aaron Bartell <aaronbartell@xxxxxxxxx>wrote:

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

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.