public function render() { $this->validate(); $xlsxTableHelper = new XlsxTableHelper($this->datasource, $this->template); $this->tableString = $xlsxTableHelper->renderTable(); $xlsxSheetHelper = new XlsxSheetHelper($this->datasource, $this->template); $this->sheetString = $xlsxSheetHelper->renderSheet(); $xlsxSharedStringsHelper = new XlsxSharedStringsHelper($this->datasource, $this->template); $this->sharedStringsString = $xlsxSharedStringsHelper->renderSharedStrings(); $xlsxStyleHelper = new XlsxStyleHelper($this->datasource, $this->template); $this->styleString = $xlsxStyleHelper->renderStyle(); $this->output(); }
protected function doWriteSheetDataHeader() { $this->currentRow++; $this->sheetString .= "<row r=\"{$this->currentRow}\" spans=\"1:1\" x14ac:dyDescent=\"0.25\">"; foreach ($this->template->getFields() as $key => $fieldDescription) { $stringId = XlsxSharedStringsHelper::putIfNotExists($fieldDescription->getFieldCaption()); $colLetter = $this->getColumnLetters($key); $this->sheetString .= "<c r=\"{$colLetter}{$this->currentRow}\" t=\"s\"><v>{$stringId}</v></c>"; } $this->sheetString .= "</row>"; }
public function format($value) { $value = XlsxSharedStringsHelper::putIfNotExists(parent::format($value)); return empty($value) ? null : "<c r=\"cellAddress\" t=\"s\"><v>{$value}</v></c>"; }