@@ -41,7 +41,7 @@ |
||
| 41 | 41 | $this->sheetData->fwrite('<?xml version="1.0" encoding="UTF-8" standalone="yes"?><worksheet xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">'); |
| 42 | 42 | |
| 43 | 43 | if (1 == preg_match('~[A-Z]+([1-9]?[0-9]+)$~', $freezePaneCellId, $match)) { |
| 44 | - $this->sheetData->fwrite('<sheetViews><sheetView tabSelected="1" workbookViewId="0" showGridLines="true" showRowColHeaders="1"><pane ySplit="' . (array_pop($match) - 1) . '" topLeftCell="' . $freezePaneCellId . '" activePane="bottomLeft" state="frozen"/></sheetView></sheetViews>'); |
|
| 44 | + $this->sheetData->fwrite('<sheetViews><sheetView tabSelected="1" workbookViewId="0" showGridLines="true" showRowColHeaders="1"><pane ySplit="' . (array_pop($match)-1) . '" topLeftCell="' . $freezePaneCellId . '" activePane="bottomLeft" state="frozen"/></sheetView></sheetViews>'); |
|
| 45 | 45 | } |
| 46 | 46 | |
| 47 | 47 | $this->sheetData->fwrite('<sheetData>'); |
@@ -51,7 +51,7 @@ |
||
| 51 | 51 | public function __construct(Sheet $sheet, $fileName = 'dummy.xlsx') |
| 52 | 52 | { |
| 53 | 53 | $this->zip = new \ZipArchive(); |
| 54 | - $this->zip->open($fileName, \ZipArchive::CREATE|\ZipArchive::CM_STORE); |
|
| 54 | + $this->zip->open($fileName, \ZipArchive::CREATE | \ZipArchive::CM_STORE); |
|
| 55 | 55 | $this->sheet = $sheet; |
| 56 | 56 | } |
| 57 | 57 | |
@@ -46,7 +46,7 @@ discard block |
||
| 46 | 46 | { |
| 47 | 47 | $this->characters = range('A', 'Z'); |
| 48 | 48 | |
| 49 | - foreach(range(chr(0), chr(31)) as $key => $char) { |
|
| 49 | + foreach (range(chr(0), chr(31)) as $key => $char) { |
|
| 50 | 50 | if (!in_array($char, array("\n", "\r", "\t"))) { |
| 51 | 51 | $this->controlCharacters[] = $char; |
| 52 | 52 | $this->escapeCharacters[] = sprintf('_x%04s_', strtoupper(dechex($key))); |
@@ -92,7 +92,7 @@ discard block |
||
| 92 | 92 | return $this->characters[$cellNumber] . $rowNumber; |
| 93 | 93 | } |
| 94 | 94 | |
| 95 | - return $this->getCellId(floor($cellNumber / 26) - 1) . $this->characters[$cellNumber % 26] . $rowNumber; |
|
| 95 | + return $this->getCellId(floor($cellNumber / 26)-1) . $this->characters[$cellNumber % 26] . $rowNumber; |
|
| 96 | 96 | } |
| 97 | 97 | |
| 98 | 98 | /** |