How to convert a excel file to a .csv file from unix script

akashtcs · August 26, 2009, 2:39am

Hi
I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this?

Thanks
Abhinav

figaro · August 26, 2009, 4:08am

Using a shell script only is not possible, I am afraid, given the proprietary format that excel spreadsheets are in. You are probably best helped by using a Perl script: The CPAN Search Site - search.cpan.org

akashtcs · August 26, 2009, 5:38am

But if I am not wrong we can use perl commands in unix scripts also?
So what perl commands can be used to read the excel and write the same contents to a csv file.

figaro · August 26, 2009, 1:39pm

Most things that can be done in a shell script can also be done in a perl script and more. Please have a look at the link I sent, because that will answer your other question.