@@ -46,28 +46,28 @@ discard block |
||
46 | 46 | * |
47 | 47 | * @var string |
48 | 48 | */ |
49 | - private $_delimiter = ','; |
|
49 | + private $_delimiter = ','; |
|
50 | 50 | |
51 | 51 | /** |
52 | 52 | * Enclosure |
53 | 53 | * |
54 | 54 | * @var string |
55 | 55 | */ |
56 | - private $_enclosure = '"'; |
|
56 | + private $_enclosure = '"'; |
|
57 | 57 | |
58 | 58 | /** |
59 | 59 | * Line ending |
60 | 60 | * |
61 | 61 | * @var string |
62 | 62 | */ |
63 | - private $_lineEnding = PHP_EOL; |
|
63 | + private $_lineEnding = PHP_EOL; |
|
64 | 64 | |
65 | 65 | /** |
66 | 66 | * Sheet index to write |
67 | 67 | * |
68 | 68 | * @var int |
69 | 69 | */ |
70 | - private $_sheetIndex = 0; |
|
70 | + private $_sheetIndex = 0; |
|
71 | 71 | |
72 | 72 | /** |
73 | 73 | * Pre-calculate formulas |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | * @param PHPExcel $phpExcel PHPExcel object |
90 | 90 | */ |
91 | 91 | public function __construct(PHPExcel $phpExcel) { |
92 | - $this->_phpExcel = $phpExcel; |
|
92 | + $this->_phpExcel = $phpExcel; |
|
93 | 93 | } |
94 | 94 | |
95 | 95 | /** |
@@ -123,9 +123,9 @@ discard block |
||
123 | 123 | $maxRow = $sheet->getHighestRow(); |
124 | 124 | |
125 | 125 | // Write rows to file |
126 | - for($row = 1; $row <= $maxRow; ++$row) { |
|
126 | + for ($row = 1; $row <= $maxRow; ++$row) { |
|
127 | 127 | // Convert the row to an array... |
128 | - $cellsArray = $sheet->rangeToArray('A'.$row.':'.$maxCol.$row,'', $this->_preCalculateFormulas); |
|
128 | + $cellsArray = $sheet->rangeToArray('A'.$row.':'.$maxCol.$row, '', $this->_preCalculateFormulas); |
|
129 | 129 | // ... and write to the file |
130 | 130 | $this->_writeLine($fileHandle, $cellsArray[0]); |
131 | 131 | } |
@@ -257,7 +257,7 @@ discard block |
||
257 | 257 | |
258 | 258 | foreach ($pValues as $element) { |
259 | 259 | // Escape enclosures |
260 | - $element = str_replace($this->_enclosure, $this->_enclosure . $this->_enclosure, $element); |
|
260 | + $element = str_replace($this->_enclosure, $this->_enclosure.$this->_enclosure, $element); |
|
261 | 261 | |
262 | 262 | // Add delimiter |
263 | 263 | if ($writeDelimiter) { |
@@ -267,7 +267,7 @@ discard block |
||
267 | 267 | } |
268 | 268 | |
269 | 269 | // Add enclosed string |
270 | - $line .= $this->_enclosure . $element . $this->_enclosure; |
|
270 | + $line .= $this->_enclosure.$element.$this->_enclosure; |
|
271 | 271 | } |
272 | 272 | |
273 | 273 | // Add line ending |
@@ -62,7 +62,7 @@ discard block |
||
62 | 62 | * |
63 | 63 | * @var PHPExcel_Writer_Excel2007_WriterPart[] |
64 | 64 | */ |
65 | - private $_writerParts = array(); |
|
65 | + private $_writerParts = array(); |
|
66 | 66 | |
67 | 67 | /** |
68 | 68 | * Private PHPExcel |
@@ -76,7 +76,7 @@ discard block |
||
76 | 76 | * |
77 | 77 | * @var string[] |
78 | 78 | */ |
79 | - private $_stringTable = array(); |
|
79 | + private $_stringTable = array(); |
|
80 | 80 | |
81 | 81 | /** |
82 | 82 | * Private unique PHPExcel_Style_Conditional HashTable |
@@ -104,7 +104,7 @@ discard block |
||
104 | 104 | * |
105 | 105 | * @var PHPExcel_HashTable |
106 | 106 | */ |
107 | - private $_bordersHashTable ; |
|
107 | + private $_bordersHashTable; |
|
108 | 108 | |
109 | 109 | /** |
110 | 110 | * Private unique PHPExcel_Style_NumberFormat HashTable |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | * |
133 | 133 | * @var string |
134 | 134 | */ |
135 | - private $_diskCachingDirectory = './'; |
|
135 | + private $_diskCachingDirectory = './'; |
|
136 | 136 | |
137 | 137 | /** |
138 | 138 | * Create a new PHPExcel_Writer_Excel2007 |
@@ -144,7 +144,7 @@ discard block |
||
144 | 144 | // Assign PHPExcel |
145 | 145 | $this->setPHPExcel($pPHPExcel); |
146 | 146 | |
147 | - $writerPartsArray = array( 'stringtable' => 'PHPExcel_Writer_Excel2007_StringTable', |
|
147 | + $writerPartsArray = array('stringtable' => 'PHPExcel_Writer_Excel2007_StringTable', |
|
148 | 148 | 'contenttypes' => 'PHPExcel_Writer_Excel2007_ContentTypes', |
149 | 149 | 'docprops' => 'PHPExcel_Writer_Excel2007_DocProps', |
150 | 150 | 'rels' => 'PHPExcel_Writer_Excel2007_Rels', |
@@ -163,13 +163,13 @@ discard block |
||
163 | 163 | $this->_writerParts[$writer] = new $class($this); |
164 | 164 | } |
165 | 165 | |
166 | - $hashTablesArray = array( '_stylesConditionalHashTable', '_fillHashTable', '_fontHashTable', |
|
167 | - '_bordersHashTable', '_numFmtHashTable', '_drawingHashTable' |
|
166 | + $hashTablesArray = array('_stylesConditionalHashTable', '_fillHashTable', '_fontHashTable', |
|
167 | + '_bordersHashTable', '_numFmtHashTable', '_drawingHashTable' |
|
168 | 168 | ); |
169 | 169 | |
170 | 170 | // Set HashTable variables |
171 | 171 | foreach ($hashTablesArray as $tableName) { |
172 | - $this->$tableName = new PHPExcel_HashTable(); |
|
172 | + $this->$tableName = new PHPExcel_HashTable(); |
|
173 | 173 | } |
174 | 174 | } |
175 | 175 | |
@@ -220,14 +220,14 @@ discard block |
||
220 | 220 | } |
221 | 221 | |
222 | 222 | // Create styles dictionaries |
223 | - $this->_stylesConditionalHashTable->addFromSource( $this->getWriterPart('Style')->allConditionalStyles($this->_spreadSheet) ); |
|
224 | - $this->_fillHashTable->addFromSource( $this->getWriterPart('Style')->allFills($this->_spreadSheet) ); |
|
225 | - $this->_fontHashTable->addFromSource( $this->getWriterPart('Style')->allFonts($this->_spreadSheet) ); |
|
226 | - $this->_bordersHashTable->addFromSource( $this->getWriterPart('Style')->allBorders($this->_spreadSheet) ); |
|
227 | - $this->_numFmtHashTable->addFromSource( $this->getWriterPart('Style')->allNumberFormats($this->_spreadSheet) ); |
|
223 | + $this->_stylesConditionalHashTable->addFromSource($this->getWriterPart('Style')->allConditionalStyles($this->_spreadSheet)); |
|
224 | + $this->_fillHashTable->addFromSource($this->getWriterPart('Style')->allFills($this->_spreadSheet)); |
|
225 | + $this->_fontHashTable->addFromSource($this->getWriterPart('Style')->allFonts($this->_spreadSheet)); |
|
226 | + $this->_bordersHashTable->addFromSource($this->getWriterPart('Style')->allBorders($this->_spreadSheet)); |
|
227 | + $this->_numFmtHashTable->addFromSource($this->getWriterPart('Style')->allNumberFormats($this->_spreadSheet)); |
|
228 | 228 | |
229 | 229 | // Create drawing dictionary |
230 | - $this->_drawingHashTable->addFromSource( $this->getWriterPart('Drawing')->allDrawings($this->_spreadSheet) ); |
|
230 | + $this->_drawingHashTable->addFromSource($this->getWriterPart('Drawing')->allDrawings($this->_spreadSheet)); |
|
231 | 231 | |
232 | 232 | // Create new ZIP file and open it for writing |
233 | 233 | $zipClass = PHPExcel_Settings::getZipClass(); |
@@ -245,46 +245,46 @@ discard block |
||
245 | 245 | // Try opening the ZIP file |
246 | 246 | if ($objZip->open($pFilename, $zipOverWrite) !== true) { |
247 | 247 | if ($objZip->open($pFilename, $zipCreate) !== true) { |
248 | - throw new Exception("Could not open " . $pFilename . " for writing."); |
|
248 | + throw new Exception("Could not open ".$pFilename." for writing."); |
|
249 | 249 | } |
250 | 250 | } |
251 | 251 | |
252 | 252 | // Add [Content_Types].xml to ZIP file |
253 | - $objZip->addFromString('[Content_Types].xml', $this->getWriterPart('ContentTypes')->writeContentTypes($this->_spreadSheet, $this->_includeCharts)); |
|
253 | + $objZip->addFromString('[Content_Types].xml', $this->getWriterPart('ContentTypes')->writeContentTypes($this->_spreadSheet, $this->_includeCharts)); |
|
254 | 254 | |
255 | 255 | // Add relationships to ZIP file |
256 | - $objZip->addFromString('_rels/.rels', $this->getWriterPart('Rels')->writeRelationships($this->_spreadSheet)); |
|
257 | - $objZip->addFromString('xl/_rels/workbook.xml.rels', $this->getWriterPart('Rels')->writeWorkbookRelationships($this->_spreadSheet)); |
|
256 | + $objZip->addFromString('_rels/.rels', $this->getWriterPart('Rels')->writeRelationships($this->_spreadSheet)); |
|
257 | + $objZip->addFromString('xl/_rels/workbook.xml.rels', $this->getWriterPart('Rels')->writeWorkbookRelationships($this->_spreadSheet)); |
|
258 | 258 | |
259 | 259 | // Add document properties to ZIP file |
260 | - $objZip->addFromString('docProps/app.xml', $this->getWriterPart('DocProps')->writeDocPropsApp($this->_spreadSheet)); |
|
261 | - $objZip->addFromString('docProps/core.xml', $this->getWriterPart('DocProps')->writeDocPropsCore($this->_spreadSheet)); |
|
260 | + $objZip->addFromString('docProps/app.xml', $this->getWriterPart('DocProps')->writeDocPropsApp($this->_spreadSheet)); |
|
261 | + $objZip->addFromString('docProps/core.xml', $this->getWriterPart('DocProps')->writeDocPropsCore($this->_spreadSheet)); |
|
262 | 262 | $customPropertiesPart = $this->getWriterPart('DocProps')->writeDocPropsCustom($this->_spreadSheet); |
263 | 263 | if ($customPropertiesPart !== NULL) { |
264 | - $objZip->addFromString('docProps/custom.xml', $customPropertiesPart); |
|
264 | + $objZip->addFromString('docProps/custom.xml', $customPropertiesPart); |
|
265 | 265 | } |
266 | 266 | |
267 | 267 | // Add theme to ZIP file |
268 | - $objZip->addFromString('xl/theme/theme1.xml', $this->getWriterPart('Theme')->writeTheme($this->_spreadSheet)); |
|
268 | + $objZip->addFromString('xl/theme/theme1.xml', $this->getWriterPart('Theme')->writeTheme($this->_spreadSheet)); |
|
269 | 269 | |
270 | 270 | // Add string table to ZIP file |
271 | - $objZip->addFromString('xl/sharedStrings.xml', $this->getWriterPart('StringTable')->writeStringTable($this->_stringTable)); |
|
271 | + $objZip->addFromString('xl/sharedStrings.xml', $this->getWriterPart('StringTable')->writeStringTable($this->_stringTable)); |
|
272 | 272 | |
273 | 273 | // Add styles to ZIP file |
274 | - $objZip->addFromString('xl/styles.xml', $this->getWriterPart('Style')->writeStyles($this->_spreadSheet)); |
|
274 | + $objZip->addFromString('xl/styles.xml', $this->getWriterPart('Style')->writeStyles($this->_spreadSheet)); |
|
275 | 275 | |
276 | 276 | // Add workbook to ZIP file |
277 | - $objZip->addFromString('xl/workbook.xml', $this->getWriterPart('Workbook')->writeWorkbook($this->_spreadSheet, $this->_preCalculateFormulas)); |
|
277 | + $objZip->addFromString('xl/workbook.xml', $this->getWriterPart('Workbook')->writeWorkbook($this->_spreadSheet, $this->_preCalculateFormulas)); |
|
278 | 278 | |
279 | 279 | $chartCount = 0; |
280 | 280 | // Add worksheets |
281 | 281 | for ($i = 0; $i < $this->_spreadSheet->getSheetCount(); ++$i) { |
282 | - $objZip->addFromString('xl/worksheets/sheet' . ($i + 1) . '.xml', $this->getWriterPart('Worksheet')->writeWorksheet($this->_spreadSheet->getSheet($i), $this->_stringTable, $this->_includeCharts)); |
|
282 | + $objZip->addFromString('xl/worksheets/sheet'.($i + 1).'.xml', $this->getWriterPart('Worksheet')->writeWorksheet($this->_spreadSheet->getSheet($i), $this->_stringTable, $this->_includeCharts)); |
|
283 | 283 | if ($this->_includeCharts) { |
284 | 284 | $charts = $this->_spreadSheet->getSheet($i)->getChartCollection(); |
285 | 285 | if (count($charts) > 0) { |
286 | - foreach($charts as $chart) { |
|
287 | - $objZip->addFromString('xl/charts/chart' . ($chartCount + 1) . '.xml', $this->getWriterPart('Chart')->writeChart($chart)); |
|
286 | + foreach ($charts as $chart) { |
|
287 | + $objZip->addFromString('xl/charts/chart'.($chartCount + 1).'.xml', $this->getWriterPart('Chart')->writeChart($chart)); |
|
288 | 288 | $chartCount++; |
289 | 289 | } |
290 | 290 | } |
@@ -296,7 +296,7 @@ discard block |
||
296 | 296 | for ($i = 0; $i < $this->_spreadSheet->getSheetCount(); ++$i) { |
297 | 297 | |
298 | 298 | // Add relationships |
299 | - $objZip->addFromString('xl/worksheets/_rels/sheet' . ($i + 1) . '.xml.rels', $this->getWriterPart('Rels')->writeWorksheetRelationships($this->_spreadSheet->getSheet($i), ($i + 1), $this->_includeCharts)); |
|
299 | + $objZip->addFromString('xl/worksheets/_rels/sheet'.($i + 1).'.xml.rels', $this->getWriterPart('Rels')->writeWorksheetRelationships($this->_spreadSheet->getSheet($i), ($i + 1), $this->_includeCharts)); |
|
300 | 300 | |
301 | 301 | $drawings = $this->_spreadSheet->getSheet($i)->getDrawingCollection(); |
302 | 302 | $drawingCount = count($drawings); |
@@ -307,32 +307,32 @@ discard block |
||
307 | 307 | // Add drawing and image relationship parts |
308 | 308 | if (($drawingCount > 0) || ($chartCount > 0)) { |
309 | 309 | // Drawing relationships |
310 | - $objZip->addFromString('xl/drawings/_rels/drawing' . ($i + 1) . '.xml.rels', $this->getWriterPart('Rels')->writeDrawingRelationships($this->_spreadSheet->getSheet($i),$chartRef1, $this->_includeCharts)); |
|
310 | + $objZip->addFromString('xl/drawings/_rels/drawing'.($i + 1).'.xml.rels', $this->getWriterPart('Rels')->writeDrawingRelationships($this->_spreadSheet->getSheet($i), $chartRef1, $this->_includeCharts)); |
|
311 | 311 | |
312 | 312 | // Drawings |
313 | - $objZip->addFromString('xl/drawings/drawing' . ($i + 1) . '.xml', $this->getWriterPart('Drawing')->writeDrawings($this->_spreadSheet->getSheet($i),$chartRef2,$this->_includeCharts)); |
|
313 | + $objZip->addFromString('xl/drawings/drawing'.($i + 1).'.xml', $this->getWriterPart('Drawing')->writeDrawings($this->_spreadSheet->getSheet($i), $chartRef2, $this->_includeCharts)); |
|
314 | 314 | } |
315 | 315 | |
316 | 316 | // Add comment relationship parts |
317 | 317 | if (count($this->_spreadSheet->getSheet($i)->getComments()) > 0) { |
318 | 318 | // VML Comments |
319 | - $objZip->addFromString('xl/drawings/vmlDrawing' . ($i + 1) . '.vml', $this->getWriterPart('Comments')->writeVMLComments($this->_spreadSheet->getSheet($i))); |
|
319 | + $objZip->addFromString('xl/drawings/vmlDrawing'.($i + 1).'.vml', $this->getWriterPart('Comments')->writeVMLComments($this->_spreadSheet->getSheet($i))); |
|
320 | 320 | |
321 | 321 | // Comments |
322 | - $objZip->addFromString('xl/comments' . ($i + 1) . '.xml', $this->getWriterPart('Comments')->writeComments($this->_spreadSheet->getSheet($i))); |
|
322 | + $objZip->addFromString('xl/comments'.($i + 1).'.xml', $this->getWriterPart('Comments')->writeComments($this->_spreadSheet->getSheet($i))); |
|
323 | 323 | } |
324 | 324 | |
325 | 325 | // Add header/footer relationship parts |
326 | 326 | if (count($this->_spreadSheet->getSheet($i)->getHeaderFooter()->getImages()) > 0) { |
327 | 327 | // VML Drawings |
328 | - $objZip->addFromString('xl/drawings/vmlDrawingHF' . ($i + 1) . '.vml', $this->getWriterPart('Drawing')->writeVMLHeaderFooterImages($this->_spreadSheet->getSheet($i))); |
|
328 | + $objZip->addFromString('xl/drawings/vmlDrawingHF'.($i + 1).'.vml', $this->getWriterPart('Drawing')->writeVMLHeaderFooterImages($this->_spreadSheet->getSheet($i))); |
|
329 | 329 | |
330 | 330 | // VML Drawing relationships |
331 | - $objZip->addFromString('xl/drawings/_rels/vmlDrawingHF' . ($i + 1) . '.vml.rels', $this->getWriterPart('Rels')->writeHeaderFooterDrawingRelationships($this->_spreadSheet->getSheet($i))); |
|
331 | + $objZip->addFromString('xl/drawings/_rels/vmlDrawingHF'.($i + 1).'.vml.rels', $this->getWriterPart('Rels')->writeHeaderFooterDrawingRelationships($this->_spreadSheet->getSheet($i))); |
|
332 | 332 | |
333 | 333 | // Media |
334 | 334 | foreach ($this->_spreadSheet->getSheet($i)->getHeaderFooter()->getImages() as $image) { |
335 | - $objZip->addFromString('xl/media/' . $image->getIndexedFilename(), file_get_contents($image->getPath())); |
|
335 | + $objZip->addFromString('xl/media/'.$image->getIndexedFilename(), file_get_contents($image->getPath())); |
|
336 | 336 | } |
337 | 337 | } |
338 | 338 | } |
@@ -356,7 +356,7 @@ discard block |
||
356 | 356 | $imageContents = file_get_contents($imagePath); |
357 | 357 | } |
358 | 358 | |
359 | - $objZip->addFromString('xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents); |
|
359 | + $objZip->addFromString('xl/media/'.str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents); |
|
360 | 360 | } else if ($this->getDrawingHashTable()->getByIndex($i) instanceof PHPExcel_Worksheet_MemoryDrawing) { |
361 | 361 | ob_start(); |
362 | 362 | call_user_func( |
@@ -366,7 +366,7 @@ discard block |
||
366 | 366 | $imageContents = ob_get_contents(); |
367 | 367 | ob_end_clean(); |
368 | 368 | |
369 | - $objZip->addFromString('xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents); |
|
369 | + $objZip->addFromString('xl/media/'.str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents); |
|
370 | 370 | } |
371 | 371 | } |
372 | 372 |
@@ -134,17 +134,17 @@ discard block |
||
134 | 134 | */ |
135 | 135 | private $_diskCachingDirectory = './'; |
136 | 136 | |
137 | - /** |
|
138 | - * Create a new PHPExcel_Writer_Excel2007 |
|
139 | - * |
|
137 | + /** |
|
138 | + * Create a new PHPExcel_Writer_Excel2007 |
|
139 | + * |
|
140 | 140 | * @param PHPExcel $pPHPExcel |
141 | - */ |
|
142 | - public function __construct(PHPExcel $pPHPExcel = null) |
|
143 | - { |
|
144 | - // Assign PHPExcel |
|
141 | + */ |
|
142 | + public function __construct(PHPExcel $pPHPExcel = null) |
|
143 | + { |
|
144 | + // Assign PHPExcel |
|
145 | 145 | $this->setPHPExcel($pPHPExcel); |
146 | 146 | |
147 | - $writerPartsArray = array( 'stringtable' => 'PHPExcel_Writer_Excel2007_StringTable', |
|
147 | + $writerPartsArray = array( 'stringtable' => 'PHPExcel_Writer_Excel2007_StringTable', |
|
148 | 148 | 'contenttypes' => 'PHPExcel_Writer_Excel2007_ContentTypes', |
149 | 149 | 'docprops' => 'PHPExcel_Writer_Excel2007_DocProps', |
150 | 150 | 'rels' => 'PHPExcel_Writer_Excel2007_Rels', |
@@ -157,21 +157,21 @@ discard block |
||
157 | 157 | 'chart' => 'PHPExcel_Writer_Excel2007_Chart', |
158 | 158 | ); |
159 | 159 | |
160 | - // Initialise writer parts |
|
160 | + // Initialise writer parts |
|
161 | 161 | // and Assign their parent IWriters |
162 | 162 | foreach ($writerPartsArray as $writer => $class) { |
163 | 163 | $this->_writerParts[$writer] = new $class($this); |
164 | 164 | } |
165 | 165 | |
166 | - $hashTablesArray = array( '_stylesConditionalHashTable', '_fillHashTable', '_fontHashTable', |
|
166 | + $hashTablesArray = array( '_stylesConditionalHashTable', '_fillHashTable', '_fontHashTable', |
|
167 | 167 | '_bordersHashTable', '_numFmtHashTable', '_drawingHashTable' |
168 | - ); |
|
168 | + ); |
|
169 | 169 | |
170 | 170 | // Set HashTable variables |
171 | 171 | foreach ($hashTablesArray as $tableName) { |
172 | 172 | $this->$tableName = new PHPExcel_HashTable(); |
173 | 173 | } |
174 | - } |
|
174 | + } |
|
175 | 175 | |
176 | 176 | /** |
177 | 177 | * Get writer part |
@@ -416,68 +416,68 @@ discard block |
||
416 | 416 | return $this; |
417 | 417 | } |
418 | 418 | |
419 | - /** |
|
420 | - * Get string table |
|
421 | - * |
|
422 | - * @return string[] |
|
423 | - */ |
|
424 | - public function getStringTable() { |
|
425 | - return $this->_stringTable; |
|
426 | - } |
|
427 | - |
|
428 | - /** |
|
429 | - * Get PHPExcel_Style_Conditional HashTable |
|
430 | - * |
|
431 | - * @return PHPExcel_HashTable |
|
432 | - */ |
|
433 | - public function getStylesConditionalHashTable() { |
|
434 | - return $this->_stylesConditionalHashTable; |
|
435 | - } |
|
436 | - |
|
437 | - /** |
|
438 | - * Get PHPExcel_Style_Fill HashTable |
|
439 | - * |
|
440 | - * @return PHPExcel_HashTable |
|
441 | - */ |
|
442 | - public function getFillHashTable() { |
|
443 | - return $this->_fillHashTable; |
|
444 | - } |
|
445 | - |
|
446 | - /** |
|
447 | - * Get PHPExcel_Style_Font HashTable |
|
448 | - * |
|
449 | - * @return PHPExcel_HashTable |
|
450 | - */ |
|
451 | - public function getFontHashTable() { |
|
452 | - return $this->_fontHashTable; |
|
453 | - } |
|
454 | - |
|
455 | - /** |
|
456 | - * Get PHPExcel_Style_Borders HashTable |
|
457 | - * |
|
458 | - * @return PHPExcel_HashTable |
|
459 | - */ |
|
460 | - public function getBordersHashTable() { |
|
461 | - return $this->_bordersHashTable; |
|
462 | - } |
|
463 | - |
|
464 | - /** |
|
465 | - * Get PHPExcel_Style_NumberFormat HashTable |
|
466 | - * |
|
467 | - * @return PHPExcel_HashTable |
|
468 | - */ |
|
469 | - public function getNumFmtHashTable() { |
|
470 | - return $this->_numFmtHashTable; |
|
471 | - } |
|
472 | - |
|
473 | - /** |
|
474 | - * Get PHPExcel_Worksheet_BaseDrawing HashTable |
|
475 | - * |
|
476 | - * @return PHPExcel_HashTable |
|
477 | - */ |
|
478 | - public function getDrawingHashTable() { |
|
479 | - return $this->_drawingHashTable; |
|
480 | - } |
|
419 | + /** |
|
420 | + * Get string table |
|
421 | + * |
|
422 | + * @return string[] |
|
423 | + */ |
|
424 | + public function getStringTable() { |
|
425 | + return $this->_stringTable; |
|
426 | + } |
|
427 | + |
|
428 | + /** |
|
429 | + * Get PHPExcel_Style_Conditional HashTable |
|
430 | + * |
|
431 | + * @return PHPExcel_HashTable |
|
432 | + */ |
|
433 | + public function getStylesConditionalHashTable() { |
|
434 | + return $this->_stylesConditionalHashTable; |
|
435 | + } |
|
436 | + |
|
437 | + /** |
|
438 | + * Get PHPExcel_Style_Fill HashTable |
|
439 | + * |
|
440 | + * @return PHPExcel_HashTable |
|
441 | + */ |
|
442 | + public function getFillHashTable() { |
|
443 | + return $this->_fillHashTable; |
|
444 | + } |
|
445 | + |
|
446 | + /** |
|
447 | + * Get PHPExcel_Style_Font HashTable |
|
448 | + * |
|
449 | + * @return PHPExcel_HashTable |
|
450 | + */ |
|
451 | + public function getFontHashTable() { |
|
452 | + return $this->_fontHashTable; |
|
453 | + } |
|
454 | + |
|
455 | + /** |
|
456 | + * Get PHPExcel_Style_Borders HashTable |
|
457 | + * |
|
458 | + * @return PHPExcel_HashTable |
|
459 | + */ |
|
460 | + public function getBordersHashTable() { |
|
461 | + return $this->_bordersHashTable; |
|
462 | + } |
|
463 | + |
|
464 | + /** |
|
465 | + * Get PHPExcel_Style_NumberFormat HashTable |
|
466 | + * |
|
467 | + * @return PHPExcel_HashTable |
|
468 | + */ |
|
469 | + public function getNumFmtHashTable() { |
|
470 | + return $this->_numFmtHashTable; |
|
471 | + } |
|
472 | + |
|
473 | + /** |
|
474 | + * Get PHPExcel_Worksheet_BaseDrawing HashTable |
|
475 | + * |
|
476 | + * @return PHPExcel_HashTable |
|
477 | + */ |
|
478 | + public function getDrawingHashTable() { |
|
479 | + return $this->_drawingHashTable; |
|
480 | + } |
|
481 | 481 | |
482 | 482 | /** |
483 | 483 | * Write charts in workbook? |
@@ -504,43 +504,43 @@ discard block |
||
504 | 504 | return $this; |
505 | 505 | } |
506 | 506 | |
507 | - /** |
|
508 | - * Get Pre-Calculate Formulas |
|
509 | - * |
|
510 | - * @return boolean |
|
511 | - */ |
|
512 | - public function getPreCalculateFormulas() { |
|
513 | - return $this->_preCalculateFormulas; |
|
514 | - } |
|
515 | - |
|
516 | - /** |
|
517 | - * Set Pre-Calculate Formulas |
|
518 | - * |
|
519 | - * @param boolean $pValue Pre-Calculate Formulas? |
|
520 | - */ |
|
521 | - public function setPreCalculateFormulas($pValue = true) { |
|
522 | - $this->_preCalculateFormulas = $pValue; |
|
523 | - } |
|
524 | - |
|
525 | - /** |
|
526 | - * Get Office2003 compatibility |
|
527 | - * |
|
528 | - * @return boolean |
|
529 | - */ |
|
530 | - public function getOffice2003Compatibility() { |
|
531 | - return $this->_office2003compatibility; |
|
532 | - } |
|
533 | - |
|
534 | - /** |
|
535 | - * Set Pre-Calculate Formulas |
|
536 | - * |
|
537 | - * @param boolean $pValue Office2003 compatibility? |
|
538 | - * @return PHPExcel_Writer_Excel2007 |
|
539 | - */ |
|
540 | - public function setOffice2003Compatibility($pValue = false) { |
|
541 | - $this->_office2003compatibility = $pValue; |
|
542 | - return $this; |
|
543 | - } |
|
507 | + /** |
|
508 | + * Get Pre-Calculate Formulas |
|
509 | + * |
|
510 | + * @return boolean |
|
511 | + */ |
|
512 | + public function getPreCalculateFormulas() { |
|
513 | + return $this->_preCalculateFormulas; |
|
514 | + } |
|
515 | + |
|
516 | + /** |
|
517 | + * Set Pre-Calculate Formulas |
|
518 | + * |
|
519 | + * @param boolean $pValue Pre-Calculate Formulas? |
|
520 | + */ |
|
521 | + public function setPreCalculateFormulas($pValue = true) { |
|
522 | + $this->_preCalculateFormulas = $pValue; |
|
523 | + } |
|
524 | + |
|
525 | + /** |
|
526 | + * Get Office2003 compatibility |
|
527 | + * |
|
528 | + * @return boolean |
|
529 | + */ |
|
530 | + public function getOffice2003Compatibility() { |
|
531 | + return $this->_office2003compatibility; |
|
532 | + } |
|
533 | + |
|
534 | + /** |
|
535 | + * Set Pre-Calculate Formulas |
|
536 | + * |
|
537 | + * @param boolean $pValue Office2003 compatibility? |
|
538 | + * @return PHPExcel_Writer_Excel2007 |
|
539 | + */ |
|
540 | + public function setOffice2003Compatibility($pValue = false) { |
|
541 | + $this->_office2003compatibility = $pValue; |
|
542 | + return $this; |
|
543 | + } |
|
544 | 544 | |
545 | 545 | /** |
546 | 546 | * Get use disk caching where possible? |
@@ -563,11 +563,11 @@ discard block |
||
563 | 563 | $this->_useDiskCaching = $pValue; |
564 | 564 | |
565 | 565 | if ($pDirectory !== NULL) { |
566 | - if (is_dir($pDirectory)) { |
|
567 | - $this->_diskCachingDirectory = $pDirectory; |
|
568 | - } else { |
|
569 | - throw new Exception("Directory does not exist: $pDirectory"); |
|
570 | - } |
|
566 | + if (is_dir($pDirectory)) { |
|
567 | + $this->_diskCachingDirectory = $pDirectory; |
|
568 | + } else { |
|
569 | + throw new Exception("Directory does not exist: $pDirectory"); |
|
570 | + } |
|
571 | 571 | } |
572 | 572 | return $this; |
573 | 573 | } |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | $pChart->refresh(); |
56 | 56 | |
57 | 57 | // XML header |
58 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
58 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
59 | 59 | |
60 | 60 | // c:chartSpace |
61 | 61 | $objWriter->startElement('c:chartSpace'); |
@@ -232,11 +232,11 @@ discard block |
||
232 | 232 | $chartTypes = self::_getChartType($plotArea); |
233 | 233 | $catIsMultiLevelSeries = $valIsMultiLevelSeries = FALSE; |
234 | 234 | $plotGroupingType = ''; |
235 | - foreach($chartTypes as $chartType) { |
|
235 | + foreach ($chartTypes as $chartType) { |
|
236 | 236 | $objWriter->startElement('c:'.$chartType); |
237 | 237 | |
238 | 238 | $groupCount = $plotArea->getPlotGroupCount(); |
239 | - for($i = 0; $i < $groupCount; ++$i) { |
|
239 | + for ($i = 0; $i < $groupCount; ++$i) { |
|
240 | 240 | $plotGroup = $plotArea->getPlotGroupByIndex($i); |
241 | 241 | $groupType = $plotGroup->getPlotType(); |
242 | 242 | if ($groupType == $chartType) { |
@@ -244,11 +244,11 @@ discard block |
||
244 | 244 | $plotStyle = $plotGroup->getPlotStyle(); |
245 | 245 | if ($groupType === PHPExcel_Chart_DataSeries::TYPE_RADARCHART) { |
246 | 246 | $objWriter->startElement('c:radarStyle'); |
247 | - $objWriter->writeAttribute('val', $plotStyle ); |
|
247 | + $objWriter->writeAttribute('val', $plotStyle); |
|
248 | 248 | $objWriter->endElement(); |
249 | 249 | } elseif ($groupType === PHPExcel_Chart_DataSeries::TYPE_SCATTERCHART) { |
250 | 250 | $objWriter->startElement('c:scatterStyle'); |
251 | - $objWriter->writeAttribute('val', $plotStyle ); |
|
251 | + $objWriter->writeAttribute('val', $plotStyle); |
|
252 | 252 | $objWriter->endElement(); |
253 | 253 | } |
254 | 254 | |
@@ -262,30 +262,30 @@ discard block |
||
262 | 262 | // Line only, Line3D can't be smoothed |
263 | 263 | |
264 | 264 | $objWriter->startElement('c:smooth'); |
265 | - $objWriter->writeAttribute('val', (integer) $plotGroup->getSmoothLine() ); |
|
265 | + $objWriter->writeAttribute('val', (integer) $plotGroup->getSmoothLine()); |
|
266 | 266 | $objWriter->endElement(); |
267 | 267 | } elseif (($chartType === PHPExcel_Chart_DataSeries::TYPE_BARCHART) || |
268 | 268 | ($chartType === PHPExcel_Chart_DataSeries::TYPE_BARCHART_3D)) { |
269 | 269 | |
270 | 270 | $objWriter->startElement('c:gapWidth'); |
271 | - $objWriter->writeAttribute('val', 150 ); |
|
271 | + $objWriter->writeAttribute('val', 150); |
|
272 | 272 | $objWriter->endElement(); |
273 | 273 | |
274 | 274 | if ($plotGroupingType == 'percentStacked' || |
275 | 275 | $plotGroupingType == 'stacked') { |
276 | 276 | |
277 | 277 | $objWriter->startElement('c:overlap'); |
278 | - $objWriter->writeAttribute('val', 100 ); |
|
278 | + $objWriter->writeAttribute('val', 100); |
|
279 | 279 | $objWriter->endElement(); |
280 | 280 | } |
281 | 281 | } elseif ($chartType === PHPExcel_Chart_DataSeries::TYPE_BUBBLECHART) { |
282 | 282 | |
283 | 283 | $objWriter->startElement('c:bubbleScale'); |
284 | - $objWriter->writeAttribute('val', 25 ); |
|
284 | + $objWriter->writeAttribute('val', 25); |
|
285 | 285 | $objWriter->endElement(); |
286 | 286 | |
287 | 287 | $objWriter->startElement('c:showNegBubbles'); |
288 | - $objWriter->writeAttribute('val', 0 ); |
|
288 | + $objWriter->writeAttribute('val', 0); |
|
289 | 289 | $objWriter->endElement(); |
290 | 290 | } elseif ($chartType === PHPExcel_Chart_DataSeries::TYPE_STOCKCHART) { |
291 | 291 | |
@@ -306,10 +306,10 @@ discard block |
||
306 | 306 | ($chartType !== PHPExcel_Chart_DataSeries::TYPE_DONUTCHART)) { |
307 | 307 | |
308 | 308 | $objWriter->startElement('c:axId'); |
309 | - $objWriter->writeAttribute('val', $id1 ); |
|
309 | + $objWriter->writeAttribute('val', $id1); |
|
310 | 310 | $objWriter->endElement(); |
311 | 311 | $objWriter->startElement('c:axId'); |
312 | - $objWriter->writeAttribute('val', $id2 ); |
|
312 | + $objWriter->writeAttribute('val', $id2); |
|
313 | 313 | $objWriter->endElement(); |
314 | 314 | } else { |
315 | 315 | $objWriter->startElement('c:firstSliceAng'); |
@@ -332,12 +332,12 @@ discard block |
||
332 | 332 | ($chartType !== PHPExcel_Chart_DataSeries::TYPE_DONUTCHART)) { |
333 | 333 | |
334 | 334 | if ($chartType === PHPExcel_Chart_DataSeries::TYPE_BUBBLECHART) { |
335 | - $this->_writeValAx($objWriter,$plotArea,$xAxisLabel,$chartType,$id1,$id2,$catIsMultiLevelSeries); |
|
335 | + $this->_writeValAx($objWriter, $plotArea, $xAxisLabel, $chartType, $id1, $id2, $catIsMultiLevelSeries); |
|
336 | 336 | } else { |
337 | - $this->_writeCatAx($objWriter,$plotArea,$xAxisLabel,$chartType,$id1,$id2,$catIsMultiLevelSeries); |
|
337 | + $this->_writeCatAx($objWriter, $plotArea, $xAxisLabel, $chartType, $id1, $id2, $catIsMultiLevelSeries); |
|
338 | 338 | } |
339 | 339 | |
340 | - $this->_writeValAx($objWriter,$plotArea,$yAxisLabel,$chartType,$id1,$id2,$valIsMultiLevelSeries); |
|
340 | + $this->_writeValAx($objWriter, $plotArea, $yAxisLabel, $chartType, $id1, $id2, $valIsMultiLevelSeries); |
|
341 | 341 | } |
342 | 342 | |
343 | 343 | $objWriter->endElement(); |
@@ -420,7 +420,7 @@ discard block |
||
420 | 420 | $objWriter->writeAttribute('val', "b"); |
421 | 421 | $objWriter->endElement(); |
422 | 422 | |
423 | - if (!is_null($xAxisLabel)) { |
|
423 | + if ( ! is_null($xAxisLabel)) { |
|
424 | 424 | $objWriter->startElement('c:title'); |
425 | 425 | $objWriter->startElement('c:tx'); |
426 | 426 | $objWriter->startElement('c:rich'); |
@@ -439,7 +439,7 @@ discard block |
||
439 | 439 | $caption = $caption[0]; |
440 | 440 | $objWriter->startElement('a:t'); |
441 | 441 | $objWriter->writeAttribute('xml:space', 'preserve'); |
442 | - $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $caption )); |
|
442 | + $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($caption)); |
|
443 | 443 | $objWriter->endElement(); |
444 | 444 | |
445 | 445 | $objWriter->endElement(); |
@@ -546,7 +546,7 @@ discard block |
||
546 | 546 | $objWriter->startElement('c:majorGridlines'); |
547 | 547 | $objWriter->endElement(); |
548 | 548 | |
549 | - if (!is_null($yAxisLabel)) { |
|
549 | + if ( ! is_null($yAxisLabel)) { |
|
550 | 550 | $objWriter->startElement('c:title'); |
551 | 551 | $objWriter->startElement('c:tx'); |
552 | 552 | $objWriter->startElement('c:rich'); |
@@ -565,7 +565,7 @@ discard block |
||
565 | 565 | $caption = $caption[0]; |
566 | 566 | $objWriter->startElement('a:t'); |
567 | 567 | $objWriter->writeAttribute('xml:space', 'preserve'); |
568 | - $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $caption )); |
|
568 | + $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($caption)); |
|
569 | 569 | $objWriter->endElement(); |
570 | 570 | |
571 | 571 | $objWriter->endElement(); |
@@ -643,7 +643,7 @@ discard block |
||
643 | 643 | $chartType = array($plotArea->getPlotGroupByIndex(0)->getPlotType()); |
644 | 644 | } else { |
645 | 645 | $chartTypes = array(); |
646 | - for($i = 0; $i < $groupCount; ++$i) { |
|
646 | + for ($i = 0; $i < $groupCount; ++$i) { |
|
647 | 647 | $chartTypes[] = $plotArea->getPlotGroupByIndex($i)->getPlotType(); |
648 | 648 | } |
649 | 649 | $chartType = array_unique($chartTypes); |
@@ -679,7 +679,7 @@ discard block |
||
679 | 679 | $objWriter->endElement(); |
680 | 680 | } |
681 | 681 | |
682 | - if (!is_null($plotGroup->getPlotGrouping())) { |
|
682 | + if ( ! is_null($plotGroup->getPlotGrouping())) { |
|
683 | 683 | $plotGroupingType = $plotGroup->getPlotGrouping(); |
684 | 684 | $objWriter->startElement('c:grouping'); |
685 | 685 | $objWriter->writeAttribute('val', $plotGroupingType); |
@@ -709,7 +709,7 @@ discard block |
||
709 | 709 | } |
710 | 710 | } |
711 | 711 | |
712 | - foreach($plotSeriesOrder as $plotSeriesIdx => $plotSeriesRef) { |
|
712 | + foreach ($plotSeriesOrder as $plotSeriesIdx => $plotSeriesRef) { |
|
713 | 713 | $objWriter->startElement('c:ser'); |
714 | 714 | |
715 | 715 | $objWriter->startElement('c:idx'); |
@@ -798,7 +798,7 @@ discard block |
||
798 | 798 | ($groupType == PHPExcel_Chart_DataSeries::TYPE_PIECHART_3D) || |
799 | 799 | ($groupType == PHPExcel_Chart_DataSeries::TYPE_DONUTCHART)) { |
800 | 800 | |
801 | - if (!is_null($plotGroup->getPlotStyle())) { |
|
801 | + if ( ! is_null($plotGroup->getPlotStyle())) { |
|
802 | 802 | $plotStyle = $plotGroup->getPlotStyle(); |
803 | 803 | if ($plotStyle) { |
804 | 804 | $objWriter->startElement('c:explosion'); |
@@ -862,15 +862,15 @@ discard block |
||
862 | 862 | |
863 | 863 | $objWriter->startElement('c:strCache'); |
864 | 864 | $objWriter->startElement('c:ptCount'); |
865 | - $objWriter->writeAttribute('val', $plotSeriesLabel->getPointCount() ); |
|
865 | + $objWriter->writeAttribute('val', $plotSeriesLabel->getPointCount()); |
|
866 | 866 | $objWriter->endElement(); |
867 | 867 | |
868 | - foreach($plotSeriesLabel->getDataValues() as $plotLabelKey => $plotLabelValue) { |
|
868 | + foreach ($plotSeriesLabel->getDataValues() as $plotLabelKey => $plotLabelValue) { |
|
869 | 869 | $objWriter->startElement('c:pt'); |
870 | - $objWriter->writeAttribute('idx', $plotLabelKey ); |
|
870 | + $objWriter->writeAttribute('idx', $plotLabelKey); |
|
871 | 871 | |
872 | 872 | $objWriter->startElement('c:v'); |
873 | - $objWriter->writeRawData( $plotLabelValue ); |
|
873 | + $objWriter->writeRawData($plotLabelValue); |
|
874 | 874 | $objWriter->endElement(); |
875 | 875 | $objWriter->endElement(); |
876 | 876 | } |
@@ -887,7 +887,7 @@ discard block |
||
887 | 887 | * @param string $dataType Datatype of series values |
888 | 888 | * @throws Exception |
889 | 889 | */ |
890 | - private function _writePlotSeriesValues($plotSeriesValues, $objWriter, $groupType, $dataType='str') |
|
890 | + private function _writePlotSeriesValues($plotSeriesValues, $objWriter, $groupType, $dataType = 'str') |
|
891 | 891 | { |
892 | 892 | if (is_null($plotSeriesValues)) { |
893 | 893 | return; |
@@ -899,25 +899,25 @@ discard block |
||
899 | 899 | $objWriter->startElement('c:multiLvlStrRef'); |
900 | 900 | |
901 | 901 | $objWriter->startElement('c:f'); |
902 | - $objWriter->writeRawData( $plotSeriesValues->getDataSource() ); |
|
902 | + $objWriter->writeRawData($plotSeriesValues->getDataSource()); |
|
903 | 903 | $objWriter->endElement(); |
904 | 904 | |
905 | 905 | $objWriter->startElement('c:multiLvlStrCache'); |
906 | 906 | |
907 | 907 | $objWriter->startElement('c:ptCount'); |
908 | - $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount() ); |
|
908 | + $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount()); |
|
909 | 909 | $objWriter->endElement(); |
910 | 910 | |
911 | 911 | for ($level = 0; $level < $levelCount; ++$level) { |
912 | 912 | $objWriter->startElement('c:lvl'); |
913 | 913 | |
914 | - foreach($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
914 | + foreach ($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
915 | 915 | if (isset($plotSeriesValue[$level])) { |
916 | 916 | $objWriter->startElement('c:pt'); |
917 | - $objWriter->writeAttribute('idx', $plotSeriesKey ); |
|
917 | + $objWriter->writeAttribute('idx', $plotSeriesKey); |
|
918 | 918 | |
919 | 919 | $objWriter->startElement('c:v'); |
920 | - $objWriter->writeRawData( $plotSeriesValue[$level] ); |
|
920 | + $objWriter->writeRawData($plotSeriesValue[$level]); |
|
921 | 921 | $objWriter->endElement(); |
922 | 922 | $objWriter->endElement(); |
923 | 923 | } |
@@ -933,7 +933,7 @@ discard block |
||
933 | 933 | $objWriter->startElement('c:'.$dataType.'Ref'); |
934 | 934 | |
935 | 935 | $objWriter->startElement('c:f'); |
936 | - $objWriter->writeRawData( $plotSeriesValues->getDataSource() ); |
|
936 | + $objWriter->writeRawData($plotSeriesValues->getDataSource()); |
|
937 | 937 | $objWriter->endElement(); |
938 | 938 | |
939 | 939 | $objWriter->startElement('c:'.$dataType.'Cache'); |
@@ -944,21 +944,21 @@ discard block |
||
944 | 944 | |
945 | 945 | if ($plotSeriesValues->getFormatCode() !== NULL) { |
946 | 946 | $objWriter->startElement('c:formatCode'); |
947 | - $objWriter->writeRawData( $plotSeriesValues->getFormatCode() ); |
|
947 | + $objWriter->writeRawData($plotSeriesValues->getFormatCode()); |
|
948 | 948 | $objWriter->endElement(); |
949 | 949 | } |
950 | 950 | } |
951 | 951 | |
952 | 952 | $objWriter->startElement('c:ptCount'); |
953 | - $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount() ); |
|
953 | + $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount()); |
|
954 | 954 | $objWriter->endElement(); |
955 | 955 | |
956 | - foreach($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
956 | + foreach ($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
957 | 957 | $objWriter->startElement('c:pt'); |
958 | - $objWriter->writeAttribute('idx', $plotSeriesKey ); |
|
958 | + $objWriter->writeAttribute('idx', $plotSeriesKey); |
|
959 | 959 | |
960 | 960 | $objWriter->startElement('c:v'); |
961 | - $objWriter->writeRawData( $plotSeriesValue ); |
|
961 | + $objWriter->writeRawData($plotSeriesValue); |
|
962 | 962 | $objWriter->endElement(); |
963 | 963 | $objWriter->endElement(); |
964 | 964 | } |
@@ -986,18 +986,18 @@ discard block |
||
986 | 986 | $objWriter->startElement('c:numLit'); |
987 | 987 | |
988 | 988 | $objWriter->startElement('c:formatCode'); |
989 | - $objWriter->writeRawData( 'General' ); |
|
989 | + $objWriter->writeRawData('General'); |
|
990 | 990 | $objWriter->endElement(); |
991 | 991 | |
992 | 992 | $objWriter->startElement('c:ptCount'); |
993 | - $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount() ); |
|
993 | + $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount()); |
|
994 | 994 | $objWriter->endElement(); |
995 | 995 | |
996 | - foreach($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
996 | + foreach ($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
997 | 997 | $objWriter->startElement('c:pt'); |
998 | - $objWriter->writeAttribute('idx', $plotSeriesKey ); |
|
998 | + $objWriter->writeAttribute('idx', $plotSeriesKey); |
|
999 | 999 | $objWriter->startElement('c:v'); |
1000 | - $objWriter->writeRawData( 1 ); |
|
1000 | + $objWriter->writeRawData(1); |
|
1001 | 1001 | $objWriter->endElement(); |
1002 | 1002 | $objWriter->endElement(); |
1003 | 1003 | } |
@@ -1006,7 +1006,7 @@ discard block |
||
1006 | 1006 | $objWriter->endElement(); |
1007 | 1007 | |
1008 | 1008 | $objWriter->startElement('c:bubble3D'); |
1009 | - $objWriter->writeAttribute('val', 0 ); |
|
1009 | + $objWriter->writeAttribute('val', 0); |
|
1010 | 1010 | $objWriter->endElement(); |
1011 | 1011 | } |
1012 | 1012 | |
@@ -1021,53 +1021,53 @@ discard block |
||
1021 | 1021 | { |
1022 | 1022 | $objWriter->startElement('c:layout'); |
1023 | 1023 | |
1024 | - if (!is_null($layout)) { |
|
1024 | + if ( ! is_null($layout)) { |
|
1025 | 1025 | $objWriter->startElement('c:manualLayout'); |
1026 | 1026 | |
1027 | 1027 | $layoutTarget = $layout->getLayoutTarget(); |
1028 | - if (!is_null($layoutTarget)) { |
|
1028 | + if ( ! is_null($layoutTarget)) { |
|
1029 | 1029 | $objWriter->startElement('c:layoutTarget'); |
1030 | 1030 | $objWriter->writeAttribute('val', $layoutTarget); |
1031 | 1031 | $objWriter->endElement(); |
1032 | 1032 | } |
1033 | 1033 | |
1034 | 1034 | $xMode = $layout->getXMode(); |
1035 | - if (!is_null($xMode)) { |
|
1035 | + if ( ! is_null($xMode)) { |
|
1036 | 1036 | $objWriter->startElement('c:xMode'); |
1037 | 1037 | $objWriter->writeAttribute('val', $xMode); |
1038 | 1038 | $objWriter->endElement(); |
1039 | 1039 | } |
1040 | 1040 | |
1041 | 1041 | $yMode = $layout->getYMode(); |
1042 | - if (!is_null($yMode)) { |
|
1042 | + if ( ! is_null($yMode)) { |
|
1043 | 1043 | $objWriter->startElement('c:yMode'); |
1044 | 1044 | $objWriter->writeAttribute('val', $yMode); |
1045 | 1045 | $objWriter->endElement(); |
1046 | 1046 | } |
1047 | 1047 | |
1048 | 1048 | $x = $layout->getXPosition(); |
1049 | - if (!is_null($x)) { |
|
1049 | + if ( ! is_null($x)) { |
|
1050 | 1050 | $objWriter->startElement('c:x'); |
1051 | 1051 | $objWriter->writeAttribute('val', $x); |
1052 | 1052 | $objWriter->endElement(); |
1053 | 1053 | } |
1054 | 1054 | |
1055 | 1055 | $y = $layout->getYPosition(); |
1056 | - if (!is_null($y)) { |
|
1056 | + if ( ! is_null($y)) { |
|
1057 | 1057 | $objWriter->startElement('c:y'); |
1058 | 1058 | $objWriter->writeAttribute('val', $y); |
1059 | 1059 | $objWriter->endElement(); |
1060 | 1060 | } |
1061 | 1061 | |
1062 | 1062 | $w = $layout->getWidth(); |
1063 | - if (!is_null($w)) { |
|
1063 | + if ( ! is_null($w)) { |
|
1064 | 1064 | $objWriter->startElement('c:w'); |
1065 | 1065 | $objWriter->writeAttribute('val', $w); |
1066 | 1066 | $objWriter->endElement(); |
1067 | 1067 | } |
1068 | 1068 | |
1069 | 1069 | $h = $layout->getHeight(); |
1070 | - if (!is_null($h)) { |
|
1070 | + if ( ! is_null($h)) { |
|
1071 | 1071 | $objWriter->startElement('c:h'); |
1072 | 1072 | $objWriter->writeAttribute('val', $h); |
1073 | 1073 | $objWriter->endElement(); |
@@ -136,8 +136,9 @@ discard block |
||
136 | 136 | $objWriter->startElement('a:p'); |
137 | 137 | |
138 | 138 | $caption = $title->getCaption(); |
139 | - if ((is_array($caption)) && (count($caption) > 0)) |
|
140 | - $caption = $caption[0]; |
|
139 | + if ((is_array($caption)) && (count($caption) > 0)) { |
|
140 | + $caption = $caption[0]; |
|
141 | + } |
|
141 | 142 | $this->getParentWriter()->getWriterPart('stringtable')->writeRichTextForCharts($objWriter, $caption, 'a'); |
142 | 143 | |
143 | 144 | $objWriter->endElement(); |
@@ -435,8 +436,9 @@ discard block |
||
435 | 436 | $objWriter->startElement('a:r'); |
436 | 437 | |
437 | 438 | $caption = $xAxisLabel->getCaption(); |
438 | - if (is_array($caption)) |
|
439 | - $caption = $caption[0]; |
|
439 | + if (is_array($caption)) { |
|
440 | + $caption = $caption[0]; |
|
441 | + } |
|
440 | 442 | $objWriter->startElement('a:t'); |
441 | 443 | $objWriter->writeAttribute('xml:space', 'preserve'); |
442 | 444 | $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $caption )); |
@@ -561,8 +563,9 @@ discard block |
||
561 | 563 | $objWriter->startElement('a:r'); |
562 | 564 | |
563 | 565 | $caption = $yAxisLabel->getCaption(); |
564 | - if (is_array($caption)) |
|
565 | - $caption = $caption[0]; |
|
566 | + if (is_array($caption)) { |
|
567 | + $caption = $caption[0]; |
|
568 | + } |
|
566 | 569 | $objWriter->startElement('a:t'); |
567 | 570 | $objWriter->writeAttribute('xml:space', 'preserve'); |
568 | 571 | $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $caption )); |
@@ -53,16 +53,16 @@ discard block |
||
53 | 53 | } |
54 | 54 | |
55 | 55 | // XML header |
56 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
56 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
57 | 57 | |
58 | 58 | // Comments cache |
59 | - $comments = $pWorksheet->getComments(); |
|
59 | + $comments = $pWorksheet->getComments(); |
|
60 | 60 | |
61 | 61 | // Authors cache |
62 | - $authors = array(); |
|
63 | - $authorId = 0; |
|
62 | + $authors = array(); |
|
63 | + $authorId = 0; |
|
64 | 64 | foreach ($comments as $comment) { |
65 | - if (!isset($authors[$comment->getAuthor()])) { |
|
65 | + if ( ! isset($authors[$comment->getAuthor()])) { |
|
66 | 66 | $authors[$comment->getAuthor()] = $authorId++; |
67 | 67 | } |
68 | 68 | } |
@@ -104,8 +104,8 @@ discard block |
||
104 | 104 | { |
105 | 105 | // comment |
106 | 106 | $objWriter->startElement('comment'); |
107 | - $objWriter->writeAttribute('ref', $pCellReference); |
|
108 | - $objWriter->writeAttribute('authorId', $pAuthors[$pComment->getAuthor()]); |
|
107 | + $objWriter->writeAttribute('ref', $pCellReference); |
|
108 | + $objWriter->writeAttribute('authorId', $pAuthors[$pComment->getAuthor()]); |
|
109 | 109 | |
110 | 110 | // text |
111 | 111 | $objWriter->startElement('text'); |
@@ -133,10 +133,10 @@ discard block |
||
133 | 133 | } |
134 | 134 | |
135 | 135 | // XML header |
136 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
136 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
137 | 137 | |
138 | 138 | // Comments cache |
139 | - $comments = $pWorksheet->getComments(); |
|
139 | + $comments = $pWorksheet->getComments(); |
|
140 | 140 | |
141 | 141 | // xml |
142 | 142 | $objWriter->startElement('xml'); |
@@ -146,32 +146,32 @@ discard block |
||
146 | 146 | |
147 | 147 | // o:shapelayout |
148 | 148 | $objWriter->startElement('o:shapelayout'); |
149 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
149 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
150 | 150 | |
151 | 151 | // o:idmap |
152 | 152 | $objWriter->startElement('o:idmap'); |
153 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
154 | - $objWriter->writeAttribute('data', '1'); |
|
153 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
154 | + $objWriter->writeAttribute('data', '1'); |
|
155 | 155 | $objWriter->endElement(); |
156 | 156 | |
157 | 157 | $objWriter->endElement(); |
158 | 158 | |
159 | 159 | // v:shapetype |
160 | 160 | $objWriter->startElement('v:shapetype'); |
161 | - $objWriter->writeAttribute('id', '_x0000_t202'); |
|
161 | + $objWriter->writeAttribute('id', '_x0000_t202'); |
|
162 | 162 | $objWriter->writeAttribute('coordsize', '21600,21600'); |
163 | - $objWriter->writeAttribute('o:spt', '202'); |
|
164 | - $objWriter->writeAttribute('path', 'm,l,21600r21600,l21600,xe'); |
|
163 | + $objWriter->writeAttribute('o:spt', '202'); |
|
164 | + $objWriter->writeAttribute('path', 'm,l,21600r21600,l21600,xe'); |
|
165 | 165 | |
166 | 166 | // v:stroke |
167 | 167 | $objWriter->startElement('v:stroke'); |
168 | - $objWriter->writeAttribute('joinstyle', 'miter'); |
|
168 | + $objWriter->writeAttribute('joinstyle', 'miter'); |
|
169 | 169 | $objWriter->endElement(); |
170 | 170 | |
171 | 171 | // v:path |
172 | 172 | $objWriter->startElement('v:path'); |
173 | - $objWriter->writeAttribute('gradientshapeok', 't'); |
|
174 | - $objWriter->writeAttribute('o:connecttype', 'rect'); |
|
173 | + $objWriter->writeAttribute('gradientshapeok', 't'); |
|
174 | + $objWriter->writeAttribute('o:connecttype', 'rect'); |
|
175 | 175 | $objWriter->endElement(); |
176 | 176 | |
177 | 177 | $objWriter->endElement(); |
@@ -205,22 +205,22 @@ discard block |
||
205 | 205 | |
206 | 206 | // v:shape |
207 | 207 | $objWriter->startElement('v:shape'); |
208 | - $objWriter->writeAttribute('id', '_x0000_s' . $id); |
|
209 | - $objWriter->writeAttribute('type', '#_x0000_t202'); |
|
210 | - $objWriter->writeAttribute('style', 'position:absolute;margin-left:' . $pComment->getMarginLeft() . ';margin-top:' . $pComment->getMarginTop() . ';width:' . $pComment->getWidth() . ';height:' . $pComment->getHeight() . ';z-index:1;visibility:' . ($pComment->getVisible() ? 'visible' : 'hidden')); |
|
211 | - $objWriter->writeAttribute('fillcolor', '#' . $pComment->getFillColor()->getRGB()); |
|
212 | - $objWriter->writeAttribute('o:insetmode', 'auto'); |
|
208 | + $objWriter->writeAttribute('id', '_x0000_s'.$id); |
|
209 | + $objWriter->writeAttribute('type', '#_x0000_t202'); |
|
210 | + $objWriter->writeAttribute('style', 'position:absolute;margin-left:'.$pComment->getMarginLeft().';margin-top:'.$pComment->getMarginTop().';width:'.$pComment->getWidth().';height:'.$pComment->getHeight().';z-index:1;visibility:'.($pComment->getVisible() ? 'visible' : 'hidden')); |
|
211 | + $objWriter->writeAttribute('fillcolor', '#'.$pComment->getFillColor()->getRGB()); |
|
212 | + $objWriter->writeAttribute('o:insetmode', 'auto'); |
|
213 | 213 | |
214 | 214 | // v:fill |
215 | 215 | $objWriter->startElement('v:fill'); |
216 | - $objWriter->writeAttribute('color2', '#' . $pComment->getFillColor()->getRGB()); |
|
216 | + $objWriter->writeAttribute('color2', '#'.$pComment->getFillColor()->getRGB()); |
|
217 | 217 | $objWriter->endElement(); |
218 | 218 | |
219 | 219 | // v:shadow |
220 | 220 | $objWriter->startElement('v:shadow'); |
221 | - $objWriter->writeAttribute('on', 't'); |
|
222 | - $objWriter->writeAttribute('color', 'black'); |
|
223 | - $objWriter->writeAttribute('obscured', 't'); |
|
221 | + $objWriter->writeAttribute('on', 't'); |
|
222 | + $objWriter->writeAttribute('color', 'black'); |
|
223 | + $objWriter->writeAttribute('obscured', 't'); |
|
224 | 224 | $objWriter->endElement(); |
225 | 225 | |
226 | 226 | // v:path |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | } |
55 | 55 | |
56 | 56 | // XML header |
57 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
57 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
58 | 58 | |
59 | 59 | // Types |
60 | 60 | $objWriter->startElement('Types'); |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | ); |
101 | 101 | |
102 | 102 | $customPropertyList = $pPHPExcel->getProperties()->getCustomProperties(); |
103 | - if (!empty($customPropertyList)) { |
|
103 | + if ( ! empty($customPropertyList)) { |
|
104 | 104 | $this->_writeOverrideContentType( |
105 | 105 | $objWriter, '/docProps/custom.xml', 'application/vnd.openxmlformats-officedocument.custom-properties+xml' |
106 | 106 | ); |
@@ -110,7 +110,7 @@ discard block |
||
110 | 110 | $sheetCount = $pPHPExcel->getSheetCount(); |
111 | 111 | for ($i = 0; $i < $sheetCount; ++$i) { |
112 | 112 | $this->_writeOverrideContentType( |
113 | - $objWriter, '/xl/worksheets/sheet' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml' |
|
113 | + $objWriter, '/xl/worksheets/sheet'.($i + 1).'.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml' |
|
114 | 114 | ); |
115 | 115 | } |
116 | 116 | |
@@ -129,7 +129,7 @@ discard block |
||
129 | 129 | // We need a drawing relationship for the worksheet if we have either drawings or charts |
130 | 130 | if (($drawingCount > 0) || ($chartCount > 0)) { |
131 | 131 | $this->_writeOverrideContentType( |
132 | - $objWriter, '/xl/drawings/drawing' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.drawing+xml' |
|
132 | + $objWriter, '/xl/drawings/drawing'.($i + 1).'.xml', 'application/vnd.openxmlformats-officedocument.drawing+xml' |
|
133 | 133 | ); |
134 | 134 | } |
135 | 135 | |
@@ -137,7 +137,7 @@ discard block |
||
137 | 137 | if ($chartCount > 0) { |
138 | 138 | for ($c = 0; $c < $chartCount; ++$c) { |
139 | 139 | $this->_writeOverrideContentType( |
140 | - $objWriter, '/xl/charts/chart' . $chart++ . '.xml', 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml' |
|
140 | + $objWriter, '/xl/charts/chart'.$chart++.'.xml', 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml' |
|
141 | 141 | ); |
142 | 142 | } |
143 | 143 | } |
@@ -147,7 +147,7 @@ discard block |
||
147 | 147 | for ($i = 0; $i < $sheetCount; ++$i) { |
148 | 148 | if (count($pPHPExcel->getSheet($i)->getComments()) > 0) { |
149 | 149 | $this->_writeOverrideContentType( |
150 | - $objWriter, '/xl/comments' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml' |
|
150 | + $objWriter, '/xl/comments'.($i + 1).'.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml' |
|
151 | 151 | ); |
152 | 152 | } |
153 | 153 | } |
@@ -156,21 +156,21 @@ discard block |
||
156 | 156 | $aMediaContentTypes = array(); |
157 | 157 | $mediaCount = $this->getParentWriter()->getDrawingHashTable()->count(); |
158 | 158 | for ($i = 0; $i < $mediaCount; ++$i) { |
159 | - $extension = ''; |
|
159 | + $extension = ''; |
|
160 | 160 | $mimeType = ''; |
161 | 161 | |
162 | 162 | if ($this->getParentWriter()->getDrawingHashTable()->getByIndex($i) instanceof PHPExcel_Worksheet_Drawing) { |
163 | 163 | $extension = strtolower($this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getExtension()); |
164 | - $mimeType = $this->_getImageMimeType( $this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getPath() ); |
|
164 | + $mimeType = $this->_getImageMimeType($this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getPath()); |
|
165 | 165 | } else if ($this->getParentWriter()->getDrawingHashTable()->getByIndex($i) instanceof PHPExcel_Worksheet_MemoryDrawing) { |
166 | 166 | $extension = strtolower($this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getMimeType()); |
167 | 167 | $extension = explode('/', $extension); |
168 | 168 | $extension = $extension[1]; |
169 | 169 | |
170 | - $mimeType = $this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getMimeType(); |
|
170 | + $mimeType = $this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getMimeType(); |
|
171 | 171 | } |
172 | 172 | |
173 | - if (!isset( $aMediaContentTypes[$extension]) ) { |
|
173 | + if ( ! isset($aMediaContentTypes[$extension])) { |
|
174 | 174 | $aMediaContentTypes[$extension] = $mimeType; |
175 | 175 | |
176 | 176 | $this->_writeDefaultContentType( |
@@ -183,8 +183,8 @@ discard block |
||
183 | 183 | for ($i = 0; $i < $sheetCount; ++$i) { |
184 | 184 | if (count($pPHPExcel->getSheet()->getHeaderFooter()->getImages()) > 0) { |
185 | 185 | foreach ($pPHPExcel->getSheet()->getHeaderFooter()->getImages() as $image) { |
186 | - if (!isset( $aMediaContentTypes[strtolower($image->getExtension())]) ) { |
|
187 | - $aMediaContentTypes[strtolower($image->getExtension())] = $this->_getImageMimeType( $image->getPath() ); |
|
186 | + if ( ! isset($aMediaContentTypes[strtolower($image->getExtension())])) { |
|
187 | + $aMediaContentTypes[strtolower($image->getExtension())] = $this->_getImageMimeType($image->getPath()); |
|
188 | 188 | |
189 | 189 | $this->_writeDefaultContentType( |
190 | 190 | $objWriter, strtolower($image->getExtension()), $aMediaContentTypes[strtolower($image->getExtension())] |
@@ -230,8 +230,8 @@ discard block |
||
230 | 230 | if ($pPartname != '' && $pContentType != '') { |
231 | 231 | // Write content type |
232 | 232 | $objWriter->startElement('Default'); |
233 | - $objWriter->writeAttribute('Extension', $pPartname); |
|
234 | - $objWriter->writeAttribute('ContentType', $pContentType); |
|
233 | + $objWriter->writeAttribute('Extension', $pPartname); |
|
234 | + $objWriter->writeAttribute('ContentType', $pContentType); |
|
235 | 235 | $objWriter->endElement(); |
236 | 236 | } else { |
237 | 237 | throw new Exception("Invalid parameters passed."); |
@@ -251,8 +251,8 @@ discard block |
||
251 | 251 | if ($pPartname != '' && $pContentType != '') { |
252 | 252 | // Write content type |
253 | 253 | $objWriter->startElement('Override'); |
254 | - $objWriter->writeAttribute('PartName', $pPartname); |
|
255 | - $objWriter->writeAttribute('ContentType', $pContentType); |
|
254 | + $objWriter->writeAttribute('PartName', $pPartname); |
|
255 | + $objWriter->writeAttribute('ContentType', $pContentType); |
|
256 | 256 | $objWriter->endElement(); |
257 | 257 | } else { |
258 | 258 | throw new Exception("Invalid parameters passed."); |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | } |
54 | 54 | |
55 | 55 | // XML header |
56 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
56 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
57 | 57 | |
58 | 58 | // Properties |
59 | 59 | $objWriter->startElement('Properties'); |
@@ -61,30 +61,30 @@ discard block |
||
61 | 61 | $objWriter->writeAttribute('xmlns:vt', 'http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes'); |
62 | 62 | |
63 | 63 | // Application |
64 | - $objWriter->writeElement('Application', 'Microsoft Excel'); |
|
64 | + $objWriter->writeElement('Application', 'Microsoft Excel'); |
|
65 | 65 | |
66 | 66 | // DocSecurity |
67 | - $objWriter->writeElement('DocSecurity', '0'); |
|
67 | + $objWriter->writeElement('DocSecurity', '0'); |
|
68 | 68 | |
69 | 69 | // ScaleCrop |
70 | - $objWriter->writeElement('ScaleCrop', 'false'); |
|
70 | + $objWriter->writeElement('ScaleCrop', 'false'); |
|
71 | 71 | |
72 | 72 | // HeadingPairs |
73 | 73 | $objWriter->startElement('HeadingPairs'); |
74 | 74 | |
75 | 75 | // Vector |
76 | 76 | $objWriter->startElement('vt:vector'); |
77 | - $objWriter->writeAttribute('size', '2'); |
|
78 | - $objWriter->writeAttribute('baseType', 'variant'); |
|
77 | + $objWriter->writeAttribute('size', '2'); |
|
78 | + $objWriter->writeAttribute('baseType', 'variant'); |
|
79 | 79 | |
80 | 80 | // Variant |
81 | 81 | $objWriter->startElement('vt:variant'); |
82 | - $objWriter->writeElement('vt:lpstr', 'Worksheets'); |
|
82 | + $objWriter->writeElement('vt:lpstr', 'Worksheets'); |
|
83 | 83 | $objWriter->endElement(); |
84 | 84 | |
85 | 85 | // Variant |
86 | 86 | $objWriter->startElement('vt:variant'); |
87 | - $objWriter->writeElement('vt:i4', $pPHPExcel->getSheetCount()); |
|
87 | + $objWriter->writeElement('vt:i4', $pPHPExcel->getSheetCount()); |
|
88 | 88 | $objWriter->endElement(); |
89 | 89 | |
90 | 90 | $objWriter->endElement(); |
@@ -96,8 +96,8 @@ discard block |
||
96 | 96 | |
97 | 97 | // Vector |
98 | 98 | $objWriter->startElement('vt:vector'); |
99 | - $objWriter->writeAttribute('size', $pPHPExcel->getSheetCount()); |
|
100 | - $objWriter->writeAttribute('baseType', 'lpstr'); |
|
99 | + $objWriter->writeAttribute('size', $pPHPExcel->getSheetCount()); |
|
100 | + $objWriter->writeAttribute('baseType', 'lpstr'); |
|
101 | 101 | |
102 | 102 | $sheetCount = $pPHPExcel->getSheetCount(); |
103 | 103 | for ($i = 0; $i < $sheetCount; ++$i) { |
@@ -109,22 +109,22 @@ discard block |
||
109 | 109 | $objWriter->endElement(); |
110 | 110 | |
111 | 111 | // Company |
112 | - $objWriter->writeElement('Company', $pPHPExcel->getProperties()->getCompany()); |
|
112 | + $objWriter->writeElement('Company', $pPHPExcel->getProperties()->getCompany()); |
|
113 | 113 | |
114 | 114 | // Company |
115 | - $objWriter->writeElement('Manager', $pPHPExcel->getProperties()->getManager()); |
|
115 | + $objWriter->writeElement('Manager', $pPHPExcel->getProperties()->getManager()); |
|
116 | 116 | |
117 | 117 | // LinksUpToDate |
118 | - $objWriter->writeElement('LinksUpToDate', 'false'); |
|
118 | + $objWriter->writeElement('LinksUpToDate', 'false'); |
|
119 | 119 | |
120 | 120 | // SharedDoc |
121 | - $objWriter->writeElement('SharedDoc', 'false'); |
|
121 | + $objWriter->writeElement('SharedDoc', 'false'); |
|
122 | 122 | |
123 | 123 | // HyperlinksChanged |
124 | - $objWriter->writeElement('HyperlinksChanged', 'false'); |
|
124 | + $objWriter->writeElement('HyperlinksChanged', 'false'); |
|
125 | 125 | |
126 | 126 | // AppVersion |
127 | - $objWriter->writeElement('AppVersion', '12.0000'); |
|
127 | + $objWriter->writeElement('AppVersion', '12.0000'); |
|
128 | 128 | |
129 | 129 | $objWriter->endElement(); |
130 | 130 | |
@@ -150,7 +150,7 @@ discard block |
||
150 | 150 | } |
151 | 151 | |
152 | 152 | // XML header |
153 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
153 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
154 | 154 | |
155 | 155 | // cp:coreProperties |
156 | 156 | $objWriter->startElement('cp:coreProperties'); |
@@ -161,37 +161,37 @@ discard block |
||
161 | 161 | $objWriter->writeAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance'); |
162 | 162 | |
163 | 163 | // dc:creator |
164 | - $objWriter->writeElement('dc:creator', $pPHPExcel->getProperties()->getCreator()); |
|
164 | + $objWriter->writeElement('dc:creator', $pPHPExcel->getProperties()->getCreator()); |
|
165 | 165 | |
166 | 166 | // cp:lastModifiedBy |
167 | - $objWriter->writeElement('cp:lastModifiedBy', $pPHPExcel->getProperties()->getLastModifiedBy()); |
|
167 | + $objWriter->writeElement('cp:lastModifiedBy', $pPHPExcel->getProperties()->getLastModifiedBy()); |
|
168 | 168 | |
169 | 169 | // dcterms:created |
170 | 170 | $objWriter->startElement('dcterms:created'); |
171 | 171 | $objWriter->writeAttribute('xsi:type', 'dcterms:W3CDTF'); |
172 | - $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getCreated())); |
|
172 | + $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getCreated())); |
|
173 | 173 | $objWriter->endElement(); |
174 | 174 | |
175 | 175 | // dcterms:modified |
176 | 176 | $objWriter->startElement('dcterms:modified'); |
177 | 177 | $objWriter->writeAttribute('xsi:type', 'dcterms:W3CDTF'); |
178 | - $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getModified())); |
|
178 | + $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getModified())); |
|
179 | 179 | $objWriter->endElement(); |
180 | 180 | |
181 | 181 | // dc:title |
182 | - $objWriter->writeElement('dc:title', $pPHPExcel->getProperties()->getTitle()); |
|
182 | + $objWriter->writeElement('dc:title', $pPHPExcel->getProperties()->getTitle()); |
|
183 | 183 | |
184 | 184 | // dc:description |
185 | - $objWriter->writeElement('dc:description', $pPHPExcel->getProperties()->getDescription()); |
|
185 | + $objWriter->writeElement('dc:description', $pPHPExcel->getProperties()->getDescription()); |
|
186 | 186 | |
187 | 187 | // dc:subject |
188 | - $objWriter->writeElement('dc:subject', $pPHPExcel->getProperties()->getSubject()); |
|
188 | + $objWriter->writeElement('dc:subject', $pPHPExcel->getProperties()->getSubject()); |
|
189 | 189 | |
190 | 190 | // cp:keywords |
191 | - $objWriter->writeElement('cp:keywords', $pPHPExcel->getProperties()->getKeywords()); |
|
191 | + $objWriter->writeElement('cp:keywords', $pPHPExcel->getProperties()->getKeywords()); |
|
192 | 192 | |
193 | 193 | // cp:category |
194 | - $objWriter->writeElement('cp:category', $pPHPExcel->getProperties()->getCategory()); |
|
194 | + $objWriter->writeElement('cp:category', $pPHPExcel->getProperties()->getCategory()); |
|
195 | 195 | |
196 | 196 | $objWriter->endElement(); |
197 | 197 | |
@@ -222,7 +222,7 @@ discard block |
||
222 | 222 | } |
223 | 223 | |
224 | 224 | // XML header |
225 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
225 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
226 | 226 | |
227 | 227 | // cp:coreProperties |
228 | 228 | $objWriter->startElement('Properties'); |
@@ -230,24 +230,24 @@ discard block |
||
230 | 230 | $objWriter->writeAttribute('xmlns:vt', 'http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes'); |
231 | 231 | |
232 | 232 | |
233 | - foreach($customPropertyList as $key => $customProperty) { |
|
233 | + foreach ($customPropertyList as $key => $customProperty) { |
|
234 | 234 | $propertyValue = $pPHPExcel->getProperties()->getCustomPropertyValue($customProperty); |
235 | 235 | $propertyType = $pPHPExcel->getProperties()->getCustomPropertyType($customProperty); |
236 | 236 | |
237 | 237 | $objWriter->startElement('property'); |
238 | - $objWriter->writeAttribute('fmtid', '{D5CDD505-2E9C-101B-9397-08002B2CF9AE}'); |
|
239 | - $objWriter->writeAttribute('pid', $key+2); |
|
240 | - $objWriter->writeAttribute('name', $customProperty); |
|
238 | + $objWriter->writeAttribute('fmtid', '{D5CDD505-2E9C-101B-9397-08002B2CF9AE}'); |
|
239 | + $objWriter->writeAttribute('pid', $key + 2); |
|
240 | + $objWriter->writeAttribute('name', $customProperty); |
|
241 | 241 | |
242 | - switch($propertyType) { |
|
242 | + switch ($propertyType) { |
|
243 | 243 | case 'i' : |
244 | - $objWriter->writeElement('vt:i4', $propertyValue); |
|
244 | + $objWriter->writeElement('vt:i4', $propertyValue); |
|
245 | 245 | break; |
246 | 246 | case 'f' : |
247 | - $objWriter->writeElement('vt:r8', $propertyValue); |
|
247 | + $objWriter->writeElement('vt:r8', $propertyValue); |
|
248 | 248 | break; |
249 | 249 | case 'b' : |
250 | - $objWriter->writeElement('vt:bool', ($propertyValue) ? 'true' : 'false'); |
|
250 | + $objWriter->writeElement('vt:bool', ($propertyValue) ? 'true' : 'false'); |
|
251 | 251 | break; |
252 | 252 | case 'd' : |
253 | 253 | $objWriter->startElement('vt:filetime'); |
@@ -255,7 +255,7 @@ discard block |
||
255 | 255 | $objWriter->endElement(); |
256 | 256 | break; |
257 | 257 | default : |
258 | - $objWriter->writeElement('vt:lpwstr', $propertyValue); |
|
258 | + $objWriter->writeElement('vt:lpwstr', $propertyValue); |
|
259 | 259 | break; |
260 | 260 | } |
261 | 261 |
@@ -36,12 +36,12 @@ |
||
36 | 36 | class PHPExcel_Writer_Excel2007_DocProps extends PHPExcel_Writer_Excel2007_WriterPart |
37 | 37 | { |
38 | 38 | /** |
39 | - * Write docProps/app.xml to XML format |
|
40 | - * |
|
41 | - * @param PHPExcel $pPHPExcel |
|
42 | - * @return string XML Output |
|
43 | - * @throws Exception |
|
44 | - */ |
|
39 | + * Write docProps/app.xml to XML format |
|
40 | + * |
|
41 | + * @param PHPExcel $pPHPExcel |
|
42 | + * @return string XML Output |
|
43 | + * @throws Exception |
|
44 | + */ |
|
45 | 45 | public function writeDocPropsApp(PHPExcel $pPHPExcel = null) |
46 | 46 | { |
47 | 47 | // Create XML writer |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | } |
56 | 56 | |
57 | 57 | // XML header |
58 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
58 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
59 | 59 | |
60 | 60 | // xdr:wsDr |
61 | 61 | $objWriter->startElement('xdr:wsDr'); |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | // Loop through charts and write the chart position |
78 | 78 | if ($chartCount > 0) { |
79 | 79 | for ($c = 0; $c < $chartCount; ++$c) { |
80 | - $this->_writeChart($objWriter, $pWorksheet->getChartByIndex($c), $c+$i); |
|
80 | + $this->_writeChart($objWriter, $pWorksheet->getChartByIndex($c), $c + $i); |
|
81 | 81 | } |
82 | 82 | } |
83 | 83 | } |
@@ -175,8 +175,8 @@ discard block |
||
175 | 175 | // xdr:oneCellAnchor |
176 | 176 | $objWriter->startElement('xdr:oneCellAnchor'); |
177 | 177 | // Image location |
178 | - $aCoordinates = PHPExcel_Cell::coordinateFromString($pDrawing->getCoordinates()); |
|
179 | - $aCoordinates[0] = PHPExcel_Cell::columnIndexFromString($aCoordinates[0]); |
|
178 | + $aCoordinates = PHPExcel_Cell::coordinateFromString($pDrawing->getCoordinates()); |
|
179 | + $aCoordinates[0] = PHPExcel_Cell::columnIndexFromString($aCoordinates[0]); |
|
180 | 180 | |
181 | 181 | // xdr:from |
182 | 182 | $objWriter->startElement('xdr:from'); |
@@ -223,7 +223,7 @@ discard block |
||
223 | 223 | // a:blip |
224 | 224 | $objWriter->startElement('a:blip'); |
225 | 225 | $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships'); |
226 | - $objWriter->writeAttribute('r:embed', 'rId' . $pRelationId); |
|
226 | + $objWriter->writeAttribute('r:embed', 'rId'.$pRelationId); |
|
227 | 227 | $objWriter->endElement(); |
228 | 228 | |
229 | 229 | // a:stretch |
@@ -297,19 +297,19 @@ discard block |
||
297 | 297 | |
298 | 298 | // a:outerShdw |
299 | 299 | $objWriter->startElement('a:outerShdw'); |
300 | - $objWriter->writeAttribute('blurRad', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getBlurRadius())); |
|
301 | - $objWriter->writeAttribute('dist', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getDistance())); |
|
302 | - $objWriter->writeAttribute('dir', PHPExcel_Shared_Drawing::degreesToAngle($pDrawing->getShadow()->getDirection())); |
|
303 | - $objWriter->writeAttribute('algn', $pDrawing->getShadow()->getAlignment()); |
|
304 | - $objWriter->writeAttribute('rotWithShape', '0'); |
|
300 | + $objWriter->writeAttribute('blurRad', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getBlurRadius())); |
|
301 | + $objWriter->writeAttribute('dist', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getDistance())); |
|
302 | + $objWriter->writeAttribute('dir', PHPExcel_Shared_Drawing::degreesToAngle($pDrawing->getShadow()->getDirection())); |
|
303 | + $objWriter->writeAttribute('algn', $pDrawing->getShadow()->getAlignment()); |
|
304 | + $objWriter->writeAttribute('rotWithShape', '0'); |
|
305 | 305 | |
306 | 306 | // a:srgbClr |
307 | 307 | $objWriter->startElement('a:srgbClr'); |
308 | - $objWriter->writeAttribute('val', $pDrawing->getShadow()->getColor()->getRGB()); |
|
308 | + $objWriter->writeAttribute('val', $pDrawing->getShadow()->getColor()->getRGB()); |
|
309 | 309 | |
310 | 310 | // a:alpha |
311 | 311 | $objWriter->startElement('a:alpha'); |
312 | - $objWriter->writeAttribute('val', $pDrawing->getShadow()->getAlpha() * 1000); |
|
312 | + $objWriter->writeAttribute('val', $pDrawing->getShadow()->getAlpha() * 1000); |
|
313 | 313 | $objWriter->endElement(); |
314 | 314 | |
315 | 315 | $objWriter->endElement(); |
@@ -397,7 +397,7 @@ discard block |
||
397 | 397 | } |
398 | 398 | |
399 | 399 | // XML header |
400 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
400 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
401 | 401 | |
402 | 402 | // Header/footer images |
403 | 403 | $images = $pWorksheet->getHeaderFooter()->getImages(); |
@@ -410,29 +410,29 @@ discard block |
||
410 | 410 | |
411 | 411 | // o:shapelayout |
412 | 412 | $objWriter->startElement('o:shapelayout'); |
413 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
413 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
414 | 414 | |
415 | 415 | // o:idmap |
416 | 416 | $objWriter->startElement('o:idmap'); |
417 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
418 | - $objWriter->writeAttribute('data', '1'); |
|
417 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
418 | + $objWriter->writeAttribute('data', '1'); |
|
419 | 419 | $objWriter->endElement(); |
420 | 420 | |
421 | 421 | $objWriter->endElement(); |
422 | 422 | |
423 | 423 | // v:shapetype |
424 | 424 | $objWriter->startElement('v:shapetype'); |
425 | - $objWriter->writeAttribute('id', '_x0000_t75'); |
|
426 | - $objWriter->writeAttribute('coordsize', '21600,21600'); |
|
427 | - $objWriter->writeAttribute('o:spt', '75'); |
|
428 | - $objWriter->writeAttribute('o:preferrelative', 't'); |
|
429 | - $objWriter->writeAttribute('path', 'm@4@5l@4@11@9@11@9@5xe'); |
|
430 | - $objWriter->writeAttribute('filled', 'f'); |
|
431 | - $objWriter->writeAttribute('stroked', 'f'); |
|
425 | + $objWriter->writeAttribute('id', '_x0000_t75'); |
|
426 | + $objWriter->writeAttribute('coordsize', '21600,21600'); |
|
427 | + $objWriter->writeAttribute('o:spt', '75'); |
|
428 | + $objWriter->writeAttribute('o:preferrelative', 't'); |
|
429 | + $objWriter->writeAttribute('path', 'm@4@5l@4@11@9@11@9@5xe'); |
|
430 | + $objWriter->writeAttribute('filled', 'f'); |
|
431 | + $objWriter->writeAttribute('stroked', 'f'); |
|
432 | 432 | |
433 | 433 | // v:stroke |
434 | 434 | $objWriter->startElement('v:stroke'); |
435 | - $objWriter->writeAttribute('joinstyle', 'miter'); |
|
435 | + $objWriter->writeAttribute('joinstyle', 'miter'); |
|
436 | 436 | $objWriter->endElement(); |
437 | 437 | |
438 | 438 | // v:formulas |
@@ -440,77 +440,77 @@ discard block |
||
440 | 440 | |
441 | 441 | // v:f |
442 | 442 | $objWriter->startElement('v:f'); |
443 | - $objWriter->writeAttribute('eqn', 'if lineDrawn pixelLineWidth 0'); |
|
443 | + $objWriter->writeAttribute('eqn', 'if lineDrawn pixelLineWidth 0'); |
|
444 | 444 | $objWriter->endElement(); |
445 | 445 | |
446 | 446 | // v:f |
447 | 447 | $objWriter->startElement('v:f'); |
448 | - $objWriter->writeAttribute('eqn', 'sum @0 1 0'); |
|
448 | + $objWriter->writeAttribute('eqn', 'sum @0 1 0'); |
|
449 | 449 | $objWriter->endElement(); |
450 | 450 | |
451 | 451 | // v:f |
452 | 452 | $objWriter->startElement('v:f'); |
453 | - $objWriter->writeAttribute('eqn', 'sum 0 0 @1'); |
|
453 | + $objWriter->writeAttribute('eqn', 'sum 0 0 @1'); |
|
454 | 454 | $objWriter->endElement(); |
455 | 455 | |
456 | 456 | // v:f |
457 | 457 | $objWriter->startElement('v:f'); |
458 | - $objWriter->writeAttribute('eqn', 'prod @2 1 2'); |
|
458 | + $objWriter->writeAttribute('eqn', 'prod @2 1 2'); |
|
459 | 459 | $objWriter->endElement(); |
460 | 460 | |
461 | 461 | // v:f |
462 | 462 | $objWriter->startElement('v:f'); |
463 | - $objWriter->writeAttribute('eqn', 'prod @3 21600 pixelWidth'); |
|
463 | + $objWriter->writeAttribute('eqn', 'prod @3 21600 pixelWidth'); |
|
464 | 464 | $objWriter->endElement(); |
465 | 465 | |
466 | 466 | // v:f |
467 | 467 | $objWriter->startElement('v:f'); |
468 | - $objWriter->writeAttribute('eqn', 'prod @3 21600 pixelHeight'); |
|
468 | + $objWriter->writeAttribute('eqn', 'prod @3 21600 pixelHeight'); |
|
469 | 469 | $objWriter->endElement(); |
470 | 470 | |
471 | 471 | // v:f |
472 | 472 | $objWriter->startElement('v:f'); |
473 | - $objWriter->writeAttribute('eqn', 'sum @0 0 1'); |
|
473 | + $objWriter->writeAttribute('eqn', 'sum @0 0 1'); |
|
474 | 474 | $objWriter->endElement(); |
475 | 475 | |
476 | 476 | // v:f |
477 | 477 | $objWriter->startElement('v:f'); |
478 | - $objWriter->writeAttribute('eqn', 'prod @6 1 2'); |
|
478 | + $objWriter->writeAttribute('eqn', 'prod @6 1 2'); |
|
479 | 479 | $objWriter->endElement(); |
480 | 480 | |
481 | 481 | // v:f |
482 | 482 | $objWriter->startElement('v:f'); |
483 | - $objWriter->writeAttribute('eqn', 'prod @7 21600 pixelWidth'); |
|
483 | + $objWriter->writeAttribute('eqn', 'prod @7 21600 pixelWidth'); |
|
484 | 484 | $objWriter->endElement(); |
485 | 485 | |
486 | 486 | // v:f |
487 | 487 | $objWriter->startElement('v:f'); |
488 | - $objWriter->writeAttribute('eqn', 'sum @8 21600 0'); |
|
488 | + $objWriter->writeAttribute('eqn', 'sum @8 21600 0'); |
|
489 | 489 | $objWriter->endElement(); |
490 | 490 | |
491 | 491 | // v:f |
492 | 492 | $objWriter->startElement('v:f'); |
493 | - $objWriter->writeAttribute('eqn', 'prod @7 21600 pixelHeight'); |
|
493 | + $objWriter->writeAttribute('eqn', 'prod @7 21600 pixelHeight'); |
|
494 | 494 | $objWriter->endElement(); |
495 | 495 | |
496 | 496 | // v:f |
497 | 497 | $objWriter->startElement('v:f'); |
498 | - $objWriter->writeAttribute('eqn', 'sum @10 21600 0'); |
|
498 | + $objWriter->writeAttribute('eqn', 'sum @10 21600 0'); |
|
499 | 499 | $objWriter->endElement(); |
500 | 500 | |
501 | 501 | $objWriter->endElement(); |
502 | 502 | |
503 | 503 | // v:path |
504 | 504 | $objWriter->startElement('v:path'); |
505 | - $objWriter->writeAttribute('o:extrusionok', 'f'); |
|
506 | - $objWriter->writeAttribute('gradientshapeok', 't'); |
|
507 | - $objWriter->writeAttribute('o:connecttype', 'rect'); |
|
505 | + $objWriter->writeAttribute('o:extrusionok', 'f'); |
|
506 | + $objWriter->writeAttribute('gradientshapeok', 't'); |
|
507 | + $objWriter->writeAttribute('o:connecttype', 'rect'); |
|
508 | 508 | $objWriter->endElement(); |
509 | 509 | |
510 | 510 | // o:lock |
511 | 511 | $objWriter->startElement('o:lock'); |
512 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
513 | - $objWriter->writeAttribute('aspectratio', 't'); |
|
512 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
513 | + $objWriter->writeAttribute('aspectratio', 't'); |
|
514 | 514 | $objWriter->endElement(); |
515 | 515 | |
516 | 516 | $objWriter->endElement(); |
@@ -548,21 +548,21 @@ discard block |
||
548 | 548 | |
549 | 549 | // v:shape |
550 | 550 | $objWriter->startElement('v:shape'); |
551 | - $objWriter->writeAttribute('id', $pReference); |
|
552 | - $objWriter->writeAttribute('o:spid', '_x0000_s' . $id); |
|
553 | - $objWriter->writeAttribute('type', '#_x0000_t75'); |
|
554 | - $objWriter->writeAttribute('style', "position:absolute;margin-left:{$marginLeft}px;margin-top:{$marginTop}px;width:{$width}px;height:{$height}px;z-index:1"); |
|
551 | + $objWriter->writeAttribute('id', $pReference); |
|
552 | + $objWriter->writeAttribute('o:spid', '_x0000_s'.$id); |
|
553 | + $objWriter->writeAttribute('type', '#_x0000_t75'); |
|
554 | + $objWriter->writeAttribute('style', "position:absolute;margin-left:{$marginLeft}px;margin-top:{$marginTop}px;width:{$width}px;height:{$height}px;z-index:1"); |
|
555 | 555 | |
556 | 556 | // v:imagedata |
557 | 557 | $objWriter->startElement('v:imagedata'); |
558 | - $objWriter->writeAttribute('o:relid', 'rId' . $pReference); |
|
559 | - $objWriter->writeAttribute('o:title', $pImage->getName()); |
|
558 | + $objWriter->writeAttribute('o:relid', 'rId'.$pReference); |
|
559 | + $objWriter->writeAttribute('o:title', $pImage->getName()); |
|
560 | 560 | $objWriter->endElement(); |
561 | 561 | |
562 | 562 | // o:lock |
563 | 563 | $objWriter->startElement('o:lock'); |
564 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
565 | - $objWriter->writeAttribute('rotation', 't'); |
|
564 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
565 | + $objWriter->writeAttribute('rotation', 't'); |
|
566 | 566 | $objWriter->endElement(); |
567 | 567 | |
568 | 568 | $objWriter->endElement(); |
@@ -579,7 +579,7 @@ discard block |
||
579 | 579 | public function allDrawings(PHPExcel $pPHPExcel = null) |
580 | 580 | { |
581 | 581 | // Get an array of all drawings |
582 | - $aDrawings = array(); |
|
582 | + $aDrawings = array(); |
|
583 | 583 | |
584 | 584 | // Loop through PHPExcel |
585 | 585 | $sheetCount = $pPHPExcel->getSheetCount(); |
@@ -53,14 +53,14 @@ discard block |
||
53 | 53 | } |
54 | 54 | |
55 | 55 | // XML header |
56 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
56 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
57 | 57 | |
58 | 58 | // Relationships |
59 | 59 | $objWriter->startElement('Relationships'); |
60 | 60 | $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships'); |
61 | 61 | |
62 | 62 | $customPropertyList = $pPHPExcel->getProperties()->getCustomProperties(); |
63 | - if (!empty($customPropertyList)) { |
|
63 | + if ( ! empty($customPropertyList)) { |
|
64 | 64 | // Relationship docProps/app.xml |
65 | 65 | $this->_writeRelationship( |
66 | 66 | $objWriter, |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | } |
120 | 120 | |
121 | 121 | // XML header |
122 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
122 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
123 | 123 | |
124 | 124 | // Relationships |
125 | 125 | $objWriter->startElement('Relationships'); |
@@ -156,7 +156,7 @@ discard block |
||
156 | 156 | $objWriter, |
157 | 157 | ($i + 1 + 3), |
158 | 158 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet', |
159 | - 'worksheets/sheet' . ($i + 1) . '.xml' |
|
159 | + 'worksheets/sheet'.($i + 1).'.xml' |
|
160 | 160 | ); |
161 | 161 | } |
162 | 162 | |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | } |
191 | 191 | |
192 | 192 | // XML header |
193 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
193 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
194 | 194 | |
195 | 195 | // Relationships |
196 | 196 | $objWriter->startElement('Relationships'); |
@@ -209,7 +209,7 @@ discard block |
||
209 | 209 | $objWriter, |
210 | 210 | ++$d, |
211 | 211 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing', |
212 | - '../drawings/drawing' . $pWorksheetId . '.xml' |
|
212 | + '../drawings/drawing'.$pWorksheetId.'.xml' |
|
213 | 213 | ); |
214 | 214 | } |
215 | 215 | |
@@ -231,10 +231,10 @@ discard block |
||
231 | 231 | // Write hyperlink relationships? |
232 | 232 | $i = 1; |
233 | 233 | foreach ($pWorksheet->getHyperlinkCollection() as $hyperlink) { |
234 | - if (!$hyperlink->isInternal()) { |
|
234 | + if ( ! $hyperlink->isInternal()) { |
|
235 | 235 | $this->_writeRelationship( |
236 | 236 | $objWriter, |
237 | - '_hyperlink_' . $i, |
|
237 | + '_hyperlink_'.$i, |
|
238 | 238 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink', |
239 | 239 | $hyperlink->getUrl(), |
240 | 240 | 'External' |
@@ -249,16 +249,16 @@ discard block |
||
249 | 249 | if (count($pWorksheet->getComments()) > 0) { |
250 | 250 | $this->_writeRelationship( |
251 | 251 | $objWriter, |
252 | - '_comments_vml' . $i, |
|
252 | + '_comments_vml'.$i, |
|
253 | 253 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing', |
254 | - '../drawings/vmlDrawing' . $pWorksheetId . '.vml' |
|
254 | + '../drawings/vmlDrawing'.$pWorksheetId.'.vml' |
|
255 | 255 | ); |
256 | 256 | |
257 | 257 | $this->_writeRelationship( |
258 | 258 | $objWriter, |
259 | - '_comments' . $i, |
|
259 | + '_comments'.$i, |
|
260 | 260 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments', |
261 | - '../comments' . $pWorksheetId . '.xml' |
|
261 | + '../comments'.$pWorksheetId.'.xml' |
|
262 | 262 | ); |
263 | 263 | } |
264 | 264 | |
@@ -267,9 +267,9 @@ discard block |
||
267 | 267 | if (count($pWorksheet->getHeaderFooter()->getImages()) > 0) { |
268 | 268 | $this->_writeRelationship( |
269 | 269 | $objWriter, |
270 | - '_headerfooter_vml' . $i, |
|
270 | + '_headerfooter_vml'.$i, |
|
271 | 271 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing', |
272 | - '../drawings/vmlDrawingHF' . $pWorksheetId . '.vml' |
|
272 | + '../drawings/vmlDrawingHF'.$pWorksheetId.'.vml' |
|
273 | 273 | ); |
274 | 274 | } |
275 | 275 | |
@@ -299,7 +299,7 @@ discard block |
||
299 | 299 | } |
300 | 300 | |
301 | 301 | // XML header |
302 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
302 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
303 | 303 | |
304 | 304 | // Relationships |
305 | 305 | $objWriter->startElement('Relationships'); |
@@ -316,7 +316,7 @@ discard block |
||
316 | 316 | $objWriter, |
317 | 317 | $i, |
318 | 318 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/image', |
319 | - '../media/' . str_replace(' ', '', $iterator->current()->getIndexedFilename()) |
|
319 | + '../media/'.str_replace(' ', '', $iterator->current()->getIndexedFilename()) |
|
320 | 320 | ); |
321 | 321 | } |
322 | 322 | |
@@ -333,7 +333,7 @@ discard block |
||
333 | 333 | $objWriter, |
334 | 334 | $i++, |
335 | 335 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart', |
336 | - '../charts/chart' . ++$chartRef . '.xml' |
|
336 | + '../charts/chart'.++$chartRef.'.xml' |
|
337 | 337 | ); |
338 | 338 | } |
339 | 339 | } |
@@ -363,7 +363,7 @@ discard block |
||
363 | 363 | } |
364 | 364 | |
365 | 365 | // XML header |
366 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
366 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
367 | 367 | |
368 | 368 | // Relationships |
369 | 369 | $objWriter->startElement('Relationships'); |
@@ -376,7 +376,7 @@ discard block |
||
376 | 376 | $objWriter, |
377 | 377 | $key, |
378 | 378 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/image', |
379 | - '../media/' . $value->getIndexedFilename() |
|
379 | + '../media/'.$value->getIndexedFilename() |
|
380 | 380 | ); |
381 | 381 | } |
382 | 382 | |
@@ -401,12 +401,12 @@ discard block |
||
401 | 401 | if ($pType != '' && $pTarget != '') { |
402 | 402 | // Write relationship |
403 | 403 | $objWriter->startElement('Relationship'); |
404 | - $objWriter->writeAttribute('Id', 'rId' . $pId); |
|
405 | - $objWriter->writeAttribute('Type', $pType); |
|
406 | - $objWriter->writeAttribute('Target', $pTarget); |
|
404 | + $objWriter->writeAttribute('Id', 'rId'.$pId); |
|
405 | + $objWriter->writeAttribute('Type', $pType); |
|
406 | + $objWriter->writeAttribute('Target', $pTarget); |
|
407 | 407 | |
408 | 408 | if ($pTargetMode != '') { |
409 | - $objWriter->writeAttribute('TargetMode', $pTargetMode); |
|
409 | + $objWriter->writeAttribute('TargetMode', $pTargetMode); |
|
410 | 410 | } |
411 | 411 | |
412 | 412 | $objWriter->endElement(); |
@@ -49,10 +49,10 @@ discard block |
||
49 | 49 | // Create string lookup table |
50 | 50 | $aStringTable = array(); |
51 | 51 | $cellCollection = null; |
52 | - $aFlippedStringTable = null; // For faster lookup |
|
52 | + $aFlippedStringTable = null; // For faster lookup |
|
53 | 53 | |
54 | 54 | // Is an existing table given? |
55 | - if (!is_null($pExistingTable) && is_array($pExistingTable)) { |
|
55 | + if ( ! is_null($pExistingTable) && is_array($pExistingTable)) { |
|
56 | 56 | $aStringTable = $pExistingTable; |
57 | 57 | } |
58 | 58 | |
@@ -63,16 +63,16 @@ discard block |
||
63 | 63 | foreach ($pSheet->getCellCollection() as $cellID) { |
64 | 64 | $cell = $pSheet->getCell($cellID); |
65 | 65 | $cellValue = $cell->getValue(); |
66 | - if (!is_object($cellValue) && |
|
66 | + if ( ! is_object($cellValue) && |
|
67 | 67 | ($cellValue !== NULL) && |
68 | 68 | $cellValue !== '' && |
69 | - !isset($aFlippedStringTable[$cellValue]) && |
|
69 | + ! isset($aFlippedStringTable[$cellValue]) && |
|
70 | 70 | ($cell->getDataType() == PHPExcel_Cell_DataType::TYPE_STRING || $cell->getDataType() == PHPExcel_Cell_DataType::TYPE_STRING2 || $cell->getDataType() == PHPExcel_Cell_DataType::TYPE_NULL)) { |
71 | 71 | $aStringTable[] = $cellValue; |
72 | 72 | $aFlippedStringTable[$cellValue] = true; |
73 | 73 | } elseif ($cellValue instanceof PHPExcel_RichText && |
74 | 74 | ($cellValue !== NULL) && |
75 | - !isset($aFlippedStringTable[$cellValue->getHashCode()])) { |
|
75 | + ! isset($aFlippedStringTable[$cellValue->getHashCode()])) { |
|
76 | 76 | $aStringTable[] = $cellValue; |
77 | 77 | $aFlippedStringTable[$cellValue->getHashCode()] = true; |
78 | 78 | } |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | */ |
95 | 95 | public function writeStringTable($pStringTable = null) |
96 | 96 | { |
97 | - if (!is_null($pStringTable)) { |
|
97 | + if ( ! is_null($pStringTable)) { |
|
98 | 98 | // Create XML writer |
99 | 99 | $objWriter = null; |
100 | 100 | if ($this->getParentWriter()->getUseDiskCaching()) { |
@@ -104,7 +104,7 @@ discard block |
||
104 | 104 | } |
105 | 105 | |
106 | 106 | // XML header |
107 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
107 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
108 | 108 | |
109 | 109 | // String table |
110 | 110 | $objWriter->startElement('sst'); |
@@ -115,8 +115,8 @@ discard block |
||
115 | 115 | foreach ($pStringTable as $textElement) { |
116 | 116 | $objWriter->startElement('si'); |
117 | 117 | |
118 | - if (! $textElement instanceof PHPExcel_RichText) { |
|
119 | - $textToWrite = PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $textElement ); |
|
118 | + if ( ! $textElement instanceof PHPExcel_RichText) { |
|
119 | + $textToWrite = PHPExcel_Shared_String::ControlCharacterPHP2OOXML($textElement); |
|
120 | 120 | $objWriter->startElement('t'); |
121 | 121 | if ($textToWrite !== trim($textToWrite)) { |
122 | 122 | $objWriter->writeAttribute('xml:space', 'preserve'); |
@@ -147,7 +147,7 @@ discard block |
||
147 | 147 | * @param string $prefix Optional Namespace prefix |
148 | 148 | * @throws Exception |
149 | 149 | */ |
150 | - public function writeRichText(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix=NULL) |
|
150 | + public function writeRichText(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix = NULL) |
|
151 | 151 | { |
152 | 152 | if ($prefix !== NULL) |
153 | 153 | $prefix .= ':'; |
@@ -214,7 +214,7 @@ discard block |
||
214 | 214 | // t |
215 | 215 | $objWriter->startElement($prefix.'t'); |
216 | 216 | $objWriter->writeAttribute('xml:space', 'preserve'); |
217 | - $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $element->getText() )); |
|
217 | + $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($element->getText())); |
|
218 | 218 | $objWriter->endElement(); |
219 | 219 | |
220 | 220 | $objWriter->endElement(); |
@@ -229,7 +229,7 @@ discard block |
||
229 | 229 | * @param string $prefix Optional Namespace prefix |
230 | 230 | * @throws Exception |
231 | 231 | */ |
232 | - public function writeRichTextForCharts(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix=NULL) |
|
232 | + public function writeRichTextForCharts(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix = NULL) |
|
233 | 233 | { |
234 | 234 | if ($prefix !== NULL) |
235 | 235 | $prefix .= ':'; |
@@ -248,7 +248,7 @@ discard block |
||
248 | 248 | $objWriter->writeAttribute('i', ($element->getFont()->getItalic() ? 1 : 0)); |
249 | 249 | // Underline |
250 | 250 | $underlineType = $element->getFont()->getUnderline(); |
251 | - switch($underlineType) { |
|
251 | + switch ($underlineType) { |
|
252 | 252 | case 'single' : |
253 | 253 | $underlineType = 'sng'; |
254 | 254 | break; |
@@ -281,7 +281,7 @@ discard block |
||
281 | 281 | // t |
282 | 282 | $objWriter->startElement($prefix.'t'); |
283 | 283 | $objWriter->writeAttribute('xml:space', 'preserve'); |
284 | - $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $element->getText() )); |
|
284 | + $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($element->getText())); |
|
285 | 285 | $objWriter->endElement(); |
286 | 286 | |
287 | 287 | $objWriter->endElement(); |
@@ -300,7 +300,7 @@ discard block |
||
300 | 300 | |
301 | 301 | // Loop through stringtable and add flipped items to $returnValue |
302 | 302 | foreach ($stringTable as $key => $value) { |
303 | - if (! $value instanceof PHPExcel_RichText) { |
|
303 | + if ( ! $value instanceof PHPExcel_RichText) { |
|
304 | 304 | $returnValue[$value] = $key; |
305 | 305 | } else if ($value instanceof PHPExcel_RichText) { |
306 | 306 | $returnValue[$value->getHashCode()] = $key; |
@@ -149,8 +149,9 @@ discard block |
||
149 | 149 | */ |
150 | 150 | public function writeRichText(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix=NULL) |
151 | 151 | { |
152 | - if ($prefix !== NULL) |
|
153 | - $prefix .= ':'; |
|
152 | + if ($prefix !== NULL) { |
|
153 | + $prefix .= ':'; |
|
154 | + } |
|
154 | 155 | // Loop through rich text elements |
155 | 156 | $elements = $pRichText->getRichTextElements(); |
156 | 157 | foreach ($elements as $element) { |
@@ -231,8 +232,9 @@ discard block |
||
231 | 232 | */ |
232 | 233 | public function writeRichTextForCharts(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix=NULL) |
233 | 234 | { |
234 | - if ($prefix !== NULL) |
|
235 | - $prefix .= ':'; |
|
235 | + if ($prefix !== NULL) { |
|
236 | + $prefix .= ':'; |
|
237 | + } |
|
236 | 238 | // Loop through rich text elements |
237 | 239 | $elements = $pRichText->getRichTextElements(); |
238 | 240 | foreach ($elements as $element) { |
@@ -75,11 +75,11 @@ discard block |
||
75 | 75 | !isset($aFlippedStringTable[$cellValue->getHashCode()])) { |
76 | 76 | $aStringTable[] = $cellValue; |
77 | 77 | $aFlippedStringTable[$cellValue->getHashCode()] = true; |
78 | - } |
|
79 | - } |
|
78 | + } |
|
79 | + } |
|
80 | 80 | |
81 | - // Return |
|
82 | - return $aStringTable; |
|
81 | + // Return |
|
82 | + return $aStringTable; |
|
83 | 83 | } else { |
84 | 84 | throw new Exception("Invalid PHPExcel_Worksheet object passed."); |
85 | 85 | } |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | $this->writeRichText($objWriter, $textElement); |
128 | 128 | } |
129 | 129 | |
130 | - $objWriter->endElement(); |
|
130 | + $objWriter->endElement(); |
|
131 | 131 | } |
132 | 132 | |
133 | 133 | $objWriter->endElement(); |