Laravel Excel垂直居中对齐

composer require maatwebsite/excel

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\WithStrictParsing;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use PhpOffice\PhpSpreadsheet\Style\Alignment;

class MyExport implements WithStrictParsing, ShouldAutoSize
{
    public function headings(): array
    {
        return [
            'Header 1',
            'Header 2',
            'Header 3',
        ];
    }

    public function array(): array
    {
        return [
            ['Data 1', 'Data 2', 'Data 3'],
            ['Data 4', 'Data 5', 'Data 6'],
            ['Data 7', 'Data 8', 'Data 9'],
        ];
    }

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

                // 设置垂直居中对齐
                $alignment = new Alignment();
                $alignment->setVertical(Alignment::VERTICAL_CENTER);

                // 应用对齐方式到所有单元格
                $sheet->getStyle('A1:C3')->getAlignment()->applyFromArray($alignment);
            },
        ];
    }
}

use App\Exports\MyExport;
use Maatwebsite\Excel\Facades\Excel;

Excel::download(new MyExport(), 'my_export.xlsx');