Skip to content
Icon

WARNING You're browsing the documentation for an old version of LARAVEL-DATATABLES. Consider upgrading your project to laravel-datatables 11.0.

Laravel Excel Integration

Laravel Excel is the default package used when exporting DataTables to Excel and CSV.

Using Export Class

  1. Create an export class php artisan make:export UsersExport
  2. Update the generated export class and extend DataTablesCollectionExport
namespace App\Exports;
 
use Yajra\DataTables\Exports\DataTablesCollectionExport;
 
class UsersExport extends DataTablesCollectionExport
{
 
}
  1. Update your UsersDataTable class and set protected $exportClass = UsersExport::class
class UsersDataTable extends DataTable
{
protected $exportClass = UsersExport::class;
  1. Update your export class as needed. See official package docs: https://docs.laravel-excel.com/3.1/exports/collection.html

Example Export Class

namespace App\Exports;
 
use Maatwebsite\Excel\Concerns\WithMapping;
use Yajra\DataTables\Exports\DataTablesCollectionExport;
 
class UsersExport extends DataTablesCollectionExport implements WithMapping
{
public function headings(): array
{
return [
'Name',
'Email',
];
}
 
public function map($row): array
{
return [
$row['name'],
$row['email'],
];
}
}