RE: Exporting to Excel

Thank Sara for the pointers, along with everyone else.....plenty of food for 
thought here.

Douglas


On Fri, 27 May 2005 08:27:11 -0400, Sara, Richard wrote
> 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.
> 
> -- 
> 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.


--
Open WebMail Project (http://openwebmail.org)