此库为 node-admin 扩展库
composer require node-admin/data-transform-for-excel
/** @var \NodeAdmin\Lib\NodeContent\Table $table */
$table->actions(function (Table\ActionsContainer $container){
$export = new DataExport();
$export->setDataUrl(route('admin.test.export'));
$container->addAction($export);
});
// export action
public function export(){
return Test::query()->paginate();
}
增加配置导出模式
use NodeAdmin\DataTransformForExcel\NodeContent\Table\Actions\DataExport;
$table->actions(function (Table\ActionsContainer $container){
$export = new DataExport();
$export->setConfigUrl(route('admin.test.export.config'));
$container->addAction($export);
});
// export config
public function exportConfig()
{
return new DataExportConfigResponse(
route('admin.test.export'), // 导出数据url
// 字段列表 key为字段名,header为表头
[
['key' => 'title', 'header' => '标题'],
]
);
}
// export action
public function export(){
return Test::query()->paginate();
}