Set background cell color in PHPExcel

Question

How to set specific color for active cell when creating XLS document in PHPExcel?

Answer 1

$sheet->getStyle('A1')->applyFromArray( array( 'fill' => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'FF0000') ) ) ); 

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

Answer 2

 function cellColor($cells,$color){ global $objPHPExcel; $objPHPExcel->getActiveSheet()->getStyle($cells)->getFill()->applyFromArray(array( 'type' => PHPExcel_Style_Fill::FILL_SOLID, 'startcolor' => array( 'rgb' => $color ) )); } cellColor('B5', 'F28A8C'); cellColor('G5', 'F28A8C'); cellColor('A7:I7', 'F28A8C'); cellColor('A17:I17', 'F28A8C'); cellColor('A30:Z30', 'F28A8C'); 

Answer 3

This code should work for you:

  $PHPExcel->getActiveSheet() ->getStyle('A1') ->getFill() ->setFillType(PHPExcel_Style_Fill::FILL_SOLID) ->getStartColor() ->setRGB('FF0000') 

But if you keep using it over and over again, I recommend using applyFromArray .

Answer 4

There seems to be a bug with applyFromArray right now that won't take color, but this worked for me:

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

Answer 5

It always works!

$sheet->getActiveSheet()->getStyle('A1')->getFill()->getStartColor()->setRGB('FF0000');

Answer 6

 $objPHPExcel ->getActiveSheet() ->getStyle('A1') ->getFill() ->setFillType(PHPExcel_Style_Fill::FILL_SOLID) ->getStartColor() ->setRGB('colorcode'); //ie,colorcode=D3D3D3 

Answer 7

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

Answer 8

  $objPHPExcel->getActiveSheet()->getStyle('B3:B7')->getFill() ->setFillType(PHPExcel_Style_Fill::FILL_SOLID) ->getStartColor()->setARGB('FFFF0000'); 

This is in the documentation located here: https://github.com/PHPOffice/PHPExcel/wiki/User-Documentation-Overview-and-Quickstart-Guide