如何使用phpexcel将excel单元格设置为小数点后两位

require_once 'PHPExcel/PHPExcel.php';
$objPHPExcel = new PHPExcel();

$objPHPExcel = PHPExcel_IOFactory::load('example.xlsx');
$objPHPExcel->setActiveSheetIndex(0);
$sheet = $objPHPExcel->getActiveSheet();

foreach ($sheet->getRowIterator() as $row) {
    foreach ($row->getCellIterator() as $cell) {
        $value = $cell->getValue();
        if (is_numeric($value)) {
            $cell->setValue(round($value, 2));
            $cell->getStyle()->getNumberFormat()->setFormatCode('0.00');
        }
    }
}

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('example_modified.xlsx');