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.
How to change cell color in PHPSpreadsheet
36.5k views Asked by jdwee At
3
There are 3 answers
0

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

Tries to look this link
$spreadsheet->getActiveSheet()->getStyle('B2')->getFont()->setColor(
new \PhpOffice\PhpSpreadsheet\Style\Color(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED)
);
Tries to look this link Here