ftp an excel file from windows to unix

Shell Programming and Scripting
1

Hi all..

Please help me on below requirement.

I have an excel file ftped from windows to unix location. I am not able to open the file. if i am opening it in vi editor, i am getting only junk characters. I have to make the excel file as .csv file and read the data to put some business logic.

Thanks in adv....

2

Any 'raw' file generated by an application like Excel is not something that can be edited with an ASCI text editor like VI. You'll need to use Excel and export the data to a csv file and then FTP it to the unix environment, or you'll need to use something like Open Office, or Libre Office to read the data and do the export on the unix box.

I think you can still download Open Office from here:
OpenOffice.org - The Free and Open Productivity Suite

3

Dear agama,

Actually i hv the problem like, putting the excel file in unix location is not in our hand. There is an excel file present in unix location(a third party vandor has put it), we have to convert it to unix csv file then put some business logic for it.

Is it possible to do in unix??

Please suggest me.

4

Hi gani,
You can use the perl module named "Spreadsheet::ParseExcel" for parsing .xls file in unix

regards
anoop

1 Like