Set Background cell color in PHPExcel

Question

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

I get it done with the solution of Muntashir Akon. See below with 33 votes (right now). — LUISAO, Feb 16 '20 at 13:56

score 156 · Accepted Answer · edited Nov 16 '12 at 12:35

156

$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/

edited Nov 16 '12 at 12:35

Ross

46,186
39
120
173

answered Jul 21 '11 at 13:26

user198003

11,029
28
94
152

5

This was incorrect syntax as of 2013-10-17. I have edited to reflect correct syntax. – Matt Humphrey Oct 17 '13 at 11:19
How to set background color in Excel Laravel library? – POV Aug 06 '19 at 21:54

score 84 · Answer 2 · edited Jan 13 '15 at 13:15

84

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');

enter image description here

edited Jan 13 '15 at 13:15

Alexxus

893
1
11
25

answered Jul 19 '13 at 01:41

Limitless isa

3,689
36
28

6

Your functions it's ok, but you are using global, and that's a real error... You should make use of the PHP5 features. Instead, you could try a lambda function such as https://eval.in/39136 :) – Cito Jul 26 '13 at 15:06

score 38 · Answer 3 · answered Jul 02 '15 at 07:50

38

This code should work for you:

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

But if you bother using this over and over again, I recommend using applyFromArray.

answered Jul 02 '15 at 07:50

Muntashir Akon

8,740
2
27
38

This solution worked for me. I try applyFromArray, but nothing happens. – LUISAO Feb 16 '20 at 13:54

score 11 · Answer 4 · answered Apr 24 '13 at 18:47

11

Seems like there's a bug with applyFromArray right now that won't accept color, but this worked for me:

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

answered Apr 24 '13 at 18:47

jocull

20,008
22
105
149

1

Though it is more elegant solution (as I prefer OOP way) it didn't worked for me :/ Used @user198003 provided solution – Aurimas Aug 15 '14 at 11:29

score 11 · Answer 5 · answered Jul 20 '14 at 13:35

11

This always running!

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

answered Jul 20 '14 at 13:35

Rogerio de Moraes

1,527
18
15

2

In some php version don't can break line at attribute class. Old version. – Rogerio de Moraes Jan 05 '15 at 10:55
3

**IMPORTANT! Than $objPHPExcel like $sheet is a define from object class PHPExcel. You need use like you instantiated (at new PHPExcel() define).** – Rogerio de Moraes Jan 08 '15 at 10:29
1

$objPHPExcel->getActiveSheet()->getStyle('A'.$row.':G'.$row)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setRGB('FF0000'); – Defkon1 Sep 25 '18 at 12:16

score 10 · Answer 6 · edited Mar 21 '22 at 16:03

Here is how you do it in PHPSpreadsheet, the newest version of PHPExcel

$spreadsheet = new Spreadsheet();

$spreadsheet->getActiveSheet()->getStyle('A1:F1')->applyFromArray([
    'fill' => [
            'fillType' => Fill::FILL_SOLID,
            'startColor' => [
                'rgb' => 'FFDBE2F1',
            ]           
    ],
]);

alternative approach:

$spreadsheet->getActiveSheet()
    ->getStyle('A1:F1')
    ->getFill()
    ->setFillType(Fill::FILL_SOLID)
    ->getStartColor()->setARGB('FFDBE2F1');

score 4 · Answer 7 · answered Jul 11 '17 at 11:17

4

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

answered Jul 11 '17 at 11:17

Vatsal Patel

317
5
15

score 1 · Answer 8 · edited Nov 14 '12 at 08:45

1

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

edited Nov 14 '12 at 08:45

J. Steen

15,470
15
56
63

answered Apr 05 '12 at 07:53

Abhishek Jaiswal

2,524
1
21
24

score 0 · Answer 9 · edited Jan 27 '19 at 11:24

0

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

It's in the documentation, located here: https://github.com/PHPOffice/PHPExcel/wiki/User-Documentation-Overview-and-Quickstart-Guide

edited Jan 27 '19 at 11:24

ThatTechGuy

879
1
10
29

answered Jan 27 '19 at 04:53

Reyler Chavez Gaona

11

score 0 · Answer 10 · answered Mar 12 '20 at 05:13

0

You can easily apply colours on cell and rows.

$sheet->cell(1, function($row) 
{ 
  $row->setBackground('#CCCCCC'); 
});

$sheet->row(1, ['Col 1', 'Col 2', 'Col 3']); 
$sheet->row(1, function($row) 
{ 
  $row->setBackground('#CCCCCC'); 
});

answered Mar 12 '20 at 05:13

pankaj

31
1
2

Set Background cell color in PHPExcel

10 Answers10

Linked