Why is cell color not being set in PHP Spreadsheet?

Question

PHP

Trying out the code

$worksheet->getCell('B1')->getStyle()->getFill()->getStartColor()->setARGB('FFF5F2DD');

Not set. Still a white box. Tried using applyFromArray - not suitable /
Tell me how to change the color of the cell?

Answer 1

You need to add the SetFillType method

$sheet->getStyle('B1')
            ->getFill()
            ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
            ->getStartColor()
            ->setARGB('FFF50000');

Taken from here :)