Re: Exporting to Excel

[MWalter@xxxxxxxxxxxxxxx]

It just so happens that I've been working on moving some of our reports
from printed output to Excel using the POI Java classes. I downloaded Scott
Klement's HSSF Service program and I have to tell you, once I got the hang
of it, it is simply outstanding. Very easy to do. If you'd like to give
this a shot, I could send you some examples.

Otherwise, you could try CPYTOSTMF as a comma delimited text and open that
in Excel. Or if you're using iSeries Access, you could do a file transfer
within Excel.

Thanks,

Mark

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


                                                                           
             "Douglas W.                                                   
             Palme"                                                        
             <dpalme@xxxxxxxxx                                          To 
             om>                       "RPG Group" <rpg400-l@xxxxxxxxxxxx> 
             Sent by:                                                   cc 
             rpg400-l-bounces+                                             
             mwalter=hanoverwi                                     Subject 
             re.com@xxxxxxxxxx         Exporting to Excel                  
             om                                                            
                                                                           
                                                                           
             05/27/2005 08:11                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




Some of our users are wanting their reports exported to excel......I am
sure
I am not the first to have this request, so I would like to hear how others

have accomplished this.

Thanks....

Douglas

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