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
 
Is there a way to FTP a dataset content into a Excel.?

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

New User


Joined: 06 Mar 2010
Posts: 2
Location: India

PostPosted: Sat Jun 26, 2010 6:38 pm    Post subject: Is there a way to FTP a dataset content into a Excel.?
Reply with quote

I wrote a macro to parse the file and add the information into a output dataset.
As a next step i need to copy the content of the dataset to a excel sheet.
Is there a way to do the FTP automatically from REXX to a Excel sheet by providing the excel location in the system.

Please suggest me this can be achieved in REXX.?
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Sat Jun 26, 2010 6:41 pm    Post subject:
Reply with quote

Excel sheet? you mean an .xls pc filetype?

why don't you look at excel and see if there is a way to input data to an .xls
other than importing from an excel macro?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8165
Location: East Dubuque, Illinois, USA

PostPosted: Sat Jun 26, 2010 7:20 pm    Post subject:
Reply with quote

This question comes up so regularly on this forum it probably belongs in the topics not eligible for discussion.

Unless you are willing to spend the hundreds or thousands of hours to fully understand the Excel file specifications (which run a couple thousand pages in total) that Microsoft has published, OR your site buys one of the products that allow you to generate Excel files on a mainframe (usually many thousands of dollars), you cannot create Excel files on the mainframe and transfer them to a PC.

The usual, quick, simple solution is to create a comma-delimited (.csv) file on the mainframe and transfer the .csv file to the PC. Excel opens the .csv file, formats the data, and voila you have an Excel spreadsheet.
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1060
Location: Oostende, Belgium

PostPosted: Sun Jun 27, 2010 1:38 am    Post subject:
Reply with quote

Robert Sample wrote:
The usual, quick, simple solution is to create a comma-delimited (.csv) file on the mainframe and transfer the .csv file to the PC. Excel opens the .csv file, formats the data, and voila you have an Excel spreadsheet.


And, what few people seem to know, a .CSV file for input into Excel, can contain formulae, but creating them is pretty tricky, unless you are dealing with simple ones that only refer to variables on the current row.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sun Jun 27, 2010 7:00 am    Post subject:
Reply with quote

prino wrote:
And, what few people seem to know, a .CSV file for input into Excel, can contain formulae, but creating them is pretty tricky, unless you are dealing with simple ones that only refer to variables on the current row.
Tricky? How about creating the expected Excel sheet and exporting it to a .CSV file and copying the needed formulas to the hardcoded mainframe creator?
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Sun Jun 27, 2010 8:49 am    Post subject:
Reply with quote

Robert Sample wrote:
This question comes up so regularly on this forum it probably belongs in the topics not eligible for discussion.


It already is. It was one of the first topics I remember that came up way too often to keep having to reply to it.
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1060
Location: Oostende, Belgium

PostPosted: Sun Jun 27, 2010 11:48 am    Post subject:
Reply with quote

CICS Guy wrote:
prino wrote:
And, what few people seem to know, a .CSV file for input into Excel, can contain formulae, but creating them is pretty tricky, unless you are dealing with simple ones that only refer to variables on the current row.
Tricky? How about creating the expected Excel sheet and exporting it to a .CSV file and copying the needed formulas to the hardcoded mainframe creator?


You cannot export formulae to a .CSV file...
Back to top
View user's profile Send private message
jaihind

New User


Joined: 06 Mar 2010
Posts: 2
Location: India

PostPosted: Sun Jul 04, 2010 1:50 pm    Post subject: Reply to: Is there a way to FTP a dataset content into a Exc
Reply with quote

Hi Guys,

Thanks for your time and sugestions.

I will put my question in another way.

The macro i developed is writing the output to a dataset. If I need the content of the dataset in a system file ( Say Notpad or Excel sheet ( .xls) ). I have to do the FTP manually from the dataset to the target file.

Instead how to invoke the File Transfer Protcol FTP from REXX Macro in mainframe to copy the content of a Sequential dataset file to a PC system Notepad file.

Please give me some idea to achieve this.
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1060
Location: Oostende, Belgium

PostPosted: Sun Jul 04, 2010 3:52 pm    Post subject:
Reply with quote

Use the WSA
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jul 04, 2010 9:14 pm    Post subject:
Reply with quote

Hello,

You can invoke ftp from your process or you can have your process submit jcl thru the internal reader to transmit the file in batch.

There are examples of both in the forum. This would be a good time to become familiar/comfortable with the "forum search".
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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Mainframe dataset split purushottam DFSORT/ICETOOL 13 Tue Aug 29, 2017 12:28 pm

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