PHPSpreadsheet - How do create text that is red colored?

Asked Feb 19 '19 at 17:19

Active Feb 19 '19 at 18:15

Viewed 1,185 times

I use the next line to color a cell red.:

$spreadsheet->getActiveSheet()->getStyle('O'.$i)->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID);
$spreadsheet->getActiveSheet()->getStyle('O'.$i)->getFill()->getStartColor()->setARGB('FF2911');

But i don't get it fixed to color the text red and not the cell. I tryed using what they saying here link , but for some reasen i don't get it to work.

I also tryed this, but nothing changes.:

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

Can somebody help me please.

edited Feb 19 '19 at 18:15

asked Feb 19 '19 at 17:19

Pascal

Try to change getFill to getFont – Andrii Filenko Feb 19 '19 at 17:41
if i try that the script fails – Pascal Feb 19 '19 at 18:07
1

Solved! Stupid from my side, on the end of my code i make everything one color. – Pascal Feb 19 '19 at 18:25

PHPSpreadsheet - How do create text that is red colored?

0 Answers0