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

[Warnes, Gregory R]

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

Usage
-----

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'.

Dependencies
------------

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
----------------

http://www.analytics.washington.edu/Zope/projects/xls2csv.pl

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. 

-Greg

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}}