NAME

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

SYNOPSIS

    use Catmandu::Importer::XLSX;

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

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

METHODS

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

Create a new XLSX importer for $filename. Use STDIN when no filename is given. The object fields are read from the XLS header line 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