CODEWITHSUNDEEP
phpphpexcel
Jarkid
Jarkid

Reputation: 181

PHPExcel: How to get a CELL COLOR

I am using PHPExcel project, but I am having a question in mind, and without solution on the earth.

I had googled for this question for a while, but I CAN NOT find a way to get a CELL BACKGROUND COLOR!

I tried to use the method 'getColor()' or what ... it doesn't work or just shows the warning message...

Can somebody please tell me how to get a CELL COLOR using PHPExcel? THANKS

Upvotes: 7

Views: 21498

Answers (3)

Elango Mani
Elango Mani

Reputation: 364

to set background for specific cells.it's works for me

$objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->applyFromArray(array('type' => PHPExcel_Style_Fill::FILL_SOLID,'startcolor' => array('rgb' =>'FF1E1E')

Upvotes: 0

Abhishek Jaiswal
Abhishek Jaiswal

Reputation: 2684

examples< http://bayu.freelancer.web.id/2010/07/16/phpexcel-advanced-read-write-excel-made-simple/

Upvotes: 0

Mark Baker
Mark Baker

Reputation: 212402

$objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->getStartColor()->getARGB();

or

$objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->getStartColor()->getRGB();

Upvotes: 21

Related Questions