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.

       empty
           How  to  treat  empty fields in the data. When the option value is 'string', the empty values will be
           empty strings. When the option value is 'nil', the  empty  values  will  get  turned  into  undefined
           fields. When the option is 'ignore', the empty values are ignored.  Default is 'string'.

       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.

perl v5.32.1                                       2021-09-02                      Catmandu::Importer::XLSX(3pm)