@@ -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 |
@@ -89,7 +89,7 @@ |
||
89 | 89 | return $this->characters[$cellNumber] . $rowNumber; |
90 | 90 | } |
91 | 91 | |
92 | - return $this->getCellId(floor($cellNumber / 26) - 1) . $this->characters[$cellNumber % 26] . $rowNumber; |
|
92 | + return $this->getCellId(floor($cellNumber / 26)-1) . $this->characters[$cellNumber % 26] . $rowNumber; |
|
93 | 93 | } |
94 | 94 | |
95 | 95 | /** |
@@ -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>'); |