1 | <?php |
||
15 | class Writer |
||
16 | { |
||
17 | /** |
||
18 | * @var SheetFile |
||
19 | */ |
||
20 | private $sheetFile; |
||
21 | |||
22 | /** |
||
23 | * @var Styler |
||
24 | */ |
||
25 | private $styler; |
||
26 | |||
27 | /** |
||
28 | * @var Sheet |
||
29 | */ |
||
30 | private $sheet; |
||
31 | |||
32 | /** |
||
33 | * Writer constructor. |
||
34 | */ |
||
35 | 8 | public function __construct() |
|
39 | |||
40 | /** |
||
41 | * All cells _above_ this cell will be frozen/fixed. |
||
42 | * |
||
43 | * @param int $cellId |
||
44 | */ |
||
45 | 1 | public function setFreezePaneCellId($cellId) |
|
46 | { |
||
47 | 1 | $this->sheet->setFreezePaneCellId($cellId); |
|
48 | 1 | } |
|
49 | |||
50 | /** |
||
51 | * Set fixed column widths per cell (no ranges) and array index |
||
52 | * 0 being the first column. |
||
53 | * If used alongside cell autosizing, these should be set |
||
54 | * after the last row has been added. |
||
55 | * |
||
56 | * @param array $columnWidths |
||
57 | * @throws \InvalidArgumentException |
||
58 | */ |
||
59 | 1 | public function setFixedColumnWidths(array $columnWidths) |
|
63 | |||
64 | /** |
||
65 | * Set lower and/or upper limits for column widths. |
||
66 | * |
||
67 | * @param float|null $minWidth |
||
68 | * @param float|null $maxWidth |
||
69 | */ |
||
70 | 1 | public function setColumnWidthLimits($minWidth = null, $maxWidth = null) |
|
71 | { |
||
72 | 1 | $this->sheet->setColumnWidthLimits($minWidth, $maxWidth); |
|
73 | 1 | } |
|
74 | |||
75 | /** |
||
76 | * Start recording row specs for column autosizing. |
||
77 | * |
||
78 | * @return Writer |
||
79 | */ |
||
80 | 3 | public function enableCellAutosizing() |
|
85 | |||
86 | /** |
||
87 | * Stop recording row specs for column autosizing. |
||
88 | * |
||
89 | * @return Writer |
||
90 | */ |
||
91 | 1 | public function disableCellAutosizing() |
|
96 | |||
97 | /** |
||
98 | * Initialize writer defaults. |
||
99 | */ |
||
100 | 8 | private function initialize() |
|
107 | |||
108 | /** |
||
109 | * @param array $rows |
||
110 | * @param Style $style |
||
111 | * @throws \InvalidArgumentException |
||
112 | */ |
||
113 | 2 | public function addRows(array $rows, Style $style = null) |
|
123 | |||
124 | /** |
||
125 | * @param array $row |
||
126 | * @param Style $style |
||
127 | */ |
||
128 | 2 | public function addRow(array $row, Style $style = null) |
|
136 | |||
137 | /** |
||
138 | * Send xlsx to browser and unlink file. |
||
139 | * |
||
140 | * @param string $fileName |
||
141 | */ |
||
142 | 1 | public function writeToBrowser($fileName = 'report.xlsx') |
|
149 | |||
150 | /** |
||
151 | * Wrap things up and write xlsx. |
||
152 | * |
||
153 | * @param string $fileName |
||
154 | */ |
||
155 | 2 | public function writeToFile($fileName = 'report.xlsx') |
|
160 | |||
161 | /** |
||
162 | * Output headers & content and unlink the xlsx file eventually. |
||
163 | * |
||
164 | * @param string $fileName |
||
165 | */ |
||
166 | 1 | private function sendToBrowserAndUnlink($fileName) |
|
176 | } |
||
177 |