Skip to content

xls2csv.pl: Script to translate Excel files into CSV

2 messages · Warnes, Gregory R, (Ted Harding)

#
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}}
#
On 16-Feb-04 Warnes, Gregory R wrote:
This looks really useful!

However, when I try to "make" the Makefile in OLE::Storage-Lite,
I get the warning message

  Warning: prerequisite IO::Scalar 2.101 not found.

I do not seem to have this (perl5/5.8.0). What should I do?
(Not a perl expert!)

I do have the following:

/usr/lib/perl5/5.8.0/i386-linux-thread-multi/auto/PerlIO/scalar
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/auto/PerlIO/scalar/scalar.bs
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/auto/PerlIO/scalar/scalar.so

With thanks,
Ted.



--------------------------------------------------------------------
E-Mail: (Ted Harding) <Ted.Harding at nessie.mcc.ac.uk>
Fax-to-email: +44 (0)870 167 1972
Date: 17-Feb-04                                       Time: 14:00:31
------------------------------ XFMail ------------------------------