Catmandu::Exporter::XLS - a XLS exporter
use Catmandu::Exporter::XLS; my $exporter = Catmandu::Exporter::XLS->new( file => 'output.xls', fix => 'myfix.txt' header => 1); $exporter->fields("f1,f2,f3"); # add custom header labels $exporter->header({f2 => 'field two'}); $exporter->add_many($arrayref); $exporter->add_many($iterator); $exporter->add_many(sub { }); $exporter->add($hashref); $exporter->commit; printf "exported %d objects\n" , $exporter->count;
Creates a new Catmandu::Exporter::XLS. A header line with field names will be included if header is set. Field names can be read from the first item exported or set by the fields argument (see: fields).
header
fields
Set the field names by an ARRAY reference.
Set the field names by the keys of a HASH reference.
Set the fields by a comma delimited string.
Include a header line with the field names
Include a header line with custom field names
Commit the changes and close the XLS.
Catmandu::Exporter
To install Catmandu, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Catmandu
CPAN shell
perl -MCPAN -e shell install Catmandu
For more information on module installation, please visit the detailed CPAN module installation guide.