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
 
FTP xls file from Mainfrmae

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
kumarsatheeshc1

New User


Joined: 20 Jun 2017
Posts: 3
Location: usa

PostPosted: Tue Jun 20, 2017 6:56 pm    Post subject: FTP xls file from Mainfrmae
Reply with quote

Hi!

When I tried to ftp mainframe file to remote as xls file, the xls file name and sheet name(Tabs in excel) are having the same name.


I want the sheet name is different from xls file name. Is there a way in mainframe to send the xls file with different sheet name.
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: Tue Jun 20, 2017 7:08 pm    Post subject: Reply to: FTP xls file from Mainfrmae
Reply with quote

Are you using a product on the mainframe to generate the .xls? If so, contact the vendor of that product and work with them. If not, you'll have to explain a LOT more about your process -- such as how you generate the .xls on the mainframe and what transfer method you are using to get it to the remote system (for starters).
Back to top
View user's profile Send private message
kumarsatheeshc1

New User


Joined: 20 Jun 2017
Posts: 3
Location: usa

PostPosted: Tue Jun 20, 2017 7:14 pm    Post subject: Reply to: FTP xls file from Mainfrmae
Reply with quote

I am using the JCL utility FTP(PGM=FTP) to transfer the file to remote. The mainframe file is tab delimited file and the data is transferred successfully and only the issue excel assign sheet name as xls file name.
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: Tue Jun 20, 2017 7:27 pm    Post subject:
Reply with quote

This is NOT a mainframe question. You need to find an Excel forum and ask your question there. We focus only on mainframe issues.
Back to top
View user's profile Send private message
kumarsatheeshc1

New User


Joined: 20 Jun 2017
Posts: 3
Location: usa

PostPosted: Tue Jun 20, 2017 7:31 pm    Post subject: Reply to: FTP xls file from Mainfrmae
Reply with quote

My question is that is there a way on mainframe to specify excel sheet name(tab name) while transfer file from mainframe to remote.
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1303
Location: Israel

PostPosted: Tue Jun 20, 2017 8:10 pm    Post subject: Re: Reply to: FTP xls file from Mainfrmae
Reply with quote

kumarsatheeshc1 wrote:
...The mainframe file is tab delimited file...

In that case, it is NOT an "xls" file, it is a simple text file, built in such a way that Excel can understand it.
There is no way to give a name to the worksheet because there is no worksheet in the text file.
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Transferring file to Mainframes Shinoj Vijayakumar IBM Tools 3 Thu Dec 06, 2018 2:35 pm
No new posts Convert VBA file to FB! Vignesh Sid SYNCSORT 5 Mon Dec 03, 2018 1:27 pm
No new posts Another 39 File Status on VB file socker_dad COBOL Programming 5 Tue Nov 27, 2018 6:11 am
No new posts How to handle different file length b... javen777 DFSORT/ICETOOL 15 Mon Nov 26, 2018 12:13 pm
No new posts COBOL file declaration jithinraghavan COBOL Programming 2 Fri Nov 16, 2018 10:54 pm

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