如何在PHPExcel中读取合并单元格和带背景颜色的单元格

<?php
require_once 'path/to/PHPExcel/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;

// 加载Excel文件
$excelFile = 'path/to/your/excel/file.xlsx';
$spreadsheet = IOFactory::load($excelFile);

// 选择工作表
$worksheet = $spreadsheet->getActiveSheet();

// 读取合并单元格
$mergedCells = $worksheet->getMergeCells();
foreach ($mergedCells as $mergedCell) {
    list($startCell, $endCell) = explode(':', $mergedCell);
    $mergedCellValue = $worksheet->getCell($startCell)->getValue();
    echo "合并单元格范围：$mergedCell，值：$mergedCellValue\n";
}

// 读取带背景颜色的单元格
$highestRow = $worksheet->getHighestRow();
$highestColumn = $worksheet->getHighestColumn();
for ($row = 1; $row <= $highestRow; $row++) {
    for ($column = 'A'; $column <= $highestColumn; $column++) {
        $cellAddress = $column . $row;
        $cellStyle = $worksheet->getStyle($cellAddress);
        $fill = $cellStyle->getFill();
        $backgroundColor = $fill->getStartColor()->getRGB();
        echo "单元格地址：$cellAddress，背景颜色：$backgroundColor\n";
    }
}
?>