Change values in exist excel file

Topics: Developer Forum
Jul 12, 2012 at 2:11 PM

Hi, i have a problem of changing values in exist excel file.

I made a sample.xlsx that has values and many chart.

Anyway i can't create this all charts in the php code because there are to many charts.

therefore, i want to change only values of this file.

but if i opened a sample.xlsx file and change values than all charts disappear...

How can i do change values maintaining all charts??? Help me please!!!

 

i used this open code and change the cell.

$objPHPExcel = PHPExcel_IOFactory::load("sample.xlsx");

Coordinator
Jul 12, 2012 at 5:53 PM

Are you loading and saving the file with setIncludeCharts(TRUE) as shown in /Tests/32chartreadwrite.php

Jul 19, 2012 at 9:22 AM

Thank Mark Baker, I added that code and found another problems but fixed that.

I made a sample files using Excel 2010 and some charts are not supported in PHPExcel.