test/app/Exports/SocialTemplateExport.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 SocialTemplateExport implements FromArray, ShouldAutoSize, WithEvents
{
    use Exportable;

    public $dataList;

    public function __construct(array $dataList)
    {
        $this->dataList = $dataList;
    }

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

    public function registerEvents(): array
    {
        return [
            AfterSheet::class  => function(AfterSheet $event) {

                $event->sheet->getDelegate()->getParent()->getDefaultStyle()->getFont()->setName('Verdana');
                for ($i = 0; $i<=1265; $i++) {
                    $event->sheet->getDelegate()->getRowDimension('A')->setRowHeight(30);
                    $event->sheet->getDelegate()->getRowDimension($i)->setRowHeight(30);
                }
            }
        ];
    }
}