<?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); } } ]; } }