RE: Excel Question

["Dwayne Allison" <Dwayne.Allison@xxxxxxxxx>]

We use the following:


 CVTPFXLS   FROMFILE(OAIDTA250/CM02045WK) +               
              TOSTMF('/QDLS/REPORTS/CM02045.XLS') +       
              FLDHDR(*TEXT)                               
                                                          
 SNDDST     TYPE(*DOC) TOINTNET((mary.doe@xxxxxxxxxx) +    
              (john.doe@xxxxxxxxxx)) DSTD('CLAIM +   
              DRAFT REGISTER') MSG('''''''Claim Draft +   
              Register.xls report''''') +                 
              DOC(CM02045.XLS) FLR(REPORTS) DOCD('CLAIM + 
              DRAFT REGISTER') SUBJECT(*DOCD)             
                                                          

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Muralidhar Narayana
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.