test/app/Exports/PlannerScheduleExport.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 PlannerScheduleExport 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_keywords']) && $value['is_keywords'] == 1) {
                    $this->list[] = 'F' . ($key + 1);
                }
                if (isset($value['is_keywords_map']) && $value['is_keywords_map'] == 1) {
                    $this->list[] = 'G' . ($key + 1);
                }
                if (isset($value['is_tdk']) && $value['is_tdk'] == 1) {
                    $this->list[] = 'H' . ($key + 1);
                }
                if (isset($value['is_keywords_implantation']) && $value['is_keywords_implantation'] == 1) {
                    $this->list[] = 'I' . ($key + 1);
                }
                if (isset($value['is_home_planning']) && $value['is_home_planning'] == 1) {
                    $this->list[] = 'J' . ($key + 1);
                }
                if (isset($value['is_product_guidance_document']) && $value['is_product_guidance_document'] == 1) {
                    $this->list[] = 'K' . ($key + 1);
                }
                if (isset($value['is_inside_page_planning']) && $value['is_inside_page_planning'] == 1) {
                    $this->list[] = 'L' . ($key + 1);
                }
                if (isset($value['is_special_page_planning']) && $value['is_special_page_planning'] == 1) {
                    $this->list[] = 'M' . ($key + 1);
                }

                $dataList[$key]['is_keywords'] = '关键词初选';
                $dataList[$key]['is_keywords_map'] = '关键词地图';
                $dataList[$key]['is_tdk'] = 'TDK';
                $dataList[$key]['is_keywords_implantation'] = '关键词植入';
                $dataList[$key]['is_home_planning'] = '首页策划';
                $dataList[$key]['is_product_guidance_document'] = '产品指导交流';
                $dataList[$key]['is_inside_page_planning'] = '内页策划';
                $dataList[$key]['is_special_page_planning'] = '特殊页策划';
            }
        }

        $this->dataList = $dataList;
    }

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

    public function registerEvents(): array
    {
        return [
            AfterSheet::class => function (AfterSheet $event) {
                $cells = ['A1:M1', 'A2:E2', 'F2:H2', 'I2:M2'];
                $this->setCellWidth($event, $cells);
                $cells[] = 'A3:M3';
                $this->setCellColor($cells, $event);//表头
                $this->setCellColorBorders($cells, $event);
                $this->setCellColor($this->list, $event, '87CEFA');
            }
        ];
    }


}