如何用php读取excel表格中的公式栏

require_once 'path/to/PHPExcel.php';

$objPHPExcel = PHPExcel_IOFactory::load('path/to/excel_file.xlsx');

$objPHPExcel->setActiveSheetIndex(0); // 选择第一个工作表

$cell = $objPHPExcel->getActiveSheet()->getCell('A1');
$value = $cell->getValue();

$calculatedValue = $cell->getCalculatedValue();

$highestRow = $objPHPExcel->getActiveSheet()->getHighestRow();
$highestColumn = $objPHPExcel->getActiveSheet()->getHighestColumn();

for ($row = 1; $row <= $highestRow; $row++) {
    for ($col = 'A'; $col <= $highestColumn; $col++) {
        $cell = $objPHPExcel->getActiveSheet()->getCell($col . $row);
        $value = $cell->getValue();
        // 处理公式栏的计算结果或公式本身
    }
}