Version

Laravel Excel Integration

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

Using Export Class

Create an export class php artisan make:export UsersExport
Update the generated export class and extend DataTablesCollectionExport

<?php
// app/Exports/UsersExport.php
 
namespace App\Exports;
 
use Yajra\DataTables\Exports\DataTablesCollectionExport;
 
class UsersExport extends DataTablesCollectionExport
{
}

Update your UsersDataTable class and set protected $exportClass = UsersExport::class

<?php
// app/DataTables/UsersDataTable.php
 
namespace App\DataTables;
 
use App\Exports\UsersExport;
use Yajra\DataTables\Services\DataTable;
 
class UsersDataTable extends DataTable
{
    protected string $exportClass = UsersExport::class;
}

Update your export class as needed. See official package docs: https://docs.laravel-excel.com/3.1/exports/collection.html

Example Export Class

<?php
// app/Exports/UsersExport.php
 
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'],
        ];
    }
}

Laravel DataTables

Laravel Excel Integration

Using Export Class

Example Export Class

See Also