表頭設(shè)置

use Maatwebsite\Excel\Concerns\WithHeadings;
... ...

public function headings(): array
    {
        return array_column([
            '序號(hào)','姓名'
        ]);
    }

表標(biāo)題設(shè)置

use Maatwebsite\Excel\Concerns\WithTitle;
... ...

public function title(): string
    {
        return '匯總總表';
    }

設(shè)置單元格

use Maatwebsite\Excel\Concerns\WithStyles;
... ...

public function styles(Worksheet $sheet)
    {
        // 凍結(jié)行
        $sheet->freezePaneByColumnAndRow('1','2');
        // 合并單元格
        $sheet->mergeCells('A1:F1');
        // 設(shè)置字體顏色和背景色
        $sheet->getStyle('A1:J1')->applyFromArray([
            'font' => [
                'name' => '宋體',
                'bold' => true,
                'italic' => false,
                'strikethrough' => false,
                'color' => [
                    'rgb' => 'FFFFFF'
                ]
            ],
            'fill' => [
                'fillType' => 'linear', //線性填充，類似漸變
                'rotation' => 45, //漸變角度
                'startColor' => [
                    'rgb' => '34A8E7' //初始顏色
                ],
                //結(jié)束顏色，如果需要單一背景色，請(qǐng)和初始顏色保持一致
                'endColor' => [
                    'argb' => '34A8E7'
                ]
            ]
        ]);
    }

列文本格式設(shè)置

use PhpOffice\PhpSpreadsheet\Cell\Cell;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
use PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder;
... ...
class xxx extends DefaultValueBinder implements FromCollection
... ...

public function bindValue(Cell $cell, $value)
    {
        $column = $cell->getColumn();
        if (in_array($column, ['D', 'E'])) {
            $cell->setValueExplicit($value, DataType::TYPE_STRING);
            return true;
        }
        return parent::bindValue($cell, $value);
    }

列寬設(shè)置

use Maatwebsite\Excel\Concerns\WithColumnWidths;
... ...

public function columnWidths(): array
    {
        return [
            'A' => 10,
            'C' => 10,
            'D' => 35,
            'H' => 10,
            'I' => 10,
            'J' => 25,
        ];
    }