MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2004

RE: Excel Question



fixed

ADDDIRE

> -------- Original Message --------
> Subject: RE: Excel Question
> From: "Dwayne Allison" <Dwayne.Allison@xxxxxxxxx>
> Date: Thu, September 23, 2004 8:44 am
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> 
> Add the user to the list
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Suresh Moda
> Sent: Thursday, September 23, 2004 3:28 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Excel Question
> 
> 
> Hi Mike,
> 
> I have tried this program but when using the command CPYTOPCD I am getting
> the error as "User not enrolled in system distribution directory. " What I
> need to do to use this command. Pls, guide me.
> 
> Regards
> 
> Suresh
> 
> 
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Condon, Mike
> Sent: Wednesday, September 22, 2004 8:40 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Excel Question
> 
> 
> Have you tried something like this:
> PGM
>              CLRPFM     FILE(<library>/<datafile>)
>              CLRPFM     FILE(<library>/<csvfile>)
>              RUNQRY     QRY(<library>/<datafile>) OUTTYPE(*OUTFILE) +
>                           OUTFORM(*DETAIL) PRTDFN(*NO) FORMSIZE(255 +
>                           133) OUTFILE(<library>/<datafile> *FIRST +
>                           *RPLFILE)
>              CPYTOIMPF  FROMFILE(<library>/<datafile>) +
>                           TOFILE(<library>/<csvfile>) MBROPT(*ADD)
>              CPYTOPCD   FROMFILE(<library>/<csvfile>) TOFLR(OPER) +
>                           TODOC(<csvfile>.CSV) REPLACE(*YES)
>              SNDDST     TYPE(*DOC) +
>                           TOINTNET(('someone@xxxxxxxxxxxxx') +
>                           ('someone@xxxxxxxxxxxxx')) DSTD('List of +
>                            data.') MSG('List of +
>                           data.') +
>                           DOCFILE(*NONE) DOC(<csvfile>.CSV) FLR(OPER)
> ENDPGM
> -----Original Message-----
> From: Muralidhar Narayana [mailto:Muralidhar_Narayana@xxxxxxxxxxx]
> Sent: Wednesday, September 22, 2004 9:58 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Excel Question
> 
> 
> I ve frequently seen users ask for reports to be delivered in "excel
> format". How is this done? My first instinct is to modify my
> report-generating program to output information to an externally-described
> physical file instead of (or in addition to) to a spool file, then to use
> EMAIL to send the physical file to the user with parameter DELIMITER(*CSV).
> But the resulting .CSV file doesn't really look like the report as I drop
> all headings line (including column headings) and total lines. Is there a
> way to deliver the report in "excel format" that actually looks like the
> original report?
> 
> Thanks for your responses! Kindly respond
> 
> 
> 
> Regards,
> 
> 
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact