使用laravel excel导出
use Maatwebsite\Excel\Concerns\FromCollection;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\WithHeadings;
class ExportOrganizationRecord implements FromCollection, WithHeadings
{
public function headings(): array
{
return [
'#',
'User',
'Date',
];
}
public function collection()
{
$data = [
[1, 'don', '2020-02-20'],
[2, 'tom', '2020-02-20'],
];
return new Collection($data);
}
}
$export = new \App\Library\ExportOrganizationRecord();
return Excel::download($export, 'users.xlsx');
但导出的文件打不开,这是因为发送header()头之前,不知道又啥特殊字符输出,导致文件首行是个空白行或乱码。删除之后,Excel 就能正常打开了,所以在导出之前,可以使用ob_end_clean();清理下缓冲区