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: 8189
Location: East Dubuque, Illinois, 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: 8189
Location: East Dubuque, Illinois, 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: 1249
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 Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm
No new posts unable to set RC = 4 when empty file migusd SYNCSORT 1 Tue Nov 21, 2017 1:21 am
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am
No new posts Updating data from one file to other!!! Vignesh Sid SYNCSORT 1 Mon Nov 06, 2017 2:42 pm
This topic is locked: you cannot edit posts or make replies. Need help how to pass the ESP variabl... Venkichaitu JCL & VSAM 12 Thu Nov 02, 2017 3:53 am

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