- //边框,颜色前面两位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');
