MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

FTP EXCEL work book

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL)
View previous topic :: View next topic  
Author Message
YVRAMJ
Beginner


Joined: 18 Jan 2003
Posts: 12
Topics: 7

PostPosted: Mon Sep 08, 2003 2:03 pm    Post subject: FTP EXCEL work book Reply with quote

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
View user's profile Send private message
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA

PostPosted: Mon Sep 08, 2003 3:20 pm    Post subject: Reply with quote

How are you getting at the data?
Back to top
View user's profile Send private message
YVRAMJ
Beginner


Joined: 18 Jan 2003
Posts: 12
Topics: 7

PostPosted: Mon Sep 08, 2003 7:00 pm    Post subject: Reply with quote

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
View user's profile Send private message
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA

PostPosted: Tue Sep 09, 2003 8:28 am    Post subject: Reply with quote

You said that you could get it if there is only only 1 sheet. How are you doing that?
Back to top
View user's profile Send private message
Tintxiko
Beginner


Joined: 22 Aug 2003
Posts: 11
Topics: 3
Location: Spain

PostPosted: Thu Sep 11, 2003 6:30 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA

PostPosted: Thu Sep 11, 2003 11:18 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group