excel合并单元格和左对齐

//横向合并单元格
//$objPHPExcel->getActiveSheet()->mergeCells('A2:A5');

//单个居中

$objPHPExcel->getActiveSheet()->getStyle('F3')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

 

$objPHPExcel->getActiveSheet()->getStyle('A5:AA5')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

 

//左对齐

$objPHPExcel->getActiveSheet()->getstyle("A2:E2")->getAlignment()
    ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);