Shell Programming and Scripting

Hi All,
Please give me the solution to the following ASAP.

1) Converting the .xls into .csv
Script i tried,

Code:

mv hello.xls  hello.csv

The above given script converting the .xls file into .csv successfully. But after i run the below unix command I am no able to open the .csv file, its giving some "Unable to Read" Error message.

2) Script I tried to replace the commas by single space in the converted .csv file is,

Code:

tr ', ' '  ' < hello.csv > hello1.csv

When I am running the above scripts for the small files (file contains 10 records of data only) its working fine. But while trying to the big files its giving the error message as "Unable to read". Commands are running without any problem.

Plesae give me the proper solution to the above problem ASAP friends.

Thanks & Regards,
Velava.S

you need to save the .xls file as .csv before you can proceed with further operations from EXCEL

As a rule of thumb, only Excel understands Excel. All Microsoft trumpeted about open document formats was pure baloney -- it's still a proprietary binary blob, wrapped in an open container format but still a proprietary binary blob.

I could not get this.. Please give me the solution to achive the above problem statement.

The best way is to save it as CSV, in excel. It's certainly capable of doing so. Failing that you could try saving it as a "legacy" pre-office-2007 excel file for which certain perl modules exist that can use it.