How to change the sheet title color background?

Question

Trying to change the background color of the sheet title with PHPSpreadsheet. No success with something like

`$sheet ->getTitle($sheet1)->getStyle()->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID);`

How would you address that specific cell ?

score 0 · Accepted Answer · answered Mar 13 '19 at 01:35

0

Get the argb value of color you want to set and write it in setARGB.

$cells='A1';
$spreadsheet->getActiveSheet()->getStyle($cells)->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('ffffff');

answered Mar 13 '19 at 01:35

Premlatha

1,676
2
20
40

score 0 · Answer 2 · answered Jul 19 '22 at 05:54

0

$worksheet->getTabColor()->setRGB('FF0000');

answered Jul 19 '22 at 05:54

Андрей Денисов

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jul 25 '22 at 19:18

How to change the sheet title color background?

2 Answers2