RE: Exporting to Excel

["Bob Anderson" <banderson@xxxxxxxxxxxxxxxxxxx>]

Mark,

        Would you be so kind as to also send them to

banderson  at  kentwatersports  dot  com

Thanks
Bob Anderson
IT Guy
Kent Sporting Goods Inc.
New London OH
Ph: 419-929-7021 x315
Fax: 419-929-1380


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On
Behalf Of MWalter@xxxxxxxxxxxxxxx
Sent: Friday, May 27, 2005 9:01 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Exporting to Excel


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.



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


--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 267.0.0 - Release Date: 5/27/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 267.0.0 - Release Date: 5/27/2005