如何在PhpSpreadsheet中从合并单元格读取值

use PhpOffice\PhpSpreadsheet\IOFactory;

$spreadsheet = IOFactory::load('example.xlsx');

$worksheet = $spreadsheet->getActiveSheet();

$mergedCells = $worksheet->getMergeCells();

foreach ($mergedCells as $mergedCell) {
    // 解析合并单元格的范围
    $range = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::splitRange($mergedCell);
    
    // 获取合并单元格的起始单元格
    $startCell = $range[0][0];
    
    // 读取合并单元格的值
    $value = $worksheet->getCell($startCell)->getValue();
    
    // 处理合并单元格的值
    // ...
}

$values = [];

foreach ($mergedCells as $mergedCell) {
    // 解析合并单元格的范围
    $range = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::splitRange($mergedCell);
    
    // 获取合并单元格的起始单元格
    $startCell = $range[0][0];
    
    // 读取合并单元格的值
    $value = $worksheet->getCell($startCell)->getValue();
    
    // 处理合并单元格的值
    $values[] = $value;
}

// 对合并单元格的值进行进一步处理
// ...