View previous topic :: View next topic |
Author |
Message |
YVRAMJ Beginner
Joined: 18 Jan 2003 Posts: 12 Topics: 7
|
Posted: Mon Sep 08, 2003 2:03 pm Post subject: FTP EXCEL work book |
|
|
Hi,
I want to get a specific sheet from a EXCEL work book into host using JCL. I am able to get it if there is only one sheet. But If there are multiple sheets it is not working. Do you have any idea how to get multilple sheets into different datasets ? please let me know.
Thanks,
Ram. |
|
Back to top |
|
|
Bithead Advanced
Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
|
Posted: Mon Sep 08, 2003 3:20 pm Post subject: |
|
|
How are you getting at the data? |
|
Back to top |
|
|
YVRAMJ Beginner
Joined: 18 Jan 2003 Posts: 12 Topics: 7
|
Posted: Mon Sep 08, 2003 7:00 pm Post subject: |
|
|
The excel work book is being created from some other sources and some manual intervention. This work book will be located on a shred server and I need to write a batch job with FTP step to get the first sheet from the work book to the host. |
|
Back to top |
|
|
Bithead Advanced
Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
|
Posted: Tue Sep 09, 2003 8:28 am Post subject: |
|
|
You said that you could get it if there is only only 1 sheet. How are you doing that? |
|
Back to top |
|
|
Tintxiko Beginner
Joined: 22 Aug 2003 Posts: 11 Topics: 3 Location: Spain
|
Posted: Thu Sep 11, 2003 6:30 am Post subject: |
|
|
Before making the FTP you can try to divide the work book by means of a macro of Excel in so many work books as sheets have, and then send each work book with only a sheet in different files. _________________ Thanks - Tintxiko |
|
Back to top |
|
|
Bithead Advanced
Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
|
Posted: Thu Sep 11, 2003 11:18 am Post subject: |
|
|
FTP allows you to invoke certain REXX procedures on a remote host but you need a REXX listener to be running. This might allow you to invoke something to get at the particular sheet. You can't FTP a Workbook to a mainframe and expect to use it and I suspect that you are first exporting the data from the Workbook then using FTP against that.
I did a quick search of the web and it looks like Object Rexx for Windows supports OLE which might work for you. |
|
Back to top |
|
|
|
|