laravel8 Excel导出

 下载composer 拓展包

composer require maatwebsite/excel

创建导出类

php artisan make:export CompanyExport

找到生成的文件

app/Exports/CompanyExport.php

<?php

namespace App\Exports;

use App\Models\Company;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

class CompanyExport implements FromCollection, WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return Company::all();
    }

    public function headings() : array
    {
        return ['ID','企业名称','组织机构代码','企业分类','所属行业','企业分级','所属市区','更新时间'];
    }
}

控制器

    public function export()
    {
    	//导出方法
        $date = date('His');
        return Excel::download(new CompanyExport(),$date.'企业.xlsx');
    }