Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Can we create REXX ouput in an Excel sheet.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
upendrasri

New User


Joined: 28 Sep 2017
Posts: 57
Location: India

PostPosted: Wed Jan 17, 2018 8:19 pm    Post subject: Can we create REXX ouput in an Excel sheet.
Reply with quote

Hi ,

I want to send output of Rexx as a Excel attachment.

For example :

My Input file is as below :


Code:

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.

Any suggestions or thoughts.

Thanks!
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8410
Location: Dubuque, Iowa, USA

PostPosted: Wed Jan 17, 2018 8:32 pm    Post subject: Reply to: Can we create REXX ouput in an Excel sheet.
Reply with quote

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.
Back to top
View user's profile Send private message
sergeyken

Active User


Joined: 29 Apr 2008
Posts: 388
Location: Maryland

PostPosted: Thu Jan 18, 2018 1:10 am    Post subject:
Reply with quote

Creating .CSV file covers 99.99% of similar needs, free of charge.
With 0.01% of efforts wasted.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10543
Location: italy

PostPosted: Thu Jan 18, 2018 2:24 am    Post subject: Reply to: Can we create REXX ouput in an Excel sheet.
Reply with quote

search the forum for the dfsort smart tricks on how to create a CSV format dataset
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to process gdg in rexx program wh... pkmurali CLIST & REXX 11 Thu Dec 13, 2018 10:08 am
No new posts Need advise in calling DFSORT from REXX ajithajt CLIST & REXX 9 Thu Nov 29, 2018 10:50 am
No new posts Rexx on amod 24 shahaf CLIST & REXX 19 Thu Nov 29, 2018 1:07 am
No new posts Will this code extract 1 byte from fi... pkmurali CLIST & REXX 8 Sat Nov 10, 2018 11:13 pm
No new posts Error reading file in REXX module ashek15 CLIST & REXX 3 Wed Oct 24, 2018 4:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us