如何在使用PHPExcel添加新行时保持来自另一个工作表的单元格引用更新

$objPHPExcel = PHPExcel_IOFactory::load('your_excel_file.xlsx');

$sourceSheet = $objPHPExcel->getSheetByName('source_sheet');
$targetSheet = $objPHPExcel->getSheetByName('target_sheet');

$cellValue = $sourceSheet->getCell('A1')->getValue();

$newRow = $targetSheet->getHighestRow() + 1;
$targetSheet->setCellValue('A' . $newRow, $cellValue);

$targetSheet->updateFormulaCell('B1', '=source_sheet!A1');

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