Fast Excel Integration
Fast-Excel is recommended when exporting bulk records.
Usage
- Install
fast-excel
usingcomposer require rap2hpoutre/fast-excel
. - Create a dataTable class
php artisan datatables:make Users
- Adjust
UsersDataTable
as needed. - Set property
$fastExcel = true
.
class UsersDataTable extends DataTable
{
protected $fastExcel = true;
...
}
- DataTables will now export csv & excel using
fast-excel
package.
Faster export by disabling the fast-excel callback
- Just set property
$fastExcelCallback = false
. This is enabled by default for a better formatted output of exported file.
class UsersDataTable extends DataTable
{
protected $fastExcel = true;
protected $fastExcelCallback = false;
- Exported file will now be based on how your query was structured. No header formatting and all selected columns in sql will be included in the output.
Using custom callback
Just override the fastExcelCallback
method:
class UsersDataTable extends DataTable
{
protected $fastExcel = true;
public function fastExcelCallback()
{
return function ($row) {
return [
'Name' => $row['name'],
'Email' => $row['email'],
];
};
}
...