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: 8220
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: 8220
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: 1268
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 eliminate dups in VB file anatol DFSORT/ICETOOL 6 Tue Feb 13, 2018 2:59 am
No new posts Tape file issue abdulrafi JCL & VSAM 2 Thu Feb 08, 2018 12:01 pm
No new posts COB2 file processing rizwanaccy COBOL Programming 8 Tue Jan 02, 2018 1:00 pm
No new posts KSDS and Index file in cobol deepak14450 COBOL Programming 9 Fri Dec 22, 2017 9:36 am
No new posts Preserve order in Input File pshongal DFSORT/ICETOOL 13 Thu Dec 21, 2017 4:20 pm

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