Reading xlsx with bar and line graph

Topics: Developer Forum
Jul 15, 2014 at 8:41 PM
Edited Jul 15, 2014 at 8:42 PM
Hi,

Iv been trying to read a template xlsx file and load data in. Just as a test I tried to read it in and then save it under a different name. This is mostly working except for one the line series contained within the graph.
This is the code I am using to read in the file:

$filetype = PHPExcel_IOFactory::identify("StoreTemplate.xlsx");
$objReader = PHPExcel_IOFactory::createReader($filetype);
$objReader->setIncludeCharts(TRUE);
$objPHPExcel = $objReader->load("StoreTemplate.xlsx");

And this is the code I am using to save the file:
$end = date('His');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');
$objWriter->setIncludeCharts(TRUE);
$objWriter->save('StoreRepeort'.$SID.$end.'.xlsx');

Is there any other setInclude things? or can any one spot a problem?


Also just to mention it seems to be slightly changing the percentage values, as in not displaying them
as percentages any more.

Any help would be much appreciated iv been staring at this and rewriting it for two days now getting no where.

Using the latest version of PHPExcel
And on a windows 8 machine


Thanks :)