My Existing Conditional Formatting Rules set by Excel are Lost after using objWriter->PHPEXCEL-save?

Topics: Developer Forum, Project Management Forum, User Forum
Apr 24, 2012 at 9:17 PM
Edited Apr 24, 2012 at 9:18 PM

Hello Comunity, my problem is that i have an already existing excel file with Conditional Formatting rules in a Column, i read it and save it with the next sentences:

$objReader = new PHPExcel_Reader_Excel2007();

$objPHPExcel = $objReader->load('../files/Reportes.xlsx');

//i set a value

 $objPHPExcel->getActiveSheet()->SetCellValue('F6', 10);

$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);



the output file is my Reportes.xlsx file without any Conditional Formating rules :S


i read in a post(a 2010 post)  that this is a bug, im using the 1.7.6 of PHPEXCEL

plz help me, Thanks 

May 22, 2013 at 5:38 PM

I have the same problem with PHPExcel_Reader_Excel2007 and PHPExcel_Reader_Excel5().

I use the 1.7.8 version of PHPEXCEL.

It's à bug in 1.78 version ?
May 23, 2013 at 6:25 PM
exact same problem.

What I'm trying to do is opening a xls with the template that I need, fill it with database info and then export it. Data is fine, but the selection list of some columns present in the original template are gone in the exported file.

Just wondering if phpExcel can't handle that or if its a bug.