Home > Archive > Cobol > April 2007 > Need to automate the FTP of EXCEl file to Mainframes
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need to automate the FTP of EXCEl file to Mainframes
|
|
| svpnunna@gmail.com 2007-04-18, 3:55 am |
| I need to automate the ftp of execl file to mainframes and read it
through a cobol program.
I am reading thru cobol program after saving it as a text tab
delimited file.
But now want this conversion of excel file to text tab delimited file
to happen wothout using a macro. can someone help me out?
| |
|
| In article <1176877027.143778.104220@o5g2000hsb.googlegroups.com>,
<svpnunna@gmail.com> wrote:
[snip]
>But now want this conversion of excel file to text tab delimited file
>to happen wothout using a macro. can someone help me out?
Please do your own job.
DD
| |
| Pete Dashwood 2007-04-18, 7:55 am |
|
<svpnunna@gmail.com> wrote in message
news:1176877027.143778.104220@o5g2000hsb.googlegroups.com...
>I need to automate the ftp of execl file to mainframes and read it
> through a cobol program.
> I am reading thru cobol program after saving it as a text tab
> delimited file.
> But now want this conversion of excel file to text tab delimited file
> to happen wothout using a macro. can someone help me out?
>
How do you expect the Excel spreadsheet to export itself as a Tab delimited
file, if you DON'T use a macro (or activate a VBA or similar programmed
procedure)?
Telepathic software hasn't been invented yet and isn't likely any time
soon...:-)
Yes, it is possible to write a program that will tell Excel to export
itself, and you could do this in Java, C#, or even COBOL running on the PC,
or indeed, ANY language that can handle Automation Servers (OLE/COM). Excel
has its own COM interface, it also has Dot Net Classes (in the FCL) that
allow access to it in that environment, and I have used these with C# and
found them excellent. You can make Excel do anything you want under program
control, that you can do with your fingers on the keyboard (and perhaps a
little bit more besides)...
....But isn't a macro just simpler quicker and easier?
Pete.
| |
| Howard Brazee 2007-04-18, 6:55 pm |
| On 17 Apr 2007 23:17:07 -0700, svpnunna@gmail.com wrote:
>I need to automate the ftp of execl file to mainframes and read it
>through a cobol program.
>I am reading thru cobol program after saving it as a text tab
>delimited file.
>But now want this conversion of excel file to text tab delimited file
>to happen wothout using a macro. can someone help me out?
Macros are how you automate exporting Excel data. I suppose you
could write a program using a different language to do the exact same
thing that a macro does, if you like the challenge of more work.
| |
| Richard 2007-04-18, 6:55 pm |
| On Apr 18, 6:17 pm, svpnu...@gmail.com wrote:
> I need to automate the ftp of execl file to mainframes and read it
> through a cobol program.
> I am reading thru cobol program after saving it as a text tab
> delimited file.
> But now want this conversion of excel file to text tab delimited file
> to happen wothout using a macro. can someone help me out?
I use xlhtml in an automatic batch process to extract Excel .xls files
to CSV files that are EMailed (or they could be ftped or MQ or
whatever). It runs on Linux but you might convert it to run on your
environment.
http://chicago.sourceforge.net/xlhtml/
| |
| Richard 2007-04-18, 6:55 pm |
| On Apr 18, 11:52 pm, "Pete Dashwood"
<dashw...@removethis.enternet.co.nz> wrote:
> <svpnu...@gmail.com> wrote in message
>
> news:1176877027.143778.104220@o5g2000hsb.googlegroups.com...>I need to automate the ftp of execl file to mainframes and read it
>
> How do you expect the Excel spreadsheet to export itself as a Tab delimited
> file, if you DON'T use a macro (or activate a VBA or similar programmed
> procedure)?
>
> Telepathic software hasn't been invented yet and isn't likely any time
> soon...:-)
>
> Yes, it is possible to write a program that will tell Excel to export
> itself, and you could do this in Java, C#, or even COBOL running on the PC,
> or indeed, ANY language that can handle Automation Servers (OLE/COM). Excel
> has its own COM interface, it also has Dot Net Classes (in the FCL) that
> allow access to it in that environment, and I have used these with C# and
> found them excellent. You can make Excel do anything you want under program
> control, that you can do with your fingers on the keyboard (and perhaps a
> little bit more besides)...
>
> ...But isn't a macro just simpler quicker and easier?
>
> Pete.
But a macro (or VBA) requires that Excel itself be run, and this
requires a Windows PC environment. The .xls file is on a mainframe and
mainframes don't run Windows (OK, so you could buy a plug in extra
hardware for an AS400 to run NT).
He seems to want to suck the data out of a .xls _without_ requiring
Excel at all. A very reasonable request.
| |
| Pete Dashwood 2007-04-18, 9:55 pm |
|
"Richard" <riplin@Azonic.co.nz> wrote in message
news:1176929772.304801.214010@d57g2000hsg.googlegroups.com...
> On Apr 18, 11:52 pm, "Pete Dashwood"
> <dashw...@removethis.enternet.co.nz> wrote:
>
> But a macro (or VBA) requires that Excel itself be run, and this
> requires a Windows PC environment. The .xls file is on a mainframe and
> mainframes don't run Windows (OK, so you could buy a plug in extra
> hardware for an AS400 to run NT).
>
> He seems to want to suck the data out of a .xls _without_ requiring
> Excel at all. A very reasonable request.
>
That certainly wasn't clear from his post. I think, after looking at it
again, that you are probably right.
Pete.
| |
|
|
| Michael Russell 2007-04-23, 3:55 am |
| svpnunna@gmail.com wrote:
Who cares what he wrote, he's another disappearing poster ....
| |
|
| In article <7oCdnSiVFbNBDLbbnZ2dnUVZ8v3inZ2d@pipex.net>,
Michael Russell <Michael.Russell@msn.com> wrote:
>svpnunna@gmail.com wrote:
>Who cares what he wrote, he's another disappearing poster ....
They're dropping like flies!
DD
| |
| Lovelin 2007-04-23, 6:55 pm |
| I have seem similiar process.
Use VB to extrat the excel into a Tab Delimited file. (There are
features to create a dump of the excel file. Don't use them)
Have a batch file run automatically every night or morning to run this
VB program
On the mainframe job add an FTP step to retreive the data whenever
required.
On Apr 18, 2:17 am, svpnu...@gmail.com wrote:
> I need to automate the ftp of execl file to mainframes and read it
> through a cobol program.
> I am reading thru cobol program after saving it as a text tab
> delimited file.
> But now want this conversion of excel file to text tab delimited file
> to happen wothout using a macro. can someone help me out?
|
|
|
|
|