Question

PHPExcel能不能合并后居中表格的内容啊

Answer 1

可以
$objPHPExcel->getActiveSheet()->mergeCells('A1:D1');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal()->setVertical()

Answer 2

//合并单元格
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A'. $j . ':A' . ($i - 1));
// 垂直居中
$objPHPExcel->setActiveSheetIndex(0)->getStyle('A'. $j)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);