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.