Catmandu::Exporter::CSV - a CSV exporter
# On the command line $ catmandu convert XSL to CSV < data.xls $ catmandu convert JSON to CSV --fix myfixes.txt --sep_char ';' < data.json # In a Perl script use Catmandu; my $exporter = Catmandu->exporter('CSV', fix => 'myfix.txt', quote_char => '"', sep_char => ',', escape_char => '"' , always_quote => 1, header => 1); $exporter->fields("f1,f2,f3"); $exporter->fields([qw(f1 f2 f3)]); $exporter->add_many($arrayref); $exporter->add_many($iterator); $exporter->add_many(sub { }); $exporter->add($hashref); printf "exported %d objects\n" , $exporter->count;
This Catmandu::Exporter exports items as rows with comma-separated values (CSV). Serialization is based on Text::CSV. A header line with field names will be included if option header is set. See Catmandu::TabularExporter on how to configure the field mapping and column names. Newlines and tabulator values in field values are escaped as \n, \r, and \t.
Catmandu::Exporter
header
\n
\r
\t
Write output to a local file given by its path or file handle. Alternatively a scalar reference can be passed to write to a string and a code reference can be used to write to a callback function.
Write the output to an IO::Handle. If not specified, Catmandu::Util::io is used to create the output handle from the file argument or by using STDOUT.
file
An ARRAY of one or more fixes or file scripts to be applied to exported items.
Binmode of the output stream fh. Set to ":utf8" by default.
fh
:utf8
Column separator (, by default)
,
Quotation character (" by default)
"
Character for escaping inside quoted field (" by default)
See Catmandu::TabularExporter.
Include a header line with column names. Enabled by default.
See Catmandu::TabularExporter, Catmandu::Exporter, Catmandu::Addable, Catmandu::Fixable, Catmandu::Counter, and Catmandu::Logger for a full list of methods.
Catmandu::Importer::CSV, Catmandu::Exporter::Table Catmandu::Exporter::XLS
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.