[R] xls2csv.pl: Script to translate Excel files into CSV

Warnes, Gregory R gregory_r_warnes at groton.pfizer.com
Mon Feb 16 23:25:16 CET 2004

I've created a Perl script that translates Microsoft Excel (.xls) files into
comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel


perl xls2csv.pl <excel file> [<output file>] [<worksheet number>]

Translate the Microsoft Excel spreadsheet file contained in
<excel file> into comma separated value format (CSV) and store
in <output file>.

If <output file> is not specified, the output file will have the
same name as the input file with '.xls' or '.XLS' (if any)
removed and '.csv' appended.

If no worksheet number is given, each worksheet will be written to
a separate file with the name '<output file>_<worksheet name>.csv'.


xls2csv.pl depends on the OLE::Storage-Lite and Spreadsheet::ParseExcel
packages which are available below or from the author's CPAN
<http://search.cpan.org/author/KWITKNR/> site. 

Where to get it


Contacting the Author

The xls2csv.pl script is maintained by Gregory R. Warnes
gregory_r_warnes at groton.pfizer.com
<mailto:gregory_r_warnes at groton.pfizer.com>. Questions, comments, patches,
etc. are welcome. 


Gregory R. Warnes
Manager, Non-Clinical Statistics
Pfizer Global Research and Development
Tel: 860-715-3536

LEGAL NOTICE\ Unless expressly stated otherwise, this messag...{{dropped}}

More information about the R-help mailing list