++ed by:
AWNCORP PERLANCAR KEEDI

3 PAUSE users
7 non-PAUSE users.

Laurent Dami
and 1 contributors

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.