php excel行合并单元格

Yii::$enableIncludePath = false;

        $objPHPExcel = new PHPExcel();

        //设置标题样式加粗跟居中

        $objPHPExcel->getActiveSheet()->getStyle('A1:L4')->getFont()->setBold(true);

        //$objPHPExcel->getActiveSheet()->getStyle('A1:K4')->getFont()->setSize(18);

        $objPHPExcel->getActiveSheet()->getStyle('A1:L4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

        //$objPHPExcel->getActiveSheet()->getStyle('A1:K4')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

 

        $objPHPExcel->getActiveSheet()->setTitle($res->kgc_examination_name.' 成绩汇总');

        $objPHPExcel->getActiveSheet()->setCellValue('A1', $res->kgc_examination_name.' 成绩汇总');

        $objPHPExcel->getActiveSheet()->mergeCells('A1:L1');

        $objPHPExcel->getActiveSheet()->setCellValue('A2', '考试时间：'.date('Y-m-d H:i:s',$res->examination_start_time).'~'.date('Y-m-d H:i:s',$res->examination_end_time));

        $objPHPExcel->getActiveSheet()->mergeCells('A2:L2');

        $objPHPExcel->getActiveSheet()->setCellValue('A3', '中心名称');

        $objPHPExcel->getActiveSheet()->mergeCells('A3'.':'.'A4');

        $objPHPExcel->getActiveSheet()->setCellValue('B3', 'UID');

        $objPHPExcel->getActiveSheet()->mergeCells('B3'.':'.'B4');

        $objPHPExcel->getActiveSheet()->setCellValue('C3', '姓名');

        $objPHPExcel->getActiveSheet()->mergeCells('C3'.':'.'C4');

        $objPHPExcel->getActiveSheet()->setCellValue('D3', '分数(选择题)');

        $objPHPExcel->getActiveSheet()->mergeCells('D3'.':'.'D4');

        $objPHPExcel->getActiveSheet()->setCellValue('E3', '主观题');

        $objPHPExcel->getActiveSheet()->mergeCells('E3:I3');

 

        $objPHPExcel->getActiveSheet()->setCellValue('E4', 'ID');

        $objPHPExcel->getActiveSheet()->setCellValue('F4', 'ID1');

        $objPHPExcel->getActiveSheet()->setCellValue('G4', 'ID2');

        $objPHPExcel->getActiveSheet()->setCellValue('H4', 'ID3');

        $objPHPExcel->getActiveSheet()->setCellValue('I4', 'ID4');

        $objPHPExcel->getActiveSheet()->setCellValue('J3', '总分');

        $objPHPExcel->getActiveSheet()->mergeCells('J3'.':'.'J4');

        $objPHPExcel->getActiveSheet()->setCellValue('K3', '评语');

        $objPHPExcel->getActiveSheet()->mergeCells('K3'.':'.'K4');

        $objPHPExcel->getActiveSheet()->setCellValue('L3', '附件目录');

        $objPHPExcel->getActiveSheet()->mergeCells('L3'.':'.'L4');

        $objPHPExcel->getActiveSheet()->getStyle('A')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);

      $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        $fileName = '考试名称_成绩汇总' . '.xls';
        header("Pragma: public");
        header("Expires: 0");
        header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
        header("Content-Type:application/force-download");
        header("Content-Type:application/vnd.ms-excel;");
        header("Content-Type:application/octet-stream");
        header("Content-Type:application/download");
        header("Content-Disposition:attachment;filename=" . $fileName);
        header("Content-Transfer-Encoding:binary");
        $objWriter->save('php://output');
        Jii::app()->end();