phpExcel设置单元格全部加边框

    $styleThinBlackBorderOutline = array(
        'borders' => array(
            'allborders' => array( //设置全部边框
                'style' => PHPExcel_Style_Border::BORDER_THIN //粗的是thick
            ),

        ),
    );
    $objPHPExcel->getActiveSheet()->getStyle( 'A1:K12')->applyFromArray($styleThinBlackBorderOutline);

   说明:将坐标A1 到 K12 的地方全部加边框

原文地址:https://www.cnblogs.com/bk233/p/7866081.html