Monday, October 3, 2022

[FIXED] How can I change excel tab color using PHPExcel?

Issue

I need to change tab color to red in my sheet

$objPHPExcel->getActiveSheet()->setTitle('SHEET1');
$objPHPExcel->getActiveSheet()->getTab->setColor( new PHPExcel_Style_Color( PHPExcel_Style_Color::COLOR_RED ) );

Solution

I found a way

$objPHPExcel->getActiveSheet()->getTabColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);

or set desired colors by hex values

$objPHPExcel->getActiveSheet()->getTabColor()->setARGB('ff0000');


Answered By - FBilac
Answer Checked By - David Marino (PHPFixing Volunteer)

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.