Nicolas Steenlant
and 3 contributors

NAME

Catmandu::Importer::XLS - Package that imports XLS files

SYNOPSIS

    use Catmandu::Importer::XLS;

    my $importer = Catmandu::Importer::XLS->new(file => "./t/test.xls");

    my $n = $importer->each(sub {
        my $hashref = $_[0];
        # ...
    });

METHODS

new(file => $filename [, fields => \@fields])

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.

count

each(&callback)

...

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.

SEE ALSO

Catmandu::Iterable