phpExcel设置单元格全部加边框
展开阅读全文

phpExcel设置单元格全部加所有线框

    $styleThinBlackBorderOutline = array(
        'borders' => array(
            'allborders' => array( //设置全部边框
                'style' => \PHPExcel_Style_Border::BORDER_THIN //粗的是thick
            ),
        ),
    );
    $objPHPExcel->getActiveSheet()->getStyle('A1:K12')->applyFromArray($styleThinBlackBorderOutline);
   说明:将坐标A1 到 K12 的地方全部加边框