test/app/Exports/EditingScheduleExport.php

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/9/24 0024
 * Time: 13:38
 */

namespace App\Exports;


use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;//自动宽度
use Maatwebsite\Excel\Events\AfterSheet;
use Maatwebsite\Excel\Concerns\WithEvents;

class EditingScheduleExport extends CommonExport implements FromArray, WithEvents//,ShouldAutoSize
{
    use Exportable;

    public $dataList;
    public $list;

    public function __construct(array $dataList)
    {
        $this->list = [];
        foreach ($dataList as $key => $value) {

            if ($key >= 3) {

                if (isset($value['is_backstage']) && $value['is_backstage'] == 1) {
                    $this->list[] = 'F' . ($key + 1);
                }
                if (isset($value['is_first_mail']) && $value['is_first_mail'] == 1) {
                    $this->list[] = 'G' . ($key + 1);
                }
                if (isset($value['is_data']) && $value['is_data'] == 1) {
                    $this->list[] = 'H' . ($key + 1);
                }
                if (isset($value['is_folder']) && $value['is_folder'] == 1) {
                    $this->list[] = 'I' . ($key + 1);
                }
                if (isset($value['is_order_index']) && $value['is_order_index'] == 1) {
                    $this->list[] = 'J' . ($key + 1);
                }
                if (isset($value['is_product_index']) && $value['is_product_index'] == 1) {
                    $this->list[] = 'K' . ($key + 1);
                }
                if (isset($value['is_test_station']) && $value['is_test_station'] == 1) {
                    $this->list[] = 'L' . ($key + 1);
                }
                if (isset($value['is_opinion']) && $value['is_opinion'] == 1) {
                    $this->list[] = 'M' . ($key + 1);
                }
                if (isset($value['is_project_group']) && $value['is_project_group'] == 1) {
                    $this->list[] = 'N' . ($key + 1);
                }
                if (isset($value['is_client_feedback']) && $value['is_client_feedback'] == 1) {
                    $this->list[] = 'O' . ($key + 1);
                }
                if (isset($value['is_online_inspection_form']) && $value['is_online_inspection_form'] == 1) {
                    $this->list[] = 'P' . ($key + 1);
                }
                if (isset($value['is_in_group_inspection']) && $value['is_in_group_inspection'] == 1) {
                    $this->list[] = 'Q' . ($key + 1);
                }
                if (isset($value['is_quality_inspection_departments']) && $value['is_quality_inspection_departments'] == 1) {
                    $this->list[] = 'R' . ($key + 1);
                }
                if (isset($value['is_optimization']) && $value['is_optimization'] == 1) {
                    $this->list[] = 'S' . ($key + 1);
                }

                $dataList[$key]['is_backstage'] = '后台搭建';
                $dataList[$key]['is_first_mail'] = '第一封邮件';
                $dataList[$key]['is_data'] = '资料进度表';
                $dataList[$key]['is_folder'] = '共享盘文件夹整理';
                $dataList[$key]['is_order_index'] = '单页面提供完整';
                $dataList[$key]['is_product_index'] = '产品页面提供完整';
                $dataList[$key]['is_test_station'] = '测试站检查表';
                $dataList[$key]['is_opinion'] = '组内意见';
                $dataList[$key]['is_project_group'] = '项目部群';
                $dataList[$key]['is_client_feedback'] = '客户反馈';
                $dataList[$key]['is_online_inspection_form'] = '上线检查表格';
                $dataList[$key]['is_in_group_inspection'] = '组内检查';
                $dataList[$key]['is_quality_inspection_departments'] = '质检部';
                $dataList[$key]['is_optimization'] = 'Hina&优化师检查';

            }
        }
        $this->dataList = $dataList;
    }

    public function array(): array
    {
        return $this->dataList;
    }

    public function registerEvents(): array
    {
        return [
            AfterSheet::class => function (AfterSheet $event) {
                $cells = ['A1:S1', 'A2:E2', 'F2:G2', 'H2:K2', 'L2:O2', 'P2:S2'];
                $this->setCellWidth($event, $cells);
                $cells[] = 'A3:S3';
                $this->setCellColor($cells, $event);//表头
                $this->setCellColorBorders($cells, $event);
                $this->setCellColor($this->list, $event, '87CEFA');
            }
        ];
    }


}