ThinkPHP调用Excel类的基本用法设置（合并单元格,Sheet表标题，行高，列宽，字体，边框，样式）

合并单元格+字体样式

//合并单元格
$objPHPExcel->getActiveSheet(0)->mergeCells('A1:R1');
//为合并单元格添加标题
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', "XX公司项目");
//字体加粗
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);  
//设置字体size大小
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Times New Roman')->setSize(22);

设置Sheet表标题

$objPHPExcel->getActiveSheet()->setTitle("项目拆除计划");

设置行高-列宽

//设置行高
$objPHPExcel->getActiveSheet(0)->getRowDimension('4')->setRowHeight(50); 
//设置列宽
$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(130); 

设置边框

//设置单元格边框
$styleThinBlackBorderOutline = array(
    'borders' => array (
        'allborders' => array (                               //allborders  表示全部线框
            'style' => \PHPExcel_Style_Border::BORDER_THIN,   //设置border样式
            'color' => array ('argb' => 'FF000000'),          //设置border颜色
        ),
    ),
);
$objPHPExcel->getActiveSheet()->getStyle( 'A4:R11')->applyFromArray($styleThinBlackBorderOutline);

设置垂直居中

$objPHPExcel->setActiveSheetIndex()->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);

设置水平居中

$objPHPExcel->setActiveSheetIndex()->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);