RE: Exporting to Excel

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