protected function buildHeader(VendingMachine $vendingMachine) { $this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(0, 1, "# " . ($this->phpExcelObject->getActiveSheetIndex() + 1)); $this->styleAlignHorizontalCenter(1, 1, 'A')->styleFontBold(1, 1, 'A'); $this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(1, 1, "Карта продаж автомата " . $vendingMachine->getChoiceLabel())->mergeCells($this->getPosition(1, 1)); $this->styleAlignHorizontalCenter(1, 1)->styleFontBold(1, 1); }