How to set phpexcel background color in php

Setting method: First use the "getActiveSheet()->getStyle("selected cell")" statement to set the specified cell style of the current workbook; then use applyFromArray() to access the style array; finally in the style Just add "'rgb'=>color value" to the array.

The operating environment of this tutorial: windows7 system, PHP7.1 version, DELL G3 computer

function cellColor($cells,$color){
    global $objPHPExcel;

    $objPHPExcel->getActiveSheet()->getStyle($cells)->getFill()->applyFromArray(array(
        'type' => PHPExcel_Style_Fill::FILL_SOLID,
        'startcolor' => array(
             'rgb' => $color        
             )
    ));
    }
    cellColor('B5', 'F28A8C');
    cellColor('G5', 'F28A8C');
    cellColor('A7:I7', 'F28A8C');
    cellColor('A17:I17', 'F28A8C');
    cellColor('A30:Z30', 'F28A8C');

Recommended: "2021 PHP interview questions summary (collection)" "php video tutorial》

The above is the detailed content of How to set phpexcel background color in php. For more information, please follow other related articles on the PHP Chinese website!