Catmandu::Importer::XLS - Package that imports XLS files
use Catmandu::Importer::XLS; my $importer = Catmandu::Importer::XLS->new(file => "./t/test.xls"); my $n = $importer->each(sub { my $hashref = $_[0]; # ... });
Create a new XLS importer for $filename. Use STDIN when no filename is given. The object fields are read from the first XLS row or given via the 'fields' parameter.
Only the first worksheet from the Excel workbook is imported.
Every Catmandu::Importer is a Catmandu::Iterable all its methods are inherited. The Catmandu::Importer::XLS methods are not idempotent: XLS streams can only be read once.
Catmandu::Iterable
To install Catmandu::XLS, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Catmandu::XLS
CPAN shell
perl -MCPAN -e shell install Catmandu::XLS
For more information on module installation, please visit the detailed CPAN module installation guide.