MVSFORUMS.com

YVRAMJ · Beginner Joined: 18 Jan 2003 Posts: 12 Topics: 7

Hi,

Can we ftp a dataset from host to a network drive as excel ?
And also I would like to know how to get a excel file to host.
Users want the file to be in excel format only.
Please let me know if any body knows how to do it.

Thanks,
Ram. Rolling Eyes

kolusu · Posted: Thu Aug 19, 2004 2:46 pm Post subject:

Ram,

Create a tab delimited dataset and ftp the dataset as a text file. The users can open the file in excel.

The same goes for getting excel file to the host. save the excel file as .csv or tab delimited text file and ftp the text file to the mainframe

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

superk · Advanced Joined: 19 Dec 2002 Posts: 684 Topics: 5

Before responding to this, I was searching for some information about direct conversions of Excel .xls files to other formats.

There seems to be utilities that are available to deal with the conversion of Excel spreadsheets to other formats, usually XML or CSV. SAS was one mentioned that has this capability, as did others. They all seem to be able to run as a service, rather than requiring a manual process from the users. It would probably end up that whatever utility you would use would most likely be required to run on the Windows server.

I would imagine that a full-blown data integration product such as Mercator, Gentran or Cloverleaf could handle not only the data conversion functions but also the exchange of data between platforms.

YSMVS · Posted: Thu Sep 16, 2004 12:28 pm Post subject:

Hi Ram,

I usually do this way. The FTP from host directly to Excela nd viceversa works . But the problem is the data gets copied in the first column. So you can download it and then use DATA->TEXT to column option in Excel to split the data. Probably this may not be the best, but it works.

YSMVS

karthikbabudh · Beginner Joined: 29 Apr 2005 Posts: 10 Topics: 6

jetson · Posted: Mon Jul 31, 2006 7:09 am Post subject:

A comma separated file is even easier. Just put a comma in between each field in your text file, FTP it to the win platform with a file extension of .csv, and it will open in Excel as though it were already a spreadsheet.

It is also a good idea to add quotations to any text field that may contain an actual comma. If you think one of your fields has embedded commas already, then program some double quotes around that field on each output record.

Any language that allows you to place an actual comma in between each fields values will work. By default, your program should place 2 commas in a row of data has a null value in a particular field. Excel will see this as a null value and retain the proper data alignment.

Any character can be placed between fields because the Excel import dialog allows you to choose a character, but the default comm separaed values does not require an import by the end user.

kolusu · Posted: Mon Jul 31, 2006 7:14 am Post subject:

karthikbabudh,

Check this link for an example of creating tab delimited file.

http://www.mvsforums.com/helpboards/viewtopic.php?p=1793#1793

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu