NAME

Catmandu::Exporter::XLSX - a XLSX exporter

SYNOPSIS

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

DESCRIPTION

Catmandu exporter for Excel XLSX files.

METHODS

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

CONFIGURATION

In addition to the configuration provided by Catmandu::Exporter (file, fh, etc.) the importer can be configured with the following parameters:

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

SEE ALSO

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