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