View previous topic :: View next topic
|
Author |
Message |
kumarsatheeshc1
New User
Joined: 20 Jun 2017 Posts: 3 Location: usa
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
kumarsatheeshc1
New User
Joined: 20 Jun 2017 Posts: 3 Location: usa
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
kumarsatheeshc1
New User
Joined: 20 Jun 2017 Posts: 3 Location: usa
|
|
|
|
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 |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
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 |
|
|
|