logo
Free, Micro AI Code Reviews That Run on Git Commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, Micro AI Code Reviews That Run on Git Commit | Product Hunt git-lrc - Free, Micro AI Code Reviews That Run on Git Commit | Product Hunt

Catmandu::Exporter::XLS - Package that exports XLS files

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.

       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).

Description

       Catmandu exporter for Excel XLS files.

Methods

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

Name

       Catmandu::Exporter::XLS - Package that exports XLS files

See Also

       Catmandu::Exporter::CSV, Catmandu::Exporter::XLSX.

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

Synopsis

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

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

           my $exporter = Catmandu::Exporter::XLS->new(
                       file => 'test.xls',
                       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;

See Also