Catmandu::Exporter::XLSX - a XLSX exporter

       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.

       collect_fields
           This  option  will first read the complete stream to create a complete list of fields to export. When
           this option is not set, only the fields of the first record (or the ones  provided  in  the  "fields"
           option will be exported).

       Catmandu exporter for Excel XLSX files.

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

       Catmandu::Exporter::XLSX - a XLSX exporter

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

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

           # 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;