Set Background color specific cells
$styleArray = array(
'font' => array(
'bold' => true,
'color' => array('rgb' => '000000'),
'size' => 15,
'name' => 'Arial'
),
'fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array(
'rgb' => '61BD09'
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A7:Z7')->applyFromArray($styleArray);
Comments
Post a Comment