Re: Using POI Java Classes

[MWalter@xxxxxxxxxxxxxxx]

I should add that I am at V5R2.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                           
             "Beppe                                                        
             Costagliola"                                                  
             <beppecosta@yahoo                                          To 
             .it>                      "RPG programming on the AS400 /     
             Sent by:                  iSeries" <rpg400-l@xxxxxxxxxxxx>    
             rpg400-l-bounces@                                          cc 
             midrange.com                                                  
                                                                   Subject 
                                       Re: Using POI Java Classes          
             05/31/2005 10:15                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




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.
>

--
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.