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