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

namespace App\Exports;
use Yajra\DataTables\Exports\DataTablesCollectionExport;
classUsersExportextendsDataTablesCollectionExport
{
}

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

classUsersDataTableextendsDataTable
{
protected$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

namespace App\Exports;
use Maatwebsite\Excel\Concerns\WithMapping;
use Yajra\DataTables\Exports\DataTablesCollectionExport;
classUsersExportextendsDataTablesCollectionExportimplementsWithMapping
{
publicfunctionheadings():array
 {
return [
'Name',
'Email',
 ];
 }
publicfunctionmap($row):array
 {
return [
$row['name'],
$row['email'],
 ];
 }
}

Edit this page on GitHub