/ 
DBIx-DataModel-3.11
River stage one • 3 direct dependents • 3 total dependents
/ DBIx::DataModel::Schema::ResultAs::Xlsx

NAME

DBIx::DataModel::Schema::ResultAs::Xlsx - writes into an Excel file

SYNOPSIS

$source->select(..., -result_as => [xlsx => ($file,
                                             -worksheet    => $wksh_name,
                                             -tech_details => 0)]);

DESCRIPTION

Writes all resulting rows into an Excel file, using Excel::Writer::XLSX.

METHODS

new

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.