xls2csv.pl: Script to translate Excel files into CSV
On 16-Feb-04 Warnes, Gregory R wrote:
I've created a Perl script that translates Microsoft Excel (.xls) files into comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel module. [...] 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.
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 ------------------------------