workHour/app/Exports/ResearchExpenseSummaryMultipleSheetExport.php

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\WithMultipleSheets;

class ResearchExpenseSummaryMultipleSheetExport implements WithMultipleSheets
{
    protected $data;

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

    public function sheets(): array
    {
        $sheets = [];
        foreach ($this->data as $year => $payload) {
            // 从 payload 中提取动态表头，如果没有则给默认值
            $dynamicHeaders = $payload['dynamic_headers'] ?? ['人员人工费用', '折旧费用'];

            $sheets[] = new ResearchExpenseSummarySheetExport($year, $payload, $dynamicHeaders);
        }
        return $sheets;
    }
}