Catmandu::Exporter::XLS - Package that exports XLS files
# 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;
Catmandu exporter for Excel XLS files.
See Catmandu::Exporter, Catmandu::Addable, Catmandu::Fixable, Catmandu::Counter, and Catmandu::Logger for a full list of methods.
In addition to the configuration provided by Catmandu::Exporter (file, fh, etc.) the importer can be configured with the following parameters:
file
fh
Include a header line with column names, if set to 1 (default).
List of fields to be used as columns, given as array reference or comma-separated string
List of custom column names, given as array reference or comma-separated list.
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).
fields
Catmandu::Exporter::CSV, Catmandu::Exporter::XLSX.
To install Catmandu::XLS, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Catmandu::XLS
CPAN shell
perl -MCPAN -e shell install Catmandu::XLS
For more information on module installation, please visit the detailed CPAN module installation guide.