NAME

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

SYNOPSIS

# On the command line
$ catmandu convert XLS < ./t/test.xls
$ catmandu convert XLS --header 0 < ./t/test.xls
$ catmandu convert XLS --fields 1,2,3 < ./t/test.xls
$ catmandu convert XLS --columns 1 < ./t/test.xls
$ catmandu convert XLS --worksheet 1 < ./t/test.xls

# Or in Perl
use Catmandu::Importer::XLS;

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

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

DESCRIPTION

Catmandu importer for XLS files.

METHODS

This module inherits all methods of Catmandu::Importer and by this Catmandu::Iterable.

CONFIGURATION

In addition to the configuration provided by Catmandu::Importer (file, fh, etc.) the importer can be configured with the following parameters:

By default object fields are read from the XLS header line. If no header line is avaiable object fields are named as column coordinates (A,B,C,...). Default: 1.

fields

Provide custom object field names as array, hash reference or comma- separated list.

columns

When the 'columns' option is provided, then the object fields are named as column coordinates (A,B,C,...). Default: 0.

worksheet

If the Excel workbook contains more than one worksheet, you can select a specific worksheet by its index number (0,1,2,...). Default: 0.

SEE ALSO

Catmandu::Importer, Catmandu::Iterable, Catmandu::Importer::CSV, Catmandu::Importer::XLSX.