NAME

       Catmandu::Exporter::XLSX - a XLSX exporter

SYNOPSIS

           # On the command line
           $ printf "a,b,c\n1,2,3" | catmandu convert CSV to XLSX --file test.xlsx
           $ printf "a,b,c\n1,2,3" | catmandu convert CSV to XLSX --file test.xlsx --header 0
           $ printf "a,b,c\n1,2,3" | catmandu convert CSV to XLSX --file test.xlsx --fields a,c
           $ printf "a,b,c\n1,2,3" | catmandu convert CSV to XLSX --file test.xlsx --fields a,c --columns ALPHA,CHARLIE

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

           my $exporter = Catmandu::Exporter::XLSX->new(
                       file => 'test.xlsx',
                       fields => 'a,b,c',
                       columns => 'ALPHA,BRAVO,CHARLIE',
                       header => 1);

           $exporter->add({a => 1, b => 2, c => 3});
           $exporter->add_many($arrayref);

           $exporter->commit;

           printf "exported %d objects\n" , $exporter->count;

DESCRIPTION

       Catmandu exporter for Excel XLSX files.

METHODS

       See Catmandu::Exporter, Catmandu::Addable, Catmandu::Fixable, Catmandu::Counter, and Catmandu::Logger for
       a full list of methods.

CONFIGURATION

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

       header
           Include a header line with column names, if set to 1 (default).

       fields
           List of fields to be used as columns, given as array reference or comma-separated string

       columns
           List of custom column names, given as array reference or comma-separated list.

SEE ALSO

       Catmandu::Exporter::CSV, Catmandu::Exporter::XLS.

perl v5.26.2                                       2018-05-05                      Catmandu::Exporter::XLSX(3pm)