phpExcel设置表头边框颜色

最新推荐文章于 2023-03-30 11:34:06 发布

raoxiaoya

最新推荐文章于 2023-03-30 11:34:06 发布

阅读量1.8k

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/raoxiaoya/article/details/98598249

版权

PHP 专栏收录该内容

240 篇文章 5 订阅

订阅专栏

$excelObj->getActiveSheet()->setCellValue('A1', '填报人');
$excelObj->getActiveSheet()->setCellValue('B1', '时间');
$excelObj->getActiveSheet()->setCellValue('C1', '拜访对象');
$excelObj->getActiveSheet()->setCellValue('D1', '客户所在城市');
$excelObj->getActiveSheet()->setCellValue('E1', '标签');
$excelObj->getActiveSheet()->setCellValue('F1', '日志类型');
$excelObj->getActiveSheet()->setCellValue('G1', '客户意向');
$excelObj->getActiveSheet()->setCellValue('H1', '主要事宜');
$excelObj->getActiveSheet()->setCellValue('I1', '商谈结果');
$excelObj->getActiveSheet()->setCellValue('J1', '下次走访时间');
$excelObj->getActiveSheet()->setCellValue('K1', '机构来源');
$excelObj->getActiveSheet()->setCellValue('L1', '意向产品');
$excelObj->getActiveSheet()->setCellValue('M1', '打卡地址(达到)');
$excelObj->getActiveSheet()->setCellValue('N1', '打卡时间(达到)');
$excelObj->getActiveSheet()->setCellValue('O1', '打卡地址(离开)');
$excelObj->getActiveSheet()->setCellValue('P1', '打卡时间(离开)');
$excelObj->getActiveSheet()->setCellValue('Q1', '录音时长');

$styleArray = array(
    'borders' => array(
        'allborders' => array(
            'style' => \PHPExcel_Style_Border::BORDER_THICK,//边框是粗的
            'color' => array ('rgb' => '1FBB7D'),// 绿色
        ),
    ),
);

$excelObj->getActiveSheet()->getStyle('A1:Q1')->applyFromArray($styleArray);