Acme-CPANModules-WorkingWithXLS
view release on metacpan or search on metacpan
Data::XLSX::Parser which claims to be a "faster XLSX parser". Haven't
used this one personally or benchmarked it though.
Getting information
Spreadsheet::Read
xls-info from App::XLSUtils
Iterating/processing with Perl code
XLSperl CLI from App::XLSperl lets you iterate each cell (with 'XLSperl
-ne' or row with 'XLSperl -ane') with a Perl code, just like you would
each line of text with "perl -ne" (in fact, the command-line options of
XLSperl mirror those of perl). Only supports the old Excel format (XLS
not XLSX). Does not support LibreOffice Calc format (ODS). If you feed
it unsupported format, it will fallback to text iterating, so if you
feed it XLSX or ODS you will iterate chunks of raw binary data.
xls-each-cell from App::XLSUtils
lib/Acme/CPANModules/Spreadsheet.pm view on Meta::CPAN
L<Data::XLSX::Parser> which claims to be a "faster XLSX parser". Haven't used
this one personally or benchmarked it though.
B<Getting information>
L<Spreadsheet::Read>
L<xls-info> from L<App::XLSUtils>
B<Iterating/processing with Perl code>
L<XLSperl> CLI from L<App::XLSperl> lets you iterate each cell (with
'XLSperl -ne' or row with 'XLSperl -ane') with a Perl code, just like you would
each line of text with C<perl -ne> (in fact, the command-line options of XLSperl
mirror those of perl). Only supports the old Excel format (XLS not XLSX). Does
not support LibreOffice Calc format (ODS). If you feed it unsupported format, it
will fallback to text iterating, so if you feed it XLSX or ODS you will iterate
chunks of raw binary data.
L<xls-each-cell> from L<App::XLSUtils>
lib/Acme/CPANModules/WorkingWithODS.pm view on Meta::CPAN
L<Data::XLSX::Parser> which claims to be a "faster XLSX parser". Haven't used
this one personally or benchmarked it though.
B<Getting information>
L<Spreadsheet::Read>
L<xls-info> from L<App::XLSUtils>
B<Iterating/processing with Perl code>
L<XLSperl> CLI from L<App::XLSperl> lets you iterate each cell (with
'XLSperl -ne' or row with 'XLSperl -ane') with a Perl code, just like you would
each line of text with C<perl -ne> (in fact, the command-line options of XLSperl
mirror those of perl). Only supports the old Excel format (XLS not XLSX). Does
not support LibreOffice Calc format (ODS). If you feed it unsupported format, it
will fallback to text iterating, so if you feed it XLSX or ODS you will iterate
chunks of raw binary data.
L<xls-each-cell> from L<App::XLSUtils>
lib/Acme/CPANModules/WorkingWithXLS.pm view on Meta::CPAN
**Getting information**
<pm:Spreadsheet::Read>
<prog:xls-info> from <pm:App::XLSUtils>
**Iterating/processing with Perl code**
<prog:XLSperl> CLI from <pm:App::XLSperl> lets you iterate each cell (with
'XLSperl -ne' or row with 'XLSperl -ane') with a Perl code, just like you would
each line of text with `perl -ne` (in fact, the command-line options of XLSperl
mirror those of perl). Only supports the old Excel format (XLS not XLSX). Does
not support LibreOffice Calc format (ODS). If you feed it unsupported format, it
will fallback to text iterating, so if you feed it XLSX or ODS you will iterate
chunks of raw binary data.
<prog:xls-each-cell> from <pm:App::XLSUtils>
lib/Acme/CPANModules/WorkingWithXLS.pm view on Meta::CPAN
L<Data::XLSX::Parser> which claims to be a "faster XLSX parser". Haven't used
this one personally or benchmarked it though.
B<Getting information>
L<Spreadsheet::Read>
L<xls-info> from L<App::XLSUtils>
B<Iterating/processing with Perl code>
L<XLSperl> CLI from L<App::XLSperl> lets you iterate each cell (with
'XLSperl -ne' or row with 'XLSperl -ane') with a Perl code, just like you would
each line of text with C<perl -ne> (in fact, the command-line options of XLSperl
mirror those of perl). Only supports the old Excel format (XLS not XLSX). Does
not support LibreOffice Calc format (ODS). If you feed it unsupported format, it
will fallback to text iterating, so if you feed it XLSX or ODS you will iterate
chunks of raw binary data.
L<xls-each-cell> from L<App::XLSUtils>
lib/Acme/CPANModules/WorkingWithXLSX.pm view on Meta::CPAN
L<Data::XLSX::Parser> which claims to be a "faster XLSX parser". Haven't used
this one personally or benchmarked it though.
B<Getting information>
L<Spreadsheet::Read>
L<xls-info> from L<App::XLSUtils>
B<Iterating/processing with Perl code>
L<XLSperl> CLI from L<App::XLSperl> lets you iterate each cell (with
'XLSperl -ne' or row with 'XLSperl -ane') with a Perl code, just like you would
each line of text with C<perl -ne> (in fact, the command-line options of XLSperl
mirror those of perl). Only supports the old Excel format (XLS not XLSX). Does
not support LibreOffice Calc format (ODS). If you feed it unsupported format, it
will fallback to text iterating, so if you feed it XLSX or ODS you will iterate
chunks of raw binary data.
L<xls-each-cell> from L<App::XLSUtils>
( run in 0.278 second using v1.01-cache-2.11-cpan-8d75d55dd25 )