DBIx::DataModel::Schema::ResultAs::Xlsx - writes into an Excel file
$source->select(..., $result_as => [xlsx => ($file, -worksheet => $wksh_name, -tech_details => 0)]);
Writes all resulting rows into an Excel file, using Excel::Writer::XLSX.
Arguments :
$file
Mandatory. This can be either the name of a file to generate, or it can be an open filehandle (see "new" in Excel::Writer::XLSX).
-worksheet => $wksh_name
Optional. Specifies the name of the data worksheet. Default is 'Data'.
-tech_details => $details_name
Optional. Specifies the name of the worksheet that will report technical details (time of extraction, name of database, SQL and bind values). Default is 'Technical_details'. If set to 0 or to an empty string, the technical sheet will not be generated.
To install DBIx::DataModel, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::DataModel
CPAN shell
perl -MCPAN -e shell install DBIx::DataModel
For more information on module installation, please visit the detailed CPAN module installation guide.