您可以通过ChartCollection获取有关图表的所有信息。使用$activeSheet-> getTopLeftCell()，您可以在Excel中获取图表的位置，然后对其进行排序。然后使用该名称获取索引。
$realChartSorting包含ExcelSheet中的排序。

foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
    $spreadsheet->setActiveSheetIndexByName($loadedSheetName);
    $activeSheet = $spreadsheet->getActiveSheet();
    $realChartSorting = $this->getRealChartOrdering($activeSheet);
    foreach ($realChartSorting as $item) {
        $activeSheet->getChartByName($realChartSorting['chartName']);
        $activeSheet->getChartByIndex($realChartSorting['chartIndex']);
    }
}

private function getRealChartOrdering(Worksheet $activeSheet): array {
    $chartData = [];
    $chartNames = $activeSheet->getChartNames();
    $chartCollection = $activeSheet->getChartCollection();
    foreach ($chartCollection as $item) {
        $chartData[] = [
            'name' => $item->getName(),
            'pos' => $item->getTopLeftCell()
        ];
    }

    // Sort by position
    array_multisort(
        array_column($chartData, 'pos'), SORT_ASC,
        $chartData
    );

    $realChartSorting = [];
    foreach ($chartData as $data) {
        $realChartSorting[] = [
            'chartIndex' => array_search($data['name'], $chartNames),
            'chartName' => $data['name']
        ];
    }

    return $realChartSorting;
}

字符串