Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PHPExcel: How to get a CELL COLOR

Tags:

php

phpexcel

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

like image 659
Jarkid Avatar asked Nov 02 '11 03:11

Jarkid


1 Answers

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

or

$objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->getStartColor()->getRGB();
like image 103
Mark Baker Avatar answered Oct 14 '22 21:10

Mark Baker