phpExcel 合并单元格

1、代码示例：

for ($i = 0, $len = count($data['rows']); $i < $len; $i++) {
                $y = $data['rows'][$i-1][20];
                $brr[] = $y;
                $objPHPExcel->setActiveSheetIndex(0)
                    ->setCellValue('A' . (3 + array_sum($brr)), $data['rows'][$i][-1])
                    ->setCellValue('B' . (3 + array_sum($brr)), $data['rows'][$i][0])
                    ->setCellValue('C' . (3 + array_sum($brr)), $data['rows'][$i][1])
                    ->setCellValue('D' . (3 + array_sum($brr)), $data['rows'][$i][2])
                    ->setCellValue('E' . (3 + array_sum($brr)), $data['rows'][$i][3])
                    ->setCellValue('F' . (3 + array_sum($brr)), $data['rows'][$i][4])
                    ->setCellValue('G' . (3 + array_sum($brr)), $data['rows'][$i][5])
                    ->setCellValue('H' . (3 + array_sum($brr)), $data['rows'][$i][6])
                    ->setCellValue('I' . (3 + array_sum($brr)), $data['rows'][$i][7])
                    ->setCellValue('J' . (3 + array_sum($brr)), $data['rows'][$i][8])
                    ->setCellValue('K' . (3 + array_sum($brr)), $data['rows'][$i][9])
                    ->setCellValue('L' . (3 + array_sum($brr)), $data['rows'][$i][10])
                    ->setCellValue('M' . (3 + array_sum($brr)), $data['rows'][$i][11])
                    ->setCellValue('N' . (3 + array_sum($brr)), $data['rows'][$i][12])
                    ->setCellValue('O' . (3 + array_sum($brr)), $data['rows'][$i][13])
                    ->mergeCells('A' .(3 + array_sum($brr)).':A'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('B' .(3 + array_sum($brr)).':B'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('C' .(3 + array_sum($brr)).':C'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('D' .(3 + array_sum($brr)).':D'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('E' .(3 + array_sum($brr)).':E'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('F' .(3 + array_sum($brr)).':F'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('G' .(3 + array_sum($brr)).':G'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('H' .(3 + array_sum($brr)).':H'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('I' .(3 + array_sum($brr)).':I'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('J' .(3 + array_sum($brr)).':J'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('K' .(3 + array_sum($brr)).':K'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('L' .(3 + array_sum($brr)).':L'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('M' .(3 + array_sum($brr)).':M'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('N' .(3 + array_sum($brr)).':N'.($data['rows'][$i][20]-1+3+ array_sum($brr)))
                    ->mergeCells('O' .(3 + array_sum($brr)).':O'.($data['rows'][$i][20]-1+3+ array_sum($brr)));
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('A'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('B'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('C'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('D'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('E'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('F'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('G'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('H'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('I'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('J'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('K'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('L'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('M'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('N'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
                $objPHPExcel->setActiveSheetIndex(0)->getStyle('O'.(3 + array_sum($brr)))->getAlignment()->setVertical
                (PHPExcel_Style_Alignment::VERTICAL_CENTER);
            $yarr[] = $data['rows'][$i-1][20];
            for($q=0;$q<$data['rows'][$i][20];$q++){
                $objPHPExcel->setActiveSheetIndex(0)
                    ->setCellValue('P'.(array_sum($yarr)+3+$q), $data['rows'][$i][14][$q+1])
                    ->setCellValue('Q'.(array_sum($yarr)+3+$q), $data['rows'][$i][15][$q+1])
                    ->setCellValue('R'.(array_sum($yarr)+3+$q), $data['rows'][$i][16][$q+1])
                    ->setCellValue('S'.(array_sum($yarr)+3+$q), $data['rows'][$i][17][$q+1])
                    ->setCellValue('T'.(array_sum($yarr)+3+$q), $data['rows'][$i][18][$q+1]);
                   
            }

            $objPHPExcel->getActiveSheet()->getRowDimension($i + 3)->setRowHeight(16);
        }
        ~~~