Formatting from array not working

Topics: Developer Forum, User Forum
Jan 24, 2008 at 3:46 PM
Edited Jan 24, 2008 at 3:47 PM
Trying this but not getting Navy background with White text:
$objPHPExcel->getActiveSheet()->duplicateStyleArray(
array(
'borders' =>
array(
'top'=>
array(
'style'=>PHPExcelStyleBorder::BORDER_THICK
),
'bottom'=>
array(
'style'=>PHPExcelStyleBorder::BORDER_THICK
)
),
'fill' =>
array(
'type'=> PHPExcelStyleFill::FILL_SOLID,
'startcolor'=>
array(
'argb' =>'00C0C0C0'
),
),
'font' =>
array(
'color' => array(PHPExcelStyleColor::COLOR_WHITE)
),
),
'A'.$row.':E'.$row);
Coordinator
Jan 25, 2008 at 6:37 AM
I think the color you used ('argb' =>'00C0C0C0') is something close to light gray?

Try using 0000137F instead.