RE: Excel Question

["Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>]

My understanding is that the CVTPFXLS creates CSV files, at least that was
my experience. Also a third party tool, but free.

Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713

-----Original Message-----
From: Dwayne Allison [mailto:Dwayne.Allison@xxxxxxxxx] 
Sent: Wednesday, September 22, 2004 10:58
To: Midrange Systems Technical Discussion
Subject: RE: Excel Question

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,