workHour/app/Exports/ManActivityTimeCardMultipleSheetExport.php

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\WithMultipleSheets;

class ManActivityTimeCardMultipleSheetExport implements WithMultipleSheets
{
    protected $projectsData;

    /**
     * @param array $projectsData 格式为：[
     * 'RD01项目名' => [ [...行数据1], [...行数据2] ],
     * 'RD02项目名' => [ [...行数据1], [...行数据2] ],
     * ]
     * @param string $year
     */
    public function __construct(array $projectsData)
    {
        $this->projectsData = $projectsData;
    }

    /**
     * 定义多个 Sheet
     */
    public function sheets(): array
    {
        $sheets = [];

        foreach ($this->projectsData as $key => $data) {
            // 每一项都实例化之前写的那个 ProjectAnnualSalaryExport
            $sheets[] = new ManActivityTimeCardSheetExport($data['project'], $data['data'], $data['year']);
        }

        return $sheets;
    }
}