*
public static xlsCell ( $row_number, $column_number ) | ||
$row_number | int, zero based | |
$column_number | int, zero based |
protected function initializeSheet($sheet_name) { //if already initialized if ($this->current_sheet == $sheet_name || isset($this->sheets[$sheet_name])) { return; } $sheet_filename = $this->tempFilename(); $sheet_xmlname = 'sheet' . (count($this->sheets) + 1) . ".xml"; $this->sheets[$sheet_name] = (object) array('filename' => $sheet_filename, 'sheetname' => $sheet_name, 'xmlname' => $sheet_xmlname, 'row_count' => 0, 'file_writer' => new XLSXWriter_BuffererWriter($sheet_filename), 'columns' => array(), 'merge_cells' => array(), 'max_cell_tag_start' => 0, 'max_cell_tag_end' => 0, 'finalized' => false); $sheet =& $this->sheets[$sheet_name]; $tabselected = count($this->sheets) == 1 ? 'true' : 'false'; //only first sheet is selected $max_cell = XLSXWriter::xlsCell(self::EXCEL_2007_MAX_ROW, self::EXCEL_2007_MAX_COL); //XFE1048577 $sheet->file_writer->write('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>' . "\n"); $sheet->file_writer->write('<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">'); $sheet->file_writer->write('<sheetPr filterMode="false">'); $sheet->file_writer->write('<pageSetUpPr fitToPage="false"/>'); $sheet->file_writer->write('</sheetPr>'); $sheet->max_cell_tag_start = $sheet->file_writer->ftell(); $sheet->file_writer->write('<dimension ref="A1:' . $max_cell . '"/>'); $sheet->max_cell_tag_end = $sheet->file_writer->ftell(); $sheet->file_writer->write('<sheetViews>'); $sheet->file_writer->write('<sheetView colorId="64" defaultGridColor="true" rightToLeft="false" showFormulas="false" showGridLines="true" showOutlineSymbols="true" showRowColHeaders="true" showZeros="true" tabSelected="' . $tabselected . '" topLeftCell="A1" view="normal" windowProtection="false" workbookViewId="0" zoomScale="100" zoomScaleNormal="100" zoomScalePageLayoutView="100">'); $sheet->file_writer->write('<selection activeCell="A1" activeCellId="0" pane="topLeft" sqref="A1"/>'); $sheet->file_writer->write('</sheetView>'); $sheet->file_writer->write('</sheetViews>'); $sheet->file_writer->write('<cols>'); $sheet->file_writer->write('<col collapsed="false" hidden="false" max="1025" min="1" style="0" width="11.5"/>'); $sheet->file_writer->write('</cols>'); $sheet->file_writer->write('<sheetData>'); }