php - PHPExcel 中未加载图表

Question

您好，我刚刚加载了一个带有图表的 xlsx 文件，但是图表没有显示在输出中。

这是我的代码:

 $objPHPExcel=$objPHPExcel_new = new PHPExcel();
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load("../Graph_sample.xlsx");



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

Answer 1

因为大多数用户不想默认加载图表(加载/保存图表是一种速度和内存开销)，你必须使用setIncludeCharts() 明确告诉PHPExcel你想加载它们>:

$objPHPExcel=$objPHPExcel_new = new PHPExcel();
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objReader->setIncludeCharts(TRUE);
$objPHPExcel = $objReader->load("../Graph_sample.xlsx");

写作时

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