How to change cell color in PHPSpreadsheet

Question

Are you able to change the color of a cell in a .xlsx file with PHPspreadsheet? Couldn't find anything in their function list or on Stack Overflow.

Perhaps you should read the [docs](https://phpspreadsheet.readthedocs.io/en/develop/topics/recipes/) particularly the section on styles — Mark Baker, Feb 09 '18 at 19:32

score 25 · Accepted Answer · answered Apr 27 '18 at 02:51

25

Tries to look this link Here

$spreadsheet->getActiveSheet()->getStyle('B2')
->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);

answered Apr 27 '18 at 02:51

Natan Augusto

360
5
5

It is changing the Text color only. I want to change the Background of Cell – Irshad Khan Sep 18 '20 at 06:11
@IrshadKhan please check my answer above – Mannyfatboy Sep 14 '21 at 05:29

score 5 · Answer 2 · answered Sep 14 '21 at 05:28

For those who understand "change cell color" as Background color and not Text color, the right code is:

$spreadsheet->getActiveSheet()->getStyle('[YOUR_CELL_OR_RANGE_HERE]')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('YOUR_COLOR_CODE_HERE');

Example:

$spreadsheet->getActiveSheet()->getStyle('E2')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('FFFF0000');

score 0 · Answer 3 · answered Dec 01 '21 at 08:04

0

Tries to look this link

$spreadsheet->getActiveSheet()->getStyle('B2')->getFont()->setColor(
    new \PhpOffice\PhpSpreadsheet\Style\Color(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED)
);

answered Dec 01 '21 at 08:04

Alex78191

2,383
2
17
24

How to change cell color in PHPSpreadsheet

3 Answers3