MVSFORUMS.com

amitkv · Beginner Joined: 20 Jun 2008 Posts: 1 Topics: 1

Hi,

I have to upload an Excel(.xls) file to mainframe, and then have to process it.

But when I upload it thru FTP, i see garbage value in the ps file.

Can anyone please guide me with the steps of translating the xls file into the ps file.

Thaks and Regards,
Amit

CraigG · Posted: Mon Jun 23, 2008 6:19 am Post subject:

.XLS files are useless on the mainframe. As has been discussed before you have to convert it to a .TXT or .CSV format that contains only character data, transfer that to the mainframe and do you processing using that.

jyoung · Posted: Mon Jun 23, 2008 6:42 am Post subject:

You can use Active States Perl version to extract cells from a MS Spread Sheet and create a text file. Here is a link:
http://aspn.activestate.com/ASPN/docs/ActivePerl/5.8/faq/Windows/ActivePerl-Winfaq12.html#extract_cells