I want to send output of Rexx as a Excel attachment.
For example :
My Input file is as below :
Sno Name Salary
1 AB 2000
2 BC 3000
3 CD 4000
4 DE 5000
My Rexx will read the above Input file and extract data whose Salary>3000 and write those records in a excel file.
When I send my output as an attachment using SMTP, It should be delivered as excel sheet.
I can write my rexxx out put a PS File and can send this file as a text document.
I have searched this forum but didn't get an clue.
Joined: 06 Jun 2008 Posts: 8436 Location: Dubuque, Iowa, USA
This topic has been discussed on this forum a number of times. Why did you not search the forum before posting?
The easy way to do what you want is to create a CSV data set on the mainframe, transfer it to the PC, and open it with Excel.
The harder way to do what you want is to convince your company management to purchase a mainframe product (which will cost in the 5 to 6 digits range of US dollars, generally depending upon the size of your mainframe) that generates Excel and use that product to create your worksheet. If your site already has SAS installed on the mainframe, then it can be used to generate Excel output in ODS.
The very hard way to do what you want is read the entire 1,000+ page Microsoft specification for Excel data files and develop your own code on the mainframe to generate Excel data, transfer it in binary to the PC, and open the file on the PC with Excel.