PHPExcel 设置样式,背景颜色,居中,宽,单元格合并

//设置第一行背景色为FFFF00
$objPHPExcel
    ->getActiveSheet()
    ->getStyle('A1')
    ->getFill()
    ->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)
    ->getStartColor()
    ->setRGB('FFFF00');
//合并单元格
$objPHPExcel->getActiveSheet()->mergeCells('A1:F1');
//设置居中
$objPHPExcel
    ->getActiveSheet()
    ->getStyle('A1:F1')
    ->getAlignment()
    ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
//字体
$objPHPExcel
    ->getActiveSheet()
    ->getStyle('E2')
    ->getFont()
    ->setName('宋体')
    ->setBold(true);
//字体加粗
//设置宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
//设置垂直居中
$objPHPExcel->getActiveSheet()->getstyle("C".$num.":C".$num1)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
//设置左右居中
$objPHPExcel->getActiveSheet()->getStyle('A5:G5')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);