在dataTables Laravel中添加csv和excel导出按钮

Route::get('/export-csv', 'ExportController@exportCsv')->name('export.csv');
Route::get('/export-excel', 'ExportController@exportExcel')->name('export.excel');

php artisan make:controller ExportController

use App\Models\User; // 假设我们导出用户数据

class ExportController extends Controller
{
    public function exportCsv()
    {
        $users = User::all(); // 获取用户数据

        $csvExporter = new \LaravelCsvGenerator\Exports\CsvExport($users); // 使用LaravelCsvGenerator生成CSV文件
        return $csvExporter->download('users.csv');
    }

    public function exportExcel()
    {
        $users = User::all(); // 获取用户数据

        $excelExporter = new \LaravelExcelExporter\Exports\ExcelExport($users); // 使用LaravelExcelExporter生成Excel文件
        return $excelExporter->download('users.xlsx');
    }
}

$(document).ready(function() {
    $('#dataTable').DataTable({
        buttons: [
            {
                extend: 'csv',
                className: 'btn btn-primary',
                text: '导出CSV',
                exportOptions: {
                    columns: ':visible'
                }
            },
            {
                extend: 'excel',
                className: 'btn btn-primary',
                text: '导出Excel',
                exportOptions: {
                    columns: ':visible'
                }
            }
        ]
    });
});