workHour/app/Exports/ResearchExpenseMultipleSheetExport.php

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\WithMultipleSheets;

class ResearchExpenseMultipleSheetExport implements WithMultipleSheets
{
    protected $sheetsData;

    /**
     * @param array $sheetsData 现在的格式应该是：
     * [
     * '2025-RD01' => ['project' => [...], 'data' => [...]],
     * '2025-RD02' => ['project' => [...], 'data' => [...]]
     * ]
     */
    public function __construct(array $sheetsData)
    {
        $this->sheetsData = $sheetsData;
    }

    public function sheets(): array
    {
        $sheets = [];
        foreach ($this->sheetsData as $sheetTitle => $content) {
            $sheets[] = new ResearchExpenseSheetExport(
                (string)$sheetTitle,
                $content['data'],
                $content['project'] ?? [],
                $content['dynamic_headers'] ?? [], // 传递动态表头
                $content['year']
            );
        }
        return $sheets;
    }
}