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

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

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

class AgeExport 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 = [];
        foreach ($row as $k => $v) {
            $result['name']        = $row['name'];
            $result['job_amount']  = $row['job_amount'].'';
            $result['job_rate']    = $row['job_rate'].'%';
            $result['resume_num']  = $row['resume_num'].'';
            $result['resume_rate'] = $row['resume_rate'].'%';
            $result['multiple']    = $row['multiple'].'';
        }
        return $result;
    }

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

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