Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Converting sequential file to excel document !

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News
View previous topic :: :: View next topic  
Author Message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 181
Location: Globe, India

PostPosted: Wed Jul 21, 2010 7:11 pm    Post subject: Converting sequential file to excel document !
Reply with quote

Hello Friends,

Step 1. I am connecting REXX program to DB2 for fetching details.

Step 2. Pass these fetched details into a PS file

Step 3. I want to get this PS file as an output on windows in the form of EXCEL sheet.

I am struggling with this Step 3. Your any help is appreciable.

Thanks and Regards,
Rohan Subhash Thengal
Back to top
View user's profile Send private message

superk

Moderator Team Head


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

PostPosted: Wed Jul 21, 2010 7:27 pm    Post subject: Reply to: Converting sequential file to excel document !
Reply with quote

Not really a mainframe-related topic, but ...

I create the data using the Symbolic Link format (.slk) since it allows you to use markup tags for column headers, formats, and the like, and then store the file with the .xls extension. When opened with a double-click, it looks like any other spreadsheet, and when saved, Excel writes it as a fully-formatted .xls document.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Wed Jul 21, 2010 8:16 pm    Post subject:
Reply with quote

Your step 3 is actually 2 steps:
a. move the data from the mainframe to the PC
b. import the data into Excel.

FTP is one way to accomplish 3a, but there are others. The key thing to recognize is that FTP (and most other methods) must connect to a server, and desktop machines are not servers. Therefore you cannot automate a transfer on the mainframe to connect to your desktop and send the file. If this is part of your requirements, you'll need to send the file to a server on your site's network and then get it from that server.

As far as 3b goes, unless your site has spend the money to acquire a conversion package for Excel, your best bet is to use comma-delimited or SLK format as Kevin suggested. Excel opens these files and converts the data while opening it.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jul 21, 2010 8:25 pm    Post subject: Re: Converting sequential file to excel document !
Reply with quote

rohanthengal wrote:
Step 3. I want to get this PS file as an output on windows in the form of EXCEL sheet.

I am struggling with this Step 3. Your any help is appreciable.
You don't get the file in "excel format" (.xls) when you transfer teh data from mainframes(zOS) to windows - it's in ".txt" format. You open (import the data) that file with "Microsoft Excel" and to get the different columns from your "text-file" alligned to different columns of "spread-sheet" you need some kind of delimiter, as Kevin has said. possibly, you can create a comma-delimited file and then "tell" excel to use "," as seprater.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jul 21, 2010 8:28 pm    Post subject:
Reply with quote

icon_redface.gif - you typed in too fast, Robert.
Back to top
View user's profile Send private message
shibubalakrishnan

New User


Joined: 16 Oct 2009
Posts: 13
Location: Bangalore

PostPosted: Wed Jul 21, 2010 9:45 pm    Post subject: Reply to: Converting sequential file to excel document !
Reply with quote

We used to do the following things when we need to send report as an excel file. Hope this will help you...

> ftp the dataset into windows as .txt file.
>In Ms Excel select 'Data' menu, select 'Import External Data', select 'Import Data'
>In the Files of type box, click Text Files.
>In the Look in list, locate and double-click the text file you want to import as an external data range.
>To specify how you want to divide the text into columns, follow the instructions in the Text Import Wizard, and then click Finish.
>In the Import Data dialog box, click Properties to set formatting and layout options for the imported data.
>In the Import Data dialog box, do one of the following:
>To return the data to the location you selected, click Existing worksheet, and then click OK.
>To return the data to a new worksheet, click New worksheet, and then click OK. Microsoft Excel adds a new worksheet to your workbook and automatically puts the external data range in the upper-left corner of the new worksheet.
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 -> PC Guides & IT News All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us