PHPExcel SUM 返回0

標籤：flow   tin   blank   obj   color   方法   .com   a10   tar   

使用PHPExcel 匯出Excel最後的代碼是:

$objWriter = PHPExcel_IOFactory::createWriter($this->excel, ‘Excel2007‘);//force user to download the Excel file without writing it to server‘s HD$objWriter->save(‘php://output‘);

 匯出的Excel的"=SUM(A1:A10)"的和還是0，解決方案是在"$objWriter->save(‘php://output‘);"之前添加"$objWriter->setPreCalculateFormulas(true);"

 

參考: PhpExcel SUM() returning 0

PHPExcel SUM 返回0