viliy / xlsx-writer

src/Writer/Builder.php

Spacing +32 added lines, -34 removed lines

@@ -165,15 +165,15 @@ 
             if (is_writable($filename)) {
                 @unlink($filename); //if the zip already exists, remove it
             } else {
-                throw new XlsxException('Error in '.__CLASS__.'::'.__FUNCTION__.', file is not writeable.');
+                throw new XlsxException('Error in ' . __CLASS__ . '::' . __FUNCTION__ . ', file is not writeable.');
             }
         }
         $zip = new \ZipArchive();
         if (empty($this->sheets)) {
-            throw new XlsxException('Error in '.__CLASS__.'::'.__FUNCTION__.', no worksheets defined.');
+            throw new XlsxException('Error in ' . __CLASS__ . '::' . __FUNCTION__ . ', no worksheets defined.');
         }
         if (!$zip->open($filename, \ZipArchive::CREATE)) {
-            throw new XlsxException('Error in '.__CLASS__.'::'.__FUNCTION__.', unable to create zip.');
+            throw new XlsxException('Error in ' . __CLASS__ . '::' . __FUNCTION__ . ', unable to create zip.');
         }
         $zip->addEmptyDir('docProps/');
         $zip->addFromString('docProps/app.xml', XlsxBuilder::buildAppXML($this->company));
@@ -188,10 +188,10 @@ 
         $zip->addFromString('_rels/.rels', XlsxBuilder::buildRelationshipsXML());
         $zip->addEmptyDir('xl/worksheets/');
         foreach ($this->sheets as $sheet) {
-            $zip->addFile($sheet->filename, 'xl/worksheets/'.$sheet->xmlname);
+            $zip->addFile($sheet->filename, 'xl/worksheets/' . $sheet->xmlname);
         }
         $zip->addFromString('xl/workbook.xml', XlsxBuilder::buildWorkbookXML($this->sheets));
-        $zip->addFile($this->writeStylesXML(), 'xl/styles.xml');  //$zip->addFromString("xl/styles.xml", self::buildStylesXML() );
+        $zip->addFile($this->writeStylesXML(), 'xl/styles.xml'); //$zip->addFromString("xl/styles.xml", self::buildStylesXML() );
         $zip->addFromString('[Content_Types].xml', XlsxBuilder::buildContentTypesXML($this->sheets));
         $zip->addEmptyDir('xl/_rels/');
         $zip->addFromString('xl/_rels/workbook.xml.rels', XlsxBuilder::buildWorkbookRelsXML($this->sheets));
@@ -213,22 +213,22 @@ 
         $sheet = $this->getSheet($sheetName);
         if (count($sheet->columns) < count($row)) {
             $defaultColumnTypes = $this->initColumnsTypes(array_fill($from = 0, count($row), 'GENERAL')); //will map to n_auto
-            $sheet->columns = array_merge((array) $sheet->columns, $defaultColumnTypes);
+            $sheet->columns = array_merge((array)$sheet->columns, $defaultColumnTypes);
         }
 
         if (!empty($rowOptions)) {
             $ht = isset($rowOptions['height']) ? floatval($rowOptions['height']) : 12.1;
             $customHt = isset($rowOptions['height']) ? true : false;
-            $hidden = isset($rowOptions['hidden']) ? (bool) ($rowOptions['hidden']) : false;
-            $collapsed = isset($rowOptions['collapsed']) ? (bool) ($rowOptions['collapsed']) : false;
+            $hidden = isset($rowOptions['hidden']) ? (bool)($rowOptions['hidden']) : false;
+            $collapsed = isset($rowOptions['collapsed']) ? (bool)($rowOptions['collapsed']) : false;
             $sheet->fileWriter->write(
-                '<row collapsed="'.($collapsed).'" customFormat="false" customHeight="'.($customHt).
-                '" hidden="'.($hidden).'" ht="'.($ht).'" outlineLevel="0" r="'.($sheet->rowCount + 1).'">'
+                '<row collapsed="' . ($collapsed) . '" customFormat="false" customHeight="' . ($customHt) .
+                '" hidden="' . ($hidden) . '" ht="' . ($ht) . '" outlineLevel="0" r="' . ($sheet->rowCount + 1) . '">'
             );
         } else {
             $sheet->fileWriter->write(
-                '<row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.1" outlineLevel="0" r="'.
-                ($sheet->rowCount + 1).'">'
+                '<row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.1" outlineLevel="0" r="' .
+                ($sheet->rowCount + 1) . '">'
             );
         }
 
@@ -237,8 +237,7 @@ 
         foreach ($row as $v) {
             $numberFormat = $sheet->columns[$c]['number_format'];
             $numberFormatType = $sheet->columns[$c]['number_format_type'];
-            $cellStyleIdx = empty($style) ? $sheet->columns[$c]['default_cell_style'] :
-                $this->addCellStyle($numberFormat, json_encode(isset($style[0]) ? $style[$c] : $style));
+            $cellStyleIdx = empty($style) ? $sheet->columns[$c]['default_cell_style'] : $this->addCellStyle($numberFormat, json_encode(isset($style[0]) ? $style[$c] : $style));
             $sheet->writeCell($sheet->rowCount, $c, $v, $numberFormatType, $cellStyleIdx);
             ++$c;
         }
@@ -274,14 +273,14 @@ 
 
         $temporaryFilename = $this->tempFilename();
         $file = new XlsxWriterBuffer($temporaryFilename);
-        $file->write('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'."\n");
+        $file->write('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>' . "\n");
         $file->write('<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">');
-        $file->write('<numFmts count="'.count($this->numberFormats).'">');
+        $file->write('<numFmts count="' . count($this->numberFormats) . '">');
         foreach ($this->numberFormats as $i => $v) {
-            $file->write('<numFmt numFmtId="'.(164 + $i).'" formatCode="'.Support::xmlSpecialChars($v).'" />');
+            $file->write('<numFmt numFmtId="' . (164 + $i) . '" formatCode="' . Support::xmlSpecialChars($v) . '" />');
         }
         $file->write('</numFmts>');
-        $file->write('<fonts count="'.(count($fonts)).'">');
+        $file->write('<fonts count="' . (count($fonts)) . '">');
         $file->write('<font><name val="Arial"/><charset val="1"/><family val="2"/><sz val="10"/></font>');
         $file->write('<font><name val="Arial"/><family val="0"/><sz val="10"/></font>');
         $file->write('<font><name val="Arial"/><family val="0"/><sz val="10"/></font>');
@@ -291,10 +290,10 @@ 
             if (!empty($font)) { //fonts have 4 empty placeholders in array to offset the 4 static xml entries above
                 $f = json_decode($font, true);
                 $file->write('<font>');
-                $file->write('<name val="'.htmlspecialchars($f['name']).'"/><charset val="1"/><family val="'.intval($f['family']).'"/>');
-                $file->write('<sz val="'.intval($f['size']).'"/>');
+                $file->write('<name val="' . htmlspecialchars($f['name']) . '"/><charset val="1"/><family val="' . intval($f['family']) . '"/>');
+                $file->write('<sz val="' . intval($f['size']) . '"/>');
                 if (!empty($f['color'])) {
-                    $file->write('<color rgb="'.strval($f['color']).'"/>');
+                    $file->write('<color rgb="' . strval($f['color']) . '"/>');
                 }
                 if (!empty($f['bold'])) {
                     $file->write('<b val="true"/>');
@@ -313,23 +312,23 @@ 
         }
         $file->write('</fonts>');
 
-        $file->write('<fills count="'.(count($fills)).'">');
+        $file->write('<fills count="' . (count($fills)) . '">');
         $file->write('<fill><patternFill patternType="none"/></fill>');
         $file->write('<fill><patternFill patternType="gray125"/></fill>');
         foreach ($fills as $fill) {
             if (!empty($fill)) { //fills have 2 empty placeholders in array to offset the 2 static xml entries above
-                $file->write('<fill><patternFill patternType="solid"><fgColor rgb="'.strval($fill).'"/><bgColor indexed="64"/></patternFill></fill>');
+                $file->write('<fill><patternFill patternType="solid"><fgColor rgb="' . strval($fill) . '"/><bgColor indexed="64"/></patternFill></fill>');
             }
         }
         $file->write('</fills>');
 
-        $file->write('<borders count="'.(count($borders)).'">');
+        $file->write('<borders count="' . (count($borders)) . '">');
         $file->write('<border diagonalDown="false" diagonalUp="false"><left/><right/><top/><bottom/><diagonal/></border>');
         foreach ($borders as $border) {
             if (!empty($border)) { //fonts have an empty placeholder in the array to offset the static xml entry above
                 $pieces = json_decode($border, true);
                 $border_style = !empty($pieces['style']) ? $pieces['style'] : 'hair';
-                $border_color = !empty($pieces['color']) ? '<color rgb="'.strval($pieces['color']).'"/>' : '';
+                $border_color = !empty($pieces['color']) ? '<color rgb="' . strval($pieces['color']) . '"/>' : '';
                 $file->write('<border diagonalDown="false" diagonalUp="false">');
                 foreach (['left', 'right', 'top', 'bottom'] as $side) {
                     $show_side = in_array($side, $pieces['side']) ? true : false;
@@ -367,7 +366,7 @@ 
         $file->write('<xf applyAlignment="false" applyBorder="false" applyFont="true" applyProtection="false" borderId="0" fillId="0" fontId="1" numFmtId="9"/>');
         $file->write('</cellStyleXfs>');
 
-        $file->write('<cellXfs count="'.(count($styleIndexes)).'">');
+        $file->write('<cellXfs count="' . (count($styleIndexes)) . '">');
         foreach ($styleIndexes as $v) {
             $applyAlignment = isset($v['alignment']) ? 'true' : 'false';
             $wrapText = !empty($v['wrap_text']) ? 'true' : 'false';
@@ -378,8 +377,8 @@ 
             $borderIdx = isset($v['border_idx']) ? intval($v['border_idx']) : 0;
             $fillIdx = isset($v['fill_idx']) ? intval($v['fill_idx']) : 0;
             $fontIdx = isset($v['font_idx']) ? intval($v['font_idx']) : 0;
-            $file->write('<xf applyAlignment="'.$applyAlignment.'" applyBorder="'.$applyBorder.'" applyFont="'.$applyFont.'" applyProtection="false" borderId="'.($borderIdx).'" fillId="'.($fillIdx).'" fontId="'.($fontIdx).'" numFmtId="'.(164 + $v['num_fmt_idx']).'" xfId="0">');
-            $file->write('	<alignment horizontal="'.$horizAlignment.'" vertical="'.$vertAlignment.'" textRotation="0" wrapText="'.$wrapText.'" indent="0" shrinkToFit="false"/>');
+            $file->write('<xf applyAlignment="' . $applyAlignment . '" applyBorder="' . $applyBorder . '" applyFont="' . $applyFont . '" applyProtection="false" borderId="' . ($borderIdx) . '" fillId="' . ($fillIdx) . '" fontId="' . ($fontIdx) . '" numFmtId="' . (164 + $v['num_fmt_idx']) . '" xfId="0">');
+            $file->write('	<alignment horizontal="' . $horizAlignment . '" vertical="' . $vertAlignment . '" textRotation="0" wrapText="' . $wrapText . '" indent="0" shrinkToFit="false"/>');
             $file->write('	<protection locked="true" hidden="false"/>');
             $file->write('</xf>');
         }
@@ -423,7 +422,7 @@ 
             return;
         }
         $style = $colOptions;
-        $colWidths = isset($colOptions['widths']) ? (array) $colOptions['widths'] : [];
+        $colWidths = isset($colOptions['widths']) ? (array)$colOptions['widths'] : [];
         $this->createSheet($sheetName, $colOptions);
         $sheet = $this->getSheet($sheetName);
         $sheet->initContent($colWidths, $this->isTabSelected());
@@ -432,12 +431,11 @@ 
             $headerRow = array_keys($headerTypes);
             $writer = $sheet->getFileWriter();
             $writer->write(
-                '<row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.1" outlineLevel="0" r="'. 1 .'">'
+                '<row collapsed="false" customFormat="false" customHeight="false" hidden="false" ht="12.1" outlineLevel="0" r="' . 1 . '">'
             );
             foreach ($headerRow as $c => $v) {
                 $cellStyleIdx = empty($style) ?
-                    $sheet->columns[$c]['default_cell_style'] :
-                    $this->addCellStyle('GENERAL', json_encode(isset($style[0]) ? $style[$c] : $style));
+                    $sheet->columns[$c]['default_cell_style'] : $this->addCellStyle('GENERAL', json_encode(isset($style[0]) ? $style[$c] : $style));
                 $sheet->writeCell(0, $c, $v, 'n_string', $cellStyleIdx);
             }
             $writer->write('</row>');
@@ -455,7 +453,7 @@ 
             $numberFormat = Support::numberFormatStandardized($numFormat);
             $cellStyleIdx = $this->addCellStyle($numberFormat, $styleString = null);
             $columns[] = [
-                'number_format' => $numberFormat,      //contains excel format like 'YYYY-MM-DD HH:MM:SS'
+                'number_format' => $numberFormat, //contains excel format like 'YYYY-MM-DD HH:MM:SS'
                 'number_format_type' => Support::determineNumberFormatType($numberFormat, 'function' === $v[0]), //contains friendly format like 'datetime'
                 'default_cell_style' => $cellStyleIdx,
             ];
@@ -511,7 +509,7 @@ 
     protected function createSheet(string $sheetName, array $colOptions = [])
     {
         $sheetFilename = $this->tempFilename();
-        $sheetXmlName = 'sheet'.(count($this->sheets) + 1).'.xml';
+        $sheetXmlName = 'sheet' . (count($this->sheets) + 1) . '.xml';
         $autoFilter = isset($colOptions['auto_filter']) ? intval($colOptions['auto_filter']) : false;
         $freezeRows = isset($colOptions['freeze_rows']) ? intval($colOptions['freeze_rows']) : false;
         $freezeColumns = isset($colOptions['freeze_columns']) ? intval($colOptions['freeze_columns']) : false;

src/Writer/Sheet.php

Spacing +42 added lines, -42 removed lines

@@ -64,39 +64,39 @@ 
         $file = $this->getFileWriter();
 
         if (!is_scalar($value) || '' === $value) { //objects, array, empty
-            $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'"/>');
+            $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '"/>');
         } elseif (is_string($value) && '=' == $value[0]) {
             // Support Formula
             if ('n_function' === $numFormatType) {
-                var_dump('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="s"><f>'.
+                var_dump('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="s"><f>' .
                     str_replace('{n}', $rowNumber + 1, substr($value, 1))
                     .'</f></c>');
 
-                $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="s"><f>'.
+                $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="s"><f>' .
                     str_replace('{n}', $rowNumber + 1, substr($value, 1))
                     .'</f></c>');
             } else {
-                $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="s"><f>'.Support::xmlSpecialChars($value).'</f></c>');
+                $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="s"><f>' . Support::xmlSpecialChars($value) . '</f></c>');
             }
         } else {
             switch ($numFormatType) {
                 case 'n_date':
-                    $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="n"><v>'.
-                        intval(Support::convertDateTime($value)).'</v></c>');
+                    $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="n"><v>' .
+                        intval(Support::convertDateTime($value)) . '</v></c>');
 
                     break;
                 case 'n_datetime':
-                    $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="n"><v>'.
-                        Support::convertDateTime($value).'</v></c>');
+                    $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="n"><v>' .
+                        Support::convertDateTime($value) . '</v></c>');
 
                     break;
                 case 'n_numeric':
-                    $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="n"><v>'.
-                        Support::xmlSpecialChars($value).'</v></c>'); //int,float,currency
+                    $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="n"><v>' .
+                        Support::xmlSpecialChars($value) . '</v></c>'); //int,float,currency
                     break;
                 case 'n_string':
-                    $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="inlineStr"><is><t>'.
-                        Support::xmlSpecialChars($value).'</t></is></c>');
+                    $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="inlineStr"><is><t>' .
+                        Support::xmlSpecialChars($value) . '</t></is></c>');
 
                     break;
                 case 'n_auto':
@@ -104,13 +104,13 @@ 
                     if (!is_string($value) || '0' == $value || ('0' != $value[0] && ctype_digit($value)) || preg_match("/^\-?(0|[1-9][0-9]*)(\.[0-9]+)?$/", $value)
                     ) { //int,float,currency
                         $file->write(
-                            '<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="n"><v>'.
-                            Support::xmlSpecialChars($value).'</v></c>'
+                            '<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="n"><v>' .
+                            Support::xmlSpecialChars($value) . '</v></c>'
                         );
                     } else { //implied: ($cell_format=='string')
                         $file->write(
-                            '<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="inlineStr"><is><t>'.
-                            Support::xmlSpecialChars($value).'</t></is></c>'
+                            '<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="inlineStr"><is><t>' .
+                            Support::xmlSpecialChars($value) . '</t></is></c>'
                         );
                     }
 
@@ -128,14 +128,14 @@ 
         $writer = $this->getFileWriter();
         $tabSelected = $isTabSelected ? 'true' : 'false';
         $maxCell = Support::xlsCell(Builder::EXCEL_2007_MAX_ROW, Builder::EXCEL_2007_MAX_COL); //XFE1048577
-        $writer->write('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'."\n");
+        $writer->write('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>' . "\n");
         $writer->write(
             <<<'EOF'
 <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><sheetPr filterMode="false"><pageSetUpPr fitToPage="false"/></sheetPr>
 EOF
         );
         $this->maxCellTagStart = $this->fileWriter->ftell();
-        $writer->write('<dimension ref="A1:'.$maxCell.'"/>');
+        $writer->write('<dimension ref="A1:' . $maxCell . '"/>');
         $this->maxCellTagEnd = $this->fileWriter->ftell();
         $writer->write('<sheetViews>');
         $writer->write(
@@ -157,15 +157,15 @@ 
         if (!empty($colWidths)) {
             foreach ($colWidths as $colWidth) {
                 $writer->write(
-                    '<col collapsed="false" hidden="false" max="'.($i + 1).'" min="'.($i + 1).
-                    '" style="0" customWidth="true" width="'.floatval($colWidth).'"/>'
+                    '<col collapsed="false" hidden="false" max="' . ($i + 1) . '" min="' . ($i + 1) .
+                    '" style="0" customWidth="true" width="' . floatval($colWidth) . '"/>'
                 );
                 ++$i;
             }
         }
         $writer->write(
-            '<col collapsed="false" hidden="false" max="1024" min="'.($i + 1).
-            '" style="0" customWidth="false" width="11.5"/>'.'</cols><sheetData>'
+            '<col collapsed="false" hidden="false" max="1024" min="' . ($i + 1) .
+            '" style="0" customWidth="false" width="11.5"/>' . '</cols><sheetData>'
         );
     }
 
@@ -176,7 +176,7 @@ 
         if (!empty($this->mergeCells)) {
             $this->fileWriter->write('<mergeCells>');
             foreach ($this->mergeCells as $range) {
-                $this->fileWriter->write('<mergeCell ref="'.$range.'"/>');
+                $this->fileWriter->write('<mergeCell ref="' . $range . '"/>');
             }
             $this->fileWriter->write('</mergeCells>');
         }
@@ -184,7 +184,7 @@ 
         $maxCell = Support::xlsCell($this->rowCount - 1, count($this->columns) - 1);
 
         if ($this->autoFilter) {
-            $this->fileWriter->write('<autoFilter ref="A1:'.$maxCell.'"/>');
+            $this->fileWriter->write('<autoFilter ref="A1:' . $maxCell . '"/>');
         }
 
         $this->fileWriter->write('<printOptions headings="false" gridLines="false" gridLinesSet="true" horizontalCentered="false" verticalCentered="false"/>');
@@ -196,10 +196,10 @@ 
         $this->fileWriter->write('</headerFooter>');
         $this->fileWriter->write('</worksheet>');
 
-        $maxCellTag = '<dimension ref="A1:'.$maxCell.'"/>';
+        $maxCellTag = '<dimension ref="A1:' . $maxCell . '"/>';
         $paddingLength = $this->maxCellTagEnd - $this->maxCellTagStart - strlen($maxCellTag);
         $this->fileWriter->fseek($this->maxCellTagStart);
-        $this->fileWriter->write($maxCellTag.str_repeat(' ', $paddingLength));
+        $this->fileWriter->write($maxCellTag . str_repeat(' ', $paddingLength));
         $this->fileWriter->close();
         $this->finalized = true;
     }
@@ -208,14 +208,14 @@ 
     {
         $writer = $this->getFileWriter();
         $writer->write(
-            '<pane ySplit="'.$this->freezeRows.'" xSplit="'.$this->freezeColumns.
-            '" topLeftCell="'.Support::xlsCell($this->freezeRows, $this->freezeColumns).
-            '" activePane="bottomRight" state="frozen"/>'.'<selection activeCell="'.Support::xlsCell($this->freezeRows, 0).
-            '" activeCellId="0" pane="topRight" sqref="'.Support::xlsCell($this->freezeRows, 0).'"/>'.
-            '<selection activeCell="'.Support::xlsCell(0, $this->freezeColumns).
-            '" activeCellId="0" pane="bottomLeft" sqref="'.Support::xlsCell(0, $this->freezeColumns).'"/>'.
-            '<selection activeCell="'.Support::xlsCell($this->freezeRows, $this->freezeColumns).
-            '" activeCellId="0" pane="bottomRight" sqref="'.Support::xlsCell($this->freezeRows, $this->freezeColumns).'"/>'
+            '<pane ySplit="' . $this->freezeRows . '" xSplit="' . $this->freezeColumns .
+            '" topLeftCell="' . Support::xlsCell($this->freezeRows, $this->freezeColumns) .
+            '" activePane="bottomRight" state="frozen"/>' . '<selection activeCell="' . Support::xlsCell($this->freezeRows, 0) .
+            '" activeCellId="0" pane="topRight" sqref="' . Support::xlsCell($this->freezeRows, 0) . '"/>' .
+            '<selection activeCell="' . Support::xlsCell(0, $this->freezeColumns) .
+            '" activeCellId="0" pane="bottomLeft" sqref="' . Support::xlsCell(0, $this->freezeColumns) . '"/>' .
+            '<selection activeCell="' . Support::xlsCell($this->freezeRows, $this->freezeColumns) .
+            '" activeCellId="0" pane="bottomRight" sqref="' . Support::xlsCell($this->freezeRows, $this->freezeColumns) . '"/>'
         );
     }
 
@@ -223,10 +223,10 @@ 
     {
         $writer = $this->getFileWriter();
         $writer->write(
-            '<pane ySplit="'.$this->freezeRows.'" topLeftCell="'.
-            Support::xlsCell($this->freezeRows, 0).'" activePane="bottomLeft" state="frozen"/>'.
-            '<selection activeCell="'.Support::xlsCell($this->freezeRows, 0).
-            '" activeCellId="0" pane="bottomLeft" sqref="'.Support::xlsCell($this->freezeRows, 0).'"/>'
+            '<pane ySplit="' . $this->freezeRows . '" topLeftCell="' .
+            Support::xlsCell($this->freezeRows, 0) . '" activePane="bottomLeft" state="frozen"/>' .
+            '<selection activeCell="' . Support::xlsCell($this->freezeRows, 0) .
+            '" activeCellId="0" pane="bottomLeft" sqref="' . Support::xlsCell($this->freezeRows, 0) . '"/>'
         );
     }
 
@@ -234,10 +234,10 @@ 
     {
         $writer = $this->getFileWriter();
         $writer->write(
-            '<pane xSplit="'.$this->freezeColumns.'" topLeftCell="'.
-            Support::xlsCell(0, $this->freezeColumns).'" activePane="topRight" state="frozen"/>'.
-            '<selection activeCell="'.Support::xlsCell(0, $this->freezeColumns).
-            '" activeCellId="0" pane="topRight" sqref="'.Support::xlsCell(0, $this->freezeColumns).'"/>'
+            '<pane xSplit="' . $this->freezeColumns . '" topLeftCell="' .
+            Support::xlsCell(0, $this->freezeColumns) . '" activePane="topRight" state="frozen"/>' .
+            '<selection activeCell="' . Support::xlsCell(0, $this->freezeColumns) .
+            '" activeCellId="0" pane="topRight" sqref="' . Support::xlsCell(0, $this->freezeColumns) . '"/>'
         );
     }