Re: Using POI Java Classes

I use POI to create a workbook from scratch with one sheet.
Then I open it and I add another sheet. And so on.
Each sheet has his own number of columns, formatting, header, etc.

Actually I didn't find the caveats you are seeing.

This works fine using POI classes both with RPG and pure Java.

The only serious problem that - in my opinion - makes pure Java much better
than mixed RPG+Java is that RPG is good only for small xls (say 1,000 rows)
and useless mof medium-big sheets. Furthermore when you start the JVM from
RPG the threaded jobs remains on until you sign off. You can terminate the
Jvm but at 5.3 you can't restart it anymore.

Beppe.


----- Original Message ----- 
From: <MWalter@xxxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, May 31, 2005 4:02 PM
Subject: Using POI Java Classes


> Ok,
>
> I've been very successful at using the HSSF classes to create spreadsheets
> from within RPG. But, I have found a couple of caveats.
>
> 1) If you create a workbook in one job, then use hssf_open to try to add
> another worksheet within another job, you get an ioexception.
> 2) If you create a workbook and save it. Then use hssf_open to try to add
> another worksheet from within the same job, the worksheet is added, but
any
> cell formatting is ignored.
>
> Has anyone else experienced these little bits of annoyance?
>
> Thanks,
>
> Mark
>
> Mark D. Walter
> Senior Programmer/Analyst
> CCX, Inc.
> mwalter@xxxxxxxxxx
> http://www.ccxinc.com
>
> -- 
> 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.
>