NAME

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

SYNOPSIS

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

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

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

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

DESCRIPTION

       Catmandu importer for XLSX 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:

       header
           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::XLS.