These are chat archives for PHPOffice/PHPExcel
I try to update an existing .xlxs file with PHPExcel. This file contains some graphs and data where each graph is store in a different sheet.
For this I load my excel file with the following code:
$objPHPExcel= new PHPExcel(); $objReader = PHPExcel_IOFactory::createReader('Excel2007'); $objReader -> setIncludeCharts(TRUE); $objPHPexcel = $objReader -> load('/my_existing_file.xlsx');
And when I save the file I use this snippet:
$objWriter = PHPExcel_IOFactory::createWriter($objPHPexcel, 'Excel2007'); $objWriter -> setIncludeCharts(TRUE); $filename = '/test.xlsx'; $objWriter -> save($filename);
My file test.xlsx is generated but my graphs are missing. Do you know why ?
PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings); the results are not the same for some reason