IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

FTP xls file from Mainfrmae


IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
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
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: 8569
Location: Dubuque, Iowa, USA

PostPosted: Tue Jun 20, 2017 7:08 pm
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
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: 8569
Location: Dubuque, Iowa, USA

PostPosted: Tue Jun 20, 2017 7:27 pm
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
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: 1348
Location: Israel

PostPosted: Tue Jun 20, 2017 8:10 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> TSO/ISPF

 


Similar Topics
Topic Forum Replies
No new posts Converting a file from PD to display ... SYNCSORT 4
No new posts Record count of RECFM=U tape file DFSORT/ICETOOL 17
This topic is locked: you cannot edit posts or make replies. Write Character to Hexadecimal file w... COBOL Programming 8
No new posts Checking the total counts inside a re... JCL & VSAM 5
No new posts File-aid batch how to repeat a line... Compuware & Other Tools 2
Search our Forums:

Back to Top