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 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>. 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}} ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
