jucai/app/Admin/Exports/Caiqing/JobGapExport.php

<?php
namespace App\Admin\Exports\Caiqing;

use App\Admin\Exports\RowExport;
use Illuminate\Support\Collection;

class JobGapExport extends RowExport
{
    public $name = '';

    function __construct($name){
        $this->name = $name;
    }
    /**
     * 设置标题,返回标题数组
     * @return array
     */
    public function headings(): array
    {
        return [
            '职业',
           // '职业代码',
            '需求人数',
            '求职人数',
            '缺口数',
            '求人倍率'
        ];
    }
    /**
     * 处理行数据
     * @param Model $row
     * @return array
     */
    public function map($row): array
    {
        $result['cate_name'] = $row['cate_name'];
        $result['job_amount'] = $row['job_num'].'';
        $result['resume_num'] = $row['resume_num'].'';
        $result['gap'] = $row['gap'].'';
        $result['rate'] = $row['rate'].'';
        return $result;
    }

    /**
     * 设置文件名
     * @return string
     */
    public function getFilename(): string
    {
        return $this->name.".xlsx";
    }

    /**
     * 格式化指定列.
     * 只有在需要的时候设置,例如在身份证不要显示科学计数时设定列格式:['A'=>NumberFormat::FORMAT_NUMBER]
     * @return array
     */
    public function columnFormats(): array
    {
        return [
        ];
    }
}