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: 8339
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: 8339
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: 1284
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 B059 PREMATURE END OF FILE mvmadhuvenkatesh CA Products 5 Tue Jun 19, 2018 10:50 am
No new posts Formating output file Niki DFSORT/ICETOOL 3 Fri Jun 15, 2018 3:27 pm
No new posts Need help on TDQ load from file using... subratarec CICS 4 Wed Jun 13, 2018 11:32 pm
No new posts How to Count a particular record in a... Mounika Nemani DFSORT/ICETOOL 5 Tue May 29, 2018 1:07 pm
No new posts BAMAD file IO Error m1985nehal CICS 1 Fri May 25, 2018 11:51 am

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