public function generateAfterContent($row) { $colFirst = self::columnName(1); $row++; $afterContentBeginRow = $row; $sheet = $this->_objPHPExcelSheet; foreach ($this->contentAfter as $contentAfter) { $sheet->setCellValue($colFirst . $row, $contentAfter['value'], true); $sheet->getStyle($colFirst . $row)->applyFromArray(ArrayHelper::merge($this->_defaultStyleOptions, isset($contentAfter['styleOptions']) ? ArrayHelper::getValue($contentAfter['styleOptions'], $this->_exportType, []) : [])); $row += 1; } for ($i = $afterContentBeginRow; $i < $row; $i++) { $sheet->mergeCells($colFirst . $i . ":" . self::columnName($this->_endCol) . $i); } }