//边框,颜色前面两位00是透明度,后面6位上线颜色,必须加前面两位透明度,不然颜色你会发现不是你的颜色
$styleArray = array(
'borders' => array(
'allborders' => array(
'style' => \PHPExcel_Style_Border::BORDER_THIN,//细边框
'color' => array('argb' => '00c8cfd9'),
),
),
);
$objPHPExcel->getActiveSheet()->getStyle( "A$num:L$num")->applyFromArray($styleArray);
//背景颜色,背景色不能加00
$objPHPExcel->getActiveSheet()->getStyle("A$num:L$num")->getFill()
->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)
->getStartColor()
->setRGB('dee0e3');