RE: Exporting to Excel

["Sara, Richard" <richard.sara@xxxxxxxxxxxxx>]

I customarily create a pre-formatted output data file with all numeric
columns pre-editted as alpha's (using ILE BIF's) to a regular dds file. Then
I use the CPYTOIMPF  cmd as shown below

CPYTOIMPF  FROMFILE(QTEMP/&XLFILENAME) +                  
    TOSTMF('/HOME/EMAIL/EMAILFIL1.CSV') +                 
    RCDDLM(*CRLF) STMFCODPAG(*PCASCII) MBROPT(*REPLACE)   
                                                          

Then I email via the sndemail utility (I think it is a taatool's utility)

              SNDEMAIL   FILENAME(&EMAILFILE1) RECIPADDR(&EMAILADDR) + 
                         RECIPNAME('*REQUESTOR  ') +                   
                         SENDERADDR('E-CommerceSupport@xxxxxx')
SENDERNAME('eCommerce') +         
                         ATTACHMENT(&ATTACHMNT1) +                     
                         SUBJECT(&EMAILHDNG) +                         
                         MESSAGE(&EMALSUBJCT)                          
              MONMSG     MSGID(CPF0000)                                


Rich Sara
Senior Programmer\Analyst
John Maneely and Related Companies
Station House Building
900 Haddon Ave
Collingswood NJ, 08108
Phone: 856-854-5400, ext 347
Toll Free:  800-257-8182, ext 347
Fax: 856-854-6267

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Peter.Colpaert@xxxxxxxxxx
Sent: Friday, May 27, 2005 8:17 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Exporting to Excel

Douglas,

if these reports are based on workfiles, you can check my CPYPF2XLS utility.

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

HTH,

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




"Douglas W. Palme" <dpalme@xxxxxxxxxxx>
Sent by: rpg400-l-bounces+peter.colpaert=massive.be@xxxxxxxxxxxx
27/05/2005 14:11
Please respond to RPG programming on the AS400 / iSeries

 
        To:     "RPG Group" <rpg400-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Exporting to Excel


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.