RE: Getting a file to excel

And if you don't know Java, but still want to use POI (and have plenty of 
time to wait until the program finishes - it's SLOOOOWWWW for large 
files), you can use my tool CPYPF2XLS.

It's hosted by Leif Guldbrand over at http://www.think400.dk/downloads.htm

HTH,

Peter Colpaert
Application Developer
PLI - IT - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----



<Matt.Haas@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
28/06/2006 15:28
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: Getting a file to excel






If you want this to be generated on the iSeries and emailed, you may
want to take a look at POI if you know Java. There are also third party
tools that can do this but I don't use any of them so I have no
recommendations there.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of steema@xxxxxxxxxxxxx
Sent: Wednesday, June 28, 2006 9:23 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Getting a file to excel

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.