luya\helpers\XLSXWriter::initializeSheet()

Complexity

Conditions	10
Paths	17

Size

Total Lines

106

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    protected function initializeSheet(
        $sheet_name,
        $col_widths = array(),
        $auto_filter = false,
        $freeze_rows = false,
        $freeze_columns = false
    ) {
        //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,
            'auto_filter' => $auto_filter,
            'freeze_rows' => $freeze_rows,
            'freeze_columns' => $freeze_columns,
            '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">');
        if ($sheet->freeze_rows && $sheet->freeze_columns) {
            $sheet->file_writer->write('<pane ySplit="' . $sheet->freeze_rows . '" xSplit="' . $sheet->freeze_columns . '" topLeftCell="' . self::xlsCell(
                $sheet->freeze_rows,
                    $sheet->freeze_columns
            ) . '" activePane="bottomRight" state="frozen"/>');
            $sheet->file_writer->write('<selection activeCell="' . self::xlsCell(
                $sheet->freeze_rows,
                    0
            ) . '" activeCellId="0" pane="topRight" sqref="' . self::xlsCell($sheet->freeze_rows, 0) . '"/>');
            $sheet->file_writer->write('<selection activeCell="' . self::xlsCell(
                0,
                    $sheet->freeze_columns
            ) . '" activeCellId="0" pane="bottomLeft" sqref="' . self::xlsCell(
                        0,
                    $sheet->freeze_columns
                    ) . '"/>');
            $sheet->file_writer->write('<selection activeCell="' . self::xlsCell(
                $sheet->freeze_rows,
                    $sheet->freeze_columns
            ) . '" activeCellId="0" pane="bottomRight" sqref="' . self::xlsCell(
                        $sheet->freeze_rows,
                    $sheet->freeze_columns
                    ) . '"/>');
        } elseif ($sheet->freeze_rows) {
            $sheet->file_writer->write('<pane ySplit="' . $sheet->freeze_rows . '" topLeftCell="' . self::xlsCell(
                $sheet->freeze_rows,
                    0
            ) . '" activePane="bottomLeft" state="frozen"/>');
            $sheet->file_writer->write('<selection activeCell="' . self::xlsCell(
                $sheet->freeze_rows,
                    0
            ) . '" activeCellId="0" pane="bottomLeft" sqref="' . self::xlsCell(
                        $sheet->freeze_rows,
                    0
                    ) . '"/>');
        } elseif ($sheet->freeze_columns) {
            $sheet->file_writer->write('<pane xSplit="' . $sheet->freeze_columns . '" topLeftCell="' . self::xlsCell(
                0,
                    $sheet->freeze_columns
            ) . '" activePane="topRight" state="frozen"/>');
            $sheet->file_writer->write('<selection activeCell="' . self::xlsCell(
                0,
                    $sheet->freeze_columns
            ) . '" activeCellId="0" pane="topRight" sqref="' . self::xlsCell(
                        0,
                    $sheet->freeze_columns
                    ) . '"/>');
        } else { // not frozen
            $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>');
        $i = 0;
        if (!empty($col_widths)) {
            foreach ($col_widths as $column_width) {
                $sheet->file_writer->write('<col collapsed="false" hidden="false" max="' . ($i + 1) . '" min="' . ($i + 1) . '" style="0" customWidth="true" width="' . floatval($column_width) . '"/>');
                $i++;
            }
        }
        $sheet->file_writer->write('<col collapsed="false" hidden="false" max="1024" min="' . ($i + 1) . '" style="0" customWidth="false" width="11.5"/>');
        $sheet->file_writer->write('</cols>');
        $sheet->file_writer->write('<sheetData>');
    }