Re: Getting a file to excel -- RPG400-L

Scott Klement has written several articles also on creating excel files 
from RPG.

With trying to make it hands free - you've got a little more work, as 
you'll have to create it on the iSeries instead of letting client access 
convert it to XLS during the download, But it's still do-able.


Jeff Stevens
Mize, Houser & Co. P.A.
913 451 1882
JStevens@xxxxxxxxxxxxxx





Michael_Schutte@xxxxxxxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
06/28/2006 08:26 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Getting a file to excel






Bob Cozzi (I believe) has a tool for creating excel files.  check out
www.rpgtools.com

Michael Schutte



 
             steema@diskhaven. 
             com 
             Sent by:                                                   To 

             rpg400-l-bounces@         "RPG programming on the AS400 / 
             midrange.com              iSeries" <rpg400-l@xxxxxxxxxxxx> 
                                                                        cc 

 
             06/28/2006 09:23                                      Subject 

             AM                        Re: Getting a file to excel 
 
 
             Please respond to 
              RPG programming 
              on the AS400 / 
                  iSeries 
             <rpg400-l@midrang 
                  e.com> 
 
 




Michael, I think they want it to be hands - free. So it could be emailed
to them. Is there a easy way to do this?

I have users, go to

Tools --> Transfer Data from iSeries.   Then have them select a data
transfer request that is saved to their personal network drive. It's

been

awhile, but if I remember correctly... the file doesn't even have to be
CSV, just a regular database file.

Michael Schutte




             steema@diskhaven.
             com
             Sent by:

To

             rpg400-l-bounces@         rpg400-l@xxxxxxxxxxxx
             midrange.com

cc

                                       midrange-l@xxxxxxxxxxxx

Subject

             06/28/2006 09:16          Getting a file to excel
             AM


             Please respond to
              RPG programming
              on the AS400 /
                  iSeries
             <rpg400-l@midrang
                  e.com>






HI What are some of the methods in taking a file that was generated by

an

RPG program and getting it to the user in an Excel Worksheet file?

It seems to be a straightforward file. Is there a preferred method. Any
issues w/ v5.3 and the client access ?

Thanks,
Steve
--
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.


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