Hi,

Can we convert .xls(Excel) file to .csv(comma seperated) file using
UNIX script.

Thanks,
Sri

On 12 Oct, 11:36, sri <srilaxmipeddapa...@gmail.com> wrote:
> Hi,
>
> Can we convert .xls(Excel) file to .csv(comma seperated) file using
> UNIX script.
>
> Thanks,
> Sri

The short answer is no.
However you could look at
http://www.oooninja.com/2008/02/batch-command-line-file-conversion-with.html
or
http://www.artofsolving.com/opensource/jodconverter

"Sri" <srilaxmipeddapa...@gmail.com> wrote:
> Can we convert .xls(Excel) file to .csv(comma seperated) file using
> UNIX script.

Oh, you didn't do a Web search!

It seems that every third programmer in the world has at some time
asked this question.

A not-so-extensive search has provided me these leads for you to
follow up on:

http://search.cpan.org/~ken/xls2csv/script/xls2csv

"python-excelerator.py"
http://pypi.python.org/pypi/pyExcelerator,$0,"read/write Excel files:
contains py_xls2csv.py"
^ Debian: python-excelerator (http://packages.debian.org/lenny/python-
excelerator)
^ FreeBSD: py-excelerator (http://www.freebsd.org/cgi/cvsweb.cgi/ports/
textproc/py-excelerator/)

"Spreadheet::Read.pm": contains xlscat; utilizes Text::CSV_XS
^ "Text::CSV_XS.pl" http://search.cpan.org/search?mode=module&query=Text%3A%3ACSV_XS

Spreadsheet::ParseExcel.pm
http://search.cpan.org/search?query=Spreadsheet::ParseExcel

combined with:

Text::CSV.pm
http://search.cpan.org/search?query=Text::CSV

TC: http://www.perlmonks.org/?node_id=614412

http://forums.whirlpool.net.au/forum-replies-archive.cfm/565961.html

http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.17/

,"Spreadsheet:ParseExcel.pm",,http://search.cpan.org/dist/Spreadsheet-
ParseExcel/
Excel macro to automate process: http://forums.whirlpool.net.au/archive/565961

http://search.cpan.org/~ken/xls2csv/script/xls2csv "Ken Prows"
<perl@xev.net>

Searching on "+xls2csv +unix" will provide you plenty of links.

This is not nearly as hard as finding the file format to parse SYLK
files
I did many years ago! Good luck!

=Brian