Export formats

By default, the export format is determined by the extension of the file. If you want to explicitly configure the export format, you can pass it through as 2nd parameter.

You can customize the download headers with the optional 3rd parameter $headers. This way, you can customize the mime type for example.

XLSX

(new InvoicesExport)->download('invoices.xlsx', \Maatwebsite\Excel\Excel::XLSX);
1

CSV

// mime type is guessed and results to text/plain
(new InvoicesExport)->download('invoices.csv', \Maatwebsite\Excel\Excel::CSV);

// custom mime type text/csv
(new InvoicesExport)->download(
    'invoices.csv', 
    \Maatwebsite\Excel\Excel::CSV, 
    [
        'Content-Type' => 'text/csv',
    ]
);
1
2
3
4
5
6
7
8
9
10
11

TSV

(new InvoicesExport)->download('invoices.tsv', \Maatwebsite\Excel\Excel::TSV);
1

ODS

(new InvoicesExport)->download('invoices.ods', \Maatwebsite\Excel\Excel::ODS);
1

XLS

(new InvoicesExport)->download('invoices.xls', \Maatwebsite\Excel\Excel::XLS);
1

HTML

(new InvoicesExport)->download('invoices.html', \Maatwebsite\Excel\Excel::HTML);
1

Exporting to PDF

If you'd like to export to PDF, you must now install a PDF rendering library yourself. Please refer to the PhpSpreadsheet Documentation for more information.

MPDF

(new InvoicesExport)->download('invoices.pdf', \Maatwebsite\Excel\Excel::MPDF);
1

DOMPDF

(new InvoicesExport)->download('invoices.pdf', \Maatwebsite\Excel\Excel::DOMPDF);
1

TCPDF

(new InvoicesExport)->download('invoices.pdf', \Maatwebsite\Excel\Excel::TCPDF);
1