PHPExcel-图表渲染和加载Excel给出错误 [英] PHPExcel - chart rendering and load excel giving error

问题描述

require_once('PHPExcel-1.7.7/Classes/PHPExcel.php');

$inputFileName = 'RN Tracker.xlsx';

$inputFileType = PHPExcel_IOFactory::identify($inputFileName);

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

如果我尝试关注

$objReader->setIncludeCharts(TRUE);

在加载过程中，我收到以下错误消息:

during load i get following error message:

Warning: PHPExcel_Reader_Excel2007::load(): Node no longer exists in /users/pravkum4/html/tracker/PHPExcel-1.7.7/Classes/PHPExcel/Reader/Excel2007.php on line 1518

Notice: Trying to get property of non-object in /users/pravkum4/html/tracker/PHPExcel-1.7.7/Classes/PHPExcel/Reader/Excel2007.php on line 1519

Fatal error: Call to a member function children() on a non-object in /users/pravkum4/html/tracker/PHPExcel-1.7.7/Classes/PHPExcel/Reader/Excel2007.php on line 1519

我在这里犯什么错误? 我应该为图表添加一些其他课程吗?

What mistake i am doing here? Should i include some additional class for chart?

阅读器的加载方法默认是否包含图表选项?图表计数为0.:(( 有时可以提供正确的图表计数，但是无法正常显示.

Does chart option is included by default in load method of reader? chart count gives 0. :(( Sometimes gives correct chart count but rendering doesn't work.

还有一件事，这段代码是什么?不为我工作.有时我会丢失jpgraph_pie.php.

One more thing, what is this code? not working for me. Sometimes i get jpgraph_pie.php missing.

PHPExcel_Settings::setChartRenderer(
    PHPExcel_Settings::CHART_RENDERER_JPGRAPH,
    dirname(__FILE__).'/../../libraries/Charts/jpgraph3.5.0b1/src'
);

请提供图表渲染教程.非常感谢您.

Please provide a tutorial for chart rendering. Thank you so much in Advance.

推荐答案

我尚未在CodePlex或Github上的PHPExcel网站上看到此问题，并且要解决此问题，您需要上传示例演示问题的文件，以便我们可以识别Excel数据中不再存在的节点

I have yet to see this issue raised at the PHPExcel sites on either CodePlex or on Github... and to resolve it you'll need to upload a sample file that demonstrates the problem so that we can identify what node no longer exists in the Excel data

这篇关于PHPExcel-图表渲染和加载Excel给出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！