PageRenderTime 52ms CodeModel.GetById 16ms RepoModel.GetById 1ms app.codeStats 0ms

/PHPExcel_1.7.8-with_documentation-msoffice_format/Classes/PHPExcel/Writer/Excel2007/Worksheet.php

https://bitbucket.org/izubizarreta/https-bitbucket.org-bityvip-alpes
PHP | 1215 lines | 723 code | 165 blank | 327 comment | 187 complexity | bd780bb9cd28c0fbe3e449692a9da926 MD5 | raw file
Possible License(s): GPL-2.0, BSD-3-Clause, LGPL-2.1, MIT, LGPL-3.0, LGPL-2.0, JSON
  1. <?php
  2. /**
  3. * PHPExcel
  4. *
  5. * Copyright (c) 2006 - 2012 PHPExcel
  6. *
  7. * This library is free software; you can redistribute it and/or
  8. * modify it under the terms of the GNU Lesser General Public
  9. * License as published by the Free Software Foundation; either
  10. * version 2.1 of the License, or (at your option) any later version.
  11. *
  12. * This library is distributed in the hope that it will be useful,
  13. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
  15. * Lesser General Public License for more details.
  16. *
  17. * You should have received a copy of the GNU Lesser General Public
  18. * License along with this library; if not, write to the Free Software
  19. * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
  20. *
  21. * @category PHPExcel
  22. * @package PHPExcel_Writer_Excel2007
  23. * @copyright Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
  24. * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
  25. * @version 1.7.8, 2012-10-12
  26. */
  27. /**
  28. * PHPExcel_Writer_Excel2007_Worksheet
  29. *
  30. * @category PHPExcel
  31. * @package PHPExcel_Writer_Excel2007
  32. * @copyright Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
  33. */
  34. class PHPExcel_Writer_Excel2007_Worksheet extends PHPExcel_Writer_Excel2007_WriterPart
  35. {
  36. /**
  37. * Write worksheet to XML format
  38. *
  39. * @param PHPExcel_Worksheet $pSheet
  40. * @param string[] $pStringTable
  41. * @param boolean $includeCharts Flag indicating if we should write charts
  42. * @return string XML Output
  43. * @throws Exception
  44. */
  45. public function writeWorksheet($pSheet = null, $pStringTable = null, $includeCharts = FALSE)
  46. {
  47. if (!is_null($pSheet)) {
  48. // Create XML writer
  49. $objWriter = null;
  50. if ($this->getParentWriter()->getUseDiskCaching()) {
  51. $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
  52. } else {
  53. $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
  54. }
  55. // XML header
  56. $objWriter->startDocument('1.0','UTF-8','yes');
  57. // Worksheet
  58. $objWriter->startElement('worksheet');
  59. $objWriter->writeAttribute('xml:space', 'preserve');
  60. $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');
  61. $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
  62. // sheetPr
  63. $this->_writeSheetPr($objWriter, $pSheet);
  64. // Dimension
  65. $this->_writeDimension($objWriter, $pSheet);
  66. // sheetViews
  67. $this->_writeSheetViews($objWriter, $pSheet);
  68. // sheetFormatPr
  69. $this->_writeSheetFormatPr($objWriter, $pSheet);
  70. // cols
  71. $this->_writeCols($objWriter, $pSheet);
  72. // sheetData
  73. $this->_writeSheetData($objWriter, $pSheet, $pStringTable);
  74. // sheetProtection
  75. $this->_writeSheetProtection($objWriter, $pSheet);
  76. // protectedRanges
  77. $this->_writeProtectedRanges($objWriter, $pSheet);
  78. // autoFilter
  79. $this->_writeAutoFilter($objWriter, $pSheet);
  80. // mergeCells
  81. $this->_writeMergeCells($objWriter, $pSheet);
  82. // conditionalFormatting
  83. $this->_writeConditionalFormatting($objWriter, $pSheet);
  84. // dataValidations
  85. $this->_writeDataValidations($objWriter, $pSheet);
  86. // hyperlinks
  87. $this->_writeHyperlinks($objWriter, $pSheet);
  88. // Print options
  89. $this->_writePrintOptions($objWriter, $pSheet);
  90. // Page margins
  91. $this->_writePageMargins($objWriter, $pSheet);
  92. // Page setup
  93. $this->_writePageSetup($objWriter, $pSheet);
  94. // Header / footer
  95. $this->_writeHeaderFooter($objWriter, $pSheet);
  96. // Breaks
  97. $this->_writeBreaks($objWriter, $pSheet);
  98. // Drawings and/or Charts
  99. $this->_writeDrawings($objWriter, $pSheet, $includeCharts);
  100. // LegacyDrawing
  101. $this->_writeLegacyDrawing($objWriter, $pSheet);
  102. // LegacyDrawingHF
  103. $this->_writeLegacyDrawingHF($objWriter, $pSheet);
  104. $objWriter->endElement();
  105. // Return
  106. return $objWriter->getData();
  107. } else {
  108. throw new Exception("Invalid PHPExcel_Worksheet object passed.");
  109. }
  110. }
  111. /**
  112. * Write SheetPr
  113. *
  114. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  115. * @param PHPExcel_Worksheet $pSheet Worksheet
  116. * @throws Exception
  117. */
  118. private function _writeSheetPr(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  119. {
  120. // sheetPr
  121. $objWriter->startElement('sheetPr');
  122. //$objWriter->writeAttribute('codeName', $pSheet->getTitle());
  123. $autoFilterRange = $pSheet->getAutoFilter()->getRange();
  124. if (!empty($autoFilterRange)) {
  125. $objWriter->writeAttribute('filterMode', 1);
  126. $pSheet->getAutoFilter()->showHideRows();
  127. }
  128. // tabColor
  129. if ($pSheet->isTabColorSet()) {
  130. $objWriter->startElement('tabColor');
  131. $objWriter->writeAttribute('rgb', $pSheet->getTabColor()->getARGB());
  132. $objWriter->endElement();
  133. }
  134. // outlinePr
  135. $objWriter->startElement('outlinePr');
  136. $objWriter->writeAttribute('summaryBelow', ($pSheet->getShowSummaryBelow() ? '1' : '0'));
  137. $objWriter->writeAttribute('summaryRight', ($pSheet->getShowSummaryRight() ? '1' : '0'));
  138. $objWriter->endElement();
  139. // pageSetUpPr
  140. if ($pSheet->getPageSetup()->getFitToPage()) {
  141. $objWriter->startElement('pageSetUpPr');
  142. $objWriter->writeAttribute('fitToPage', '1');
  143. $objWriter->endElement();
  144. }
  145. $objWriter->endElement();
  146. }
  147. /**
  148. * Write Dimension
  149. *
  150. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  151. * @param PHPExcel_Worksheet $pSheet Worksheet
  152. * @throws Exception
  153. */
  154. private function _writeDimension(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  155. {
  156. // dimension
  157. $objWriter->startElement('dimension');
  158. $objWriter->writeAttribute('ref', $pSheet->calculateWorksheetDimension());
  159. $objWriter->endElement();
  160. }
  161. /**
  162. * Write SheetViews
  163. *
  164. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  165. * @param PHPExcel_Worksheet $pSheet Worksheet
  166. * @throws Exception
  167. */
  168. private function _writeSheetViews(PHPExcel_Shared_XMLWriter $objWriter = NULL, PHPExcel_Worksheet $pSheet = NULL)
  169. {
  170. // sheetViews
  171. $objWriter->startElement('sheetViews');
  172. // Sheet selected?
  173. $sheetSelected = false;
  174. if ($this->getParentWriter()->getPHPExcel()->getIndex($pSheet) == $this->getParentWriter()->getPHPExcel()->getActiveSheetIndex())
  175. $sheetSelected = true;
  176. // sheetView
  177. $objWriter->startElement('sheetView');
  178. $objWriter->writeAttribute('tabSelected', $sheetSelected ? '1' : '0');
  179. $objWriter->writeAttribute('workbookViewId', '0');
  180. // Zoom scales
  181. if ($pSheet->getSheetView()->getZoomScale() != 100) {
  182. $objWriter->writeAttribute('zoomScale', $pSheet->getSheetView()->getZoomScale());
  183. }
  184. if ($pSheet->getSheetView()->getZoomScaleNormal() != 100) {
  185. $objWriter->writeAttribute('zoomScaleNormal', $pSheet->getSheetView()->getZoomScaleNormal());
  186. }
  187. // View Layout Type
  188. if ($pSheet->getSheetView()->getView() !== PHPExcel_Worksheet_SheetView::SHEETVIEW_NORMAL) {
  189. $objWriter->writeAttribute('view', $pSheet->getSheetView()->getView());
  190. }
  191. // Gridlines
  192. if ($pSheet->getShowGridlines()) {
  193. $objWriter->writeAttribute('showGridLines', 'true');
  194. } else {
  195. $objWriter->writeAttribute('showGridLines', 'false');
  196. }
  197. // Row and column headers
  198. if ($pSheet->getShowRowColHeaders()) {
  199. $objWriter->writeAttribute('showRowColHeaders', '1');
  200. } else {
  201. $objWriter->writeAttribute('showRowColHeaders', '0');
  202. }
  203. // Right-to-left
  204. if ($pSheet->getRightToLeft()) {
  205. $objWriter->writeAttribute('rightToLeft', 'true');
  206. }
  207. $activeCell = $pSheet->getActiveCell();
  208. // Pane
  209. $pane = '';
  210. $topLeftCell = $pSheet->getFreezePane();
  211. if (($topLeftCell != '') && ($topLeftCell != 'A1')) {
  212. $activeCell = $topLeftCell;
  213. // Calculate freeze coordinates
  214. $xSplit = $ySplit = 0;
  215. list($xSplit, $ySplit) = PHPExcel_Cell::coordinateFromString($topLeftCell);
  216. $xSplit = PHPExcel_Cell::columnIndexFromString($xSplit);
  217. // pane
  218. $pane = 'topRight';
  219. $objWriter->startElement('pane');
  220. if ($xSplit > 1)
  221. $objWriter->writeAttribute('xSplit', $xSplit - 1);
  222. if ($ySplit > 1) {
  223. $objWriter->writeAttribute('ySplit', $ySplit - 1);
  224. $pane = ($xSplit > 1) ? 'bottomRight' : 'bottomLeft';
  225. }
  226. $objWriter->writeAttribute('topLeftCell', $topLeftCell);
  227. $objWriter->writeAttribute('activePane', $pane);
  228. $objWriter->writeAttribute('state', 'frozen');
  229. $objWriter->endElement();
  230. if (($xSplit > 1) && ($ySplit > 1)) {
  231. // Write additional selections if more than two panes (ie both an X and a Y split)
  232. $objWriter->startElement('selection'); $objWriter->writeAttribute('pane', 'topRight'); $objWriter->endElement();
  233. $objWriter->startElement('selection'); $objWriter->writeAttribute('pane', 'bottomLeft'); $objWriter->endElement();
  234. }
  235. }
  236. // Selection
  237. // if ($pane != '') {
  238. // Only need to write selection element if we have a split pane
  239. // We cheat a little by over-riding the active cell selection, setting it to the split cell
  240. $objWriter->startElement('selection');
  241. if ($pane != '') {
  242. $objWriter->writeAttribute('pane', $pane);
  243. }
  244. $objWriter->writeAttribute('activeCell', $activeCell);
  245. $objWriter->writeAttribute('sqref', $activeCell);
  246. $objWriter->endElement();
  247. // }
  248. $objWriter->endElement();
  249. $objWriter->endElement();
  250. }
  251. /**
  252. * Write SheetFormatPr
  253. *
  254. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  255. * @param PHPExcel_Worksheet $pSheet Worksheet
  256. * @throws Exception
  257. */
  258. private function _writeSheetFormatPr(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  259. {
  260. // sheetFormatPr
  261. $objWriter->startElement('sheetFormatPr');
  262. // Default row height
  263. if ($pSheet->getDefaultRowDimension()->getRowHeight() >= 0) {
  264. $objWriter->writeAttribute('customHeight', 'true');
  265. $objWriter->writeAttribute('defaultRowHeight', PHPExcel_Shared_String::FormatNumber($pSheet->getDefaultRowDimension()->getRowHeight()));
  266. } else {
  267. $objWriter->writeAttribute('defaultRowHeight', '14.4');
  268. }
  269. // Set Zero Height row
  270. if ((string)$pSheet->getDefaultRowDimension()->getzeroHeight() == '1' ||
  271. strtolower((string)$pSheet->getDefaultRowDimension()->getzeroHeight()) == 'true' ) {
  272. $objWriter->writeAttribute('zeroHeight', '1');
  273. }
  274. // Default column width
  275. if ($pSheet->getDefaultColumnDimension()->getWidth() >= 0) {
  276. $objWriter->writeAttribute('defaultColWidth', PHPExcel_Shared_String::FormatNumber($pSheet->getDefaultColumnDimension()->getWidth()));
  277. }
  278. // Outline level - row
  279. $outlineLevelRow = 0;
  280. foreach ($pSheet->getRowDimensions() as $dimension) {
  281. if ($dimension->getOutlineLevel() > $outlineLevelRow) {
  282. $outlineLevelRow = $dimension->getOutlineLevel();
  283. }
  284. }
  285. $objWriter->writeAttribute('outlineLevelRow', (int)$outlineLevelRow);
  286. // Outline level - column
  287. $outlineLevelCol = 0;
  288. foreach ($pSheet->getColumnDimensions() as $dimension) {
  289. if ($dimension->getOutlineLevel() > $outlineLevelCol) {
  290. $outlineLevelCol = $dimension->getOutlineLevel();
  291. }
  292. }
  293. $objWriter->writeAttribute('outlineLevelCol', (int)$outlineLevelCol);
  294. $objWriter->endElement();
  295. }
  296. /**
  297. * Write Cols
  298. *
  299. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  300. * @param PHPExcel_Worksheet $pSheet Worksheet
  301. * @throws Exception
  302. */
  303. private function _writeCols(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  304. {
  305. // cols
  306. if (count($pSheet->getColumnDimensions()) > 0) {
  307. $objWriter->startElement('cols');
  308. $pSheet->calculateColumnWidths();
  309. // Loop through column dimensions
  310. foreach ($pSheet->getColumnDimensions() as $colDimension) {
  311. // col
  312. $objWriter->startElement('col');
  313. $objWriter->writeAttribute('min', PHPExcel_Cell::columnIndexFromString($colDimension->getColumnIndex()));
  314. $objWriter->writeAttribute('max', PHPExcel_Cell::columnIndexFromString($colDimension->getColumnIndex()));
  315. if ($colDimension->getWidth() < 0) {
  316. // No width set, apply default of 10
  317. $objWriter->writeAttribute('width', '9.10');
  318. } else {
  319. // Width set
  320. $objWriter->writeAttribute('width', PHPExcel_Shared_String::FormatNumber($colDimension->getWidth()));
  321. }
  322. // Column visibility
  323. if ($colDimension->getVisible() == false) {
  324. $objWriter->writeAttribute('hidden', 'true');
  325. }
  326. // Auto size?
  327. if ($colDimension->getAutoSize()) {
  328. $objWriter->writeAttribute('bestFit', 'true');
  329. }
  330. // Custom width?
  331. if ($colDimension->getWidth() != $pSheet->getDefaultColumnDimension()->getWidth()) {
  332. $objWriter->writeAttribute('customWidth', 'true');
  333. }
  334. // Collapsed
  335. if ($colDimension->getCollapsed() == true) {
  336. $objWriter->writeAttribute('collapsed', 'true');
  337. }
  338. // Outline level
  339. if ($colDimension->getOutlineLevel() > 0) {
  340. $objWriter->writeAttribute('outlineLevel', $colDimension->getOutlineLevel());
  341. }
  342. // Style
  343. $objWriter->writeAttribute('style', $colDimension->getXfIndex());
  344. $objWriter->endElement();
  345. }
  346. $objWriter->endElement();
  347. }
  348. }
  349. /**
  350. * Write SheetProtection
  351. *
  352. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  353. * @param PHPExcel_Worksheet $pSheet Worksheet
  354. * @throws Exception
  355. */
  356. private function _writeSheetProtection(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  357. {
  358. // sheetProtection
  359. $objWriter->startElement('sheetProtection');
  360. if ($pSheet->getProtection()->getPassword() != '') {
  361. $objWriter->writeAttribute('password', $pSheet->getProtection()->getPassword());
  362. }
  363. $objWriter->writeAttribute('sheet', ($pSheet->getProtection()->getSheet() ? 'true' : 'false'));
  364. $objWriter->writeAttribute('objects', ($pSheet->getProtection()->getObjects() ? 'true' : 'false'));
  365. $objWriter->writeAttribute('scenarios', ($pSheet->getProtection()->getScenarios() ? 'true' : 'false'));
  366. $objWriter->writeAttribute('formatCells', ($pSheet->getProtection()->getFormatCells() ? 'true' : 'false'));
  367. $objWriter->writeAttribute('formatColumns', ($pSheet->getProtection()->getFormatColumns() ? 'true' : 'false'));
  368. $objWriter->writeAttribute('formatRows', ($pSheet->getProtection()->getFormatRows() ? 'true' : 'false'));
  369. $objWriter->writeAttribute('insertColumns', ($pSheet->getProtection()->getInsertColumns() ? 'true' : 'false'));
  370. $objWriter->writeAttribute('insertRows', ($pSheet->getProtection()->getInsertRows() ? 'true' : 'false'));
  371. $objWriter->writeAttribute('insertHyperlinks', ($pSheet->getProtection()->getInsertHyperlinks() ? 'true' : 'false'));
  372. $objWriter->writeAttribute('deleteColumns', ($pSheet->getProtection()->getDeleteColumns() ? 'true' : 'false'));
  373. $objWriter->writeAttribute('deleteRows', ($pSheet->getProtection()->getDeleteRows() ? 'true' : 'false'));
  374. $objWriter->writeAttribute('selectLockedCells', ($pSheet->getProtection()->getSelectLockedCells() ? 'true' : 'false'));
  375. $objWriter->writeAttribute('sort', ($pSheet->getProtection()->getSort() ? 'true' : 'false'));
  376. $objWriter->writeAttribute('autoFilter', ($pSheet->getProtection()->getAutoFilter() ? 'true' : 'false'));
  377. $objWriter->writeAttribute('pivotTables', ($pSheet->getProtection()->getPivotTables() ? 'true' : 'false'));
  378. $objWriter->writeAttribute('selectUnlockedCells', ($pSheet->getProtection()->getSelectUnlockedCells() ? 'true' : 'false'));
  379. $objWriter->endElement();
  380. }
  381. /**
  382. * Write ConditionalFormatting
  383. *
  384. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  385. * @param PHPExcel_Worksheet $pSheet Worksheet
  386. * @throws Exception
  387. */
  388. private function _writeConditionalFormatting(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  389. {
  390. // Conditional id
  391. $id = 1;
  392. // Loop through styles in the current worksheet
  393. foreach ($pSheet->getConditionalStylesCollection() as $cellCoordinate => $conditionalStyles) {
  394. foreach ($conditionalStyles as $conditional) {
  395. // WHY was this again?
  396. // if ($this->getParentWriter()->getStylesConditionalHashTable()->getIndexForHashCode( $conditional->getHashCode() ) == '') {
  397. // continue;
  398. // }
  399. if ($conditional->getConditionType() != PHPExcel_Style_Conditional::CONDITION_NONE) {
  400. // conditionalFormatting
  401. $objWriter->startElement('conditionalFormatting');
  402. $objWriter->writeAttribute('sqref', $cellCoordinate);
  403. // cfRule
  404. $objWriter->startElement('cfRule');
  405. $objWriter->writeAttribute('type', $conditional->getConditionType());
  406. $objWriter->writeAttribute('dxfId', $this->getParentWriter()->getStylesConditionalHashTable()->getIndexForHashCode( $conditional->getHashCode() ));
  407. $objWriter->writeAttribute('priority', $id++);
  408. if (($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CELLIS
  409. ||
  410. $conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT)
  411. && $conditional->getOperatorType() != PHPExcel_Style_Conditional::OPERATOR_NONE) {
  412. $objWriter->writeAttribute('operator', $conditional->getOperatorType());
  413. }
  414. if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
  415. && !is_null($conditional->getText())) {
  416. $objWriter->writeAttribute('text', $conditional->getText());
  417. }
  418. if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
  419. && $conditional->getOperatorType() == PHPExcel_Style_Conditional::OPERATOR_CONTAINSTEXT
  420. && !is_null($conditional->getText())) {
  421. $objWriter->writeElement('formula', 'NOT(ISERROR(SEARCH("' . $conditional->getText() . '",' . $cellCoordinate . ')))');
  422. } else if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
  423. && $conditional->getOperatorType() == PHPExcel_Style_Conditional::OPERATOR_BEGINSWITH
  424. && !is_null($conditional->getText())) {
  425. $objWriter->writeElement('formula', 'LEFT(' . $cellCoordinate . ',' . strlen($conditional->getText()) . ')="' . $conditional->getText() . '"');
  426. } else if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
  427. && $conditional->getOperatorType() == PHPExcel_Style_Conditional::OPERATOR_ENDSWITH
  428. && !is_null($conditional->getText())) {
  429. $objWriter->writeElement('formula', 'RIGHT(' . $cellCoordinate . ',' . strlen($conditional->getText()) . ')="' . $conditional->getText() . '"');
  430. } else if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
  431. && $conditional->getOperatorType() == PHPExcel_Style_Conditional::OPERATOR_NOTCONTAINS
  432. && !is_null($conditional->getText())) {
  433. $objWriter->writeElement('formula', 'ISERROR(SEARCH("' . $conditional->getText() . '",' . $cellCoordinate . '))');
  434. } else if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CELLIS
  435. || $conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
  436. || $conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_EXPRESSION) {
  437. foreach ($conditional->getConditions() as $formula) {
  438. // Formula
  439. $objWriter->writeElement('formula', $formula);
  440. }
  441. }
  442. $objWriter->endElement();
  443. $objWriter->endElement();
  444. }
  445. }
  446. }
  447. }
  448. /**
  449. * Write DataValidations
  450. *
  451. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  452. * @param PHPExcel_Worksheet $pSheet Worksheet
  453. * @throws Exception
  454. */
  455. private function _writeDataValidations(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  456. {
  457. // Datavalidation collection
  458. $dataValidationCollection = $pSheet->getDataValidationCollection();
  459. // Write data validations?
  460. if (!empty($dataValidationCollection)) {
  461. $objWriter->startElement('dataValidations');
  462. $objWriter->writeAttribute('count', count($dataValidationCollection));
  463. foreach ($dataValidationCollection as $coordinate => $dv) {
  464. $objWriter->startElement('dataValidation');
  465. if ($dv->getType() != '') {
  466. $objWriter->writeAttribute('type', $dv->getType());
  467. }
  468. if ($dv->getErrorStyle() != '') {
  469. $objWriter->writeAttribute('errorStyle', $dv->getErrorStyle());
  470. }
  471. if ($dv->getOperator() != '') {
  472. $objWriter->writeAttribute('operator', $dv->getOperator());
  473. }
  474. $objWriter->writeAttribute('allowBlank', ($dv->getAllowBlank() ? '1' : '0'));
  475. $objWriter->writeAttribute('showDropDown', (!$dv->getShowDropDown() ? '1' : '0'));
  476. $objWriter->writeAttribute('showInputMessage', ($dv->getShowInputMessage() ? '1' : '0'));
  477. $objWriter->writeAttribute('showErrorMessage', ($dv->getShowErrorMessage() ? '1' : '0'));
  478. if ($dv->getErrorTitle() !== '') {
  479. $objWriter->writeAttribute('errorTitle', $dv->getErrorTitle());
  480. }
  481. if ($dv->getError() !== '') {
  482. $objWriter->writeAttribute('error', $dv->getError());
  483. }
  484. if ($dv->getPromptTitle() !== '') {
  485. $objWriter->writeAttribute('promptTitle', $dv->getPromptTitle());
  486. }
  487. if ($dv->getPrompt() !== '') {
  488. $objWriter->writeAttribute('prompt', $dv->getPrompt());
  489. }
  490. $objWriter->writeAttribute('sqref', $coordinate);
  491. if ($dv->getFormula1() !== '') {
  492. $objWriter->writeElement('formula1', $dv->getFormula1());
  493. }
  494. if ($dv->getFormula2() !== '') {
  495. $objWriter->writeElement('formula2', $dv->getFormula2());
  496. }
  497. $objWriter->endElement();
  498. }
  499. $objWriter->endElement();
  500. }
  501. }
  502. /**
  503. * Write Hyperlinks
  504. *
  505. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  506. * @param PHPExcel_Worksheet $pSheet Worksheet
  507. * @throws Exception
  508. */
  509. private function _writeHyperlinks(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  510. {
  511. // Hyperlink collection
  512. $hyperlinkCollection = $pSheet->getHyperlinkCollection();
  513. // Relation ID
  514. $relationId = 1;
  515. // Write hyperlinks?
  516. if (!empty($hyperlinkCollection)) {
  517. $objWriter->startElement('hyperlinks');
  518. foreach ($hyperlinkCollection as $coordinate => $hyperlink) {
  519. $objWriter->startElement('hyperlink');
  520. $objWriter->writeAttribute('ref', $coordinate);
  521. if (!$hyperlink->isInternal()) {
  522. $objWriter->writeAttribute('r:id', 'rId_hyperlink_' . $relationId);
  523. ++$relationId;
  524. } else {
  525. $objWriter->writeAttribute('location', str_replace('sheet://', '', $hyperlink->getUrl()));
  526. }
  527. if ($hyperlink->getTooltip() != '') {
  528. $objWriter->writeAttribute('tooltip', $hyperlink->getTooltip());
  529. }
  530. $objWriter->endElement();
  531. }
  532. $objWriter->endElement();
  533. }
  534. }
  535. /**
  536. * Write ProtectedRanges
  537. *
  538. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  539. * @param PHPExcel_Worksheet $pSheet Worksheet
  540. * @throws Exception
  541. */
  542. private function _writeProtectedRanges(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  543. {
  544. if (count($pSheet->getProtectedCells()) > 0) {
  545. // protectedRanges
  546. $objWriter->startElement('protectedRanges');
  547. // Loop protectedRanges
  548. foreach ($pSheet->getProtectedCells() as $protectedCell => $passwordHash) {
  549. // protectedRange
  550. $objWriter->startElement('protectedRange');
  551. $objWriter->writeAttribute('name', 'p' . md5($protectedCell));
  552. $objWriter->writeAttribute('sqref', $protectedCell);
  553. $objWriter->writeAttribute('password', $passwordHash);
  554. $objWriter->endElement();
  555. }
  556. $objWriter->endElement();
  557. }
  558. }
  559. /**
  560. * Write MergeCells
  561. *
  562. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  563. * @param PHPExcel_Worksheet $pSheet Worksheet
  564. * @throws Exception
  565. */
  566. private function _writeMergeCells(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  567. {
  568. if (count($pSheet->getMergeCells()) > 0) {
  569. // mergeCells
  570. $objWriter->startElement('mergeCells');
  571. // Loop mergeCells
  572. foreach ($pSheet->getMergeCells() as $mergeCell) {
  573. // mergeCell
  574. $objWriter->startElement('mergeCell');
  575. $objWriter->writeAttribute('ref', $mergeCell);
  576. $objWriter->endElement();
  577. }
  578. $objWriter->endElement();
  579. }
  580. }
  581. /**
  582. * Write PrintOptions
  583. *
  584. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  585. * @param PHPExcel_Worksheet $pSheet Worksheet
  586. * @throws Exception
  587. */
  588. private function _writePrintOptions(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  589. {
  590. // printOptions
  591. $objWriter->startElement('printOptions');
  592. $objWriter->writeAttribute('gridLines', ($pSheet->getPrintGridlines() ? 'true': 'false'));
  593. $objWriter->writeAttribute('gridLinesSet', 'true');
  594. if ($pSheet->getPageSetup()->getHorizontalCentered()) {
  595. $objWriter->writeAttribute('horizontalCentered', 'true');
  596. }
  597. if ($pSheet->getPageSetup()->getVerticalCentered()) {
  598. $objWriter->writeAttribute('verticalCentered', 'true');
  599. }
  600. $objWriter->endElement();
  601. }
  602. /**
  603. * Write PageMargins
  604. *
  605. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  606. * @param PHPExcel_Worksheet $pSheet Worksheet
  607. * @throws Exception
  608. */
  609. private function _writePageMargins(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  610. {
  611. // pageMargins
  612. $objWriter->startElement('pageMargins');
  613. $objWriter->writeAttribute('left', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getLeft()));
  614. $objWriter->writeAttribute('right', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getRight()));
  615. $objWriter->writeAttribute('top', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getTop()));
  616. $objWriter->writeAttribute('bottom', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getBottom()));
  617. $objWriter->writeAttribute('header', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getHeader()));
  618. $objWriter->writeAttribute('footer', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getFooter()));
  619. $objWriter->endElement();
  620. }
  621. /**
  622. * Write AutoFilter
  623. *
  624. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  625. * @param PHPExcel_Worksheet $pSheet Worksheet
  626. * @throws Exception
  627. */
  628. private function _writeAutoFilter(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  629. {
  630. $autoFilterRange = $pSheet->getAutoFilter()->getRange();
  631. if (!empty($autoFilterRange)) {
  632. // autoFilter
  633. $objWriter->startElement('autoFilter');
  634. // Strip any worksheet reference from the filter coordinates
  635. $range = PHPExcel_Cell::splitRange($autoFilterRange);
  636. $range = $range[0];
  637. // Strip any worksheet ref
  638. if (strpos($range[0],'!') !== false) {
  639. list($ws,$range[0]) = explode('!',$range[0]);
  640. }
  641. $range = implode(':', $range);
  642. $objWriter->writeAttribute('ref', str_replace('$','',$range));
  643. $columns = $pSheet->getAutoFilter()->getColumns();
  644. if (count($columns > 0)) {
  645. foreach($columns as $columnID => $column) {
  646. $rules = $column->getRules();
  647. if (count($rules > 0)) {
  648. $objWriter->startElement('filterColumn');
  649. $objWriter->writeAttribute('colId', $pSheet->getAutoFilter()->getColumnOffset($columnID));
  650. $objWriter->startElement( $column->getFilterType());
  651. if ($column->getJoin() == PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_COLUMN_JOIN_AND) {
  652. $objWriter->writeAttribute('and', 1);
  653. }
  654. foreach ($rules as $rule) {
  655. if (($column->getFilterType() === PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_FILTERTYPE_FILTER) &&
  656. ($rule->getOperator() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_EQUAL) &&
  657. ($rule->getValue() === '')) {
  658. // Filter rule for Blanks
  659. $objWriter->writeAttribute('blank', 1);
  660. } elseif($rule->getRuleType() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMICFILTER) {
  661. // Dynamic Filter Rule
  662. $objWriter->writeAttribute('type', $rule->getGrouping());
  663. $val = $column->getAttribute('val');
  664. if ($val !== NULL) {
  665. $objWriter->writeAttribute('val', $val);
  666. }
  667. $maxVal = $column->getAttribute('maxVal');
  668. if ($maxVal !== NULL) {
  669. $objWriter->writeAttribute('maxVal', $maxVal);
  670. }
  671. } elseif($rule->getRuleType() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_TOPTENFILTER) {
  672. // Top 10 Filter Rule
  673. $objWriter->writeAttribute('val', $rule->getValue());
  674. $objWriter->writeAttribute('percent', (($rule->getOperator() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT) ? '1' : '0'));
  675. $objWriter->writeAttribute('top', (($rule->getGrouping() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_TOPTEN_TOP) ? '1': '0'));
  676. } else {
  677. // Filter, DateGroupItem or CustomFilter
  678. $objWriter->startElement($rule->getRuleType());
  679. if ($rule->getOperator() !== PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_EQUAL) {
  680. $objWriter->writeAttribute('operator', $rule->getOperator());
  681. }
  682. if ($rule->getRuleType() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DATEGROUP) {
  683. // Date Group filters
  684. foreach($rule->getValue() as $key => $value) {
  685. if ($value > '') $objWriter->writeAttribute($key, $value);
  686. }
  687. $objWriter->writeAttribute('dateTimeGrouping', $rule->getGrouping());
  688. } else {
  689. $objWriter->writeAttribute('val', $rule->getValue());
  690. }
  691. $objWriter->endElement();
  692. }
  693. }
  694. $objWriter->endElement();
  695. $objWriter->endElement();
  696. }
  697. }
  698. }
  699. $objWriter->endElement();
  700. }
  701. }
  702. /**
  703. * Write PageSetup
  704. *
  705. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  706. * @param PHPExcel_Worksheet $pSheet Worksheet
  707. * @throws Exception
  708. */
  709. private function _writePageSetup(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  710. {
  711. // pageSetup
  712. $objWriter->startElement('pageSetup');
  713. $objWriter->writeAttribute('paperSize', $pSheet->getPageSetup()->getPaperSize());
  714. $objWriter->writeAttribute('orientation', $pSheet->getPageSetup()->getOrientation());
  715. if (!is_null($pSheet->getPageSetup()->getScale())) {
  716. $objWriter->writeAttribute('scale', $pSheet->getPageSetup()->getScale());
  717. }
  718. if (!is_null($pSheet->getPageSetup()->getFitToHeight())) {
  719. $objWriter->writeAttribute('fitToHeight', $pSheet->getPageSetup()->getFitToHeight());
  720. } else {
  721. $objWriter->writeAttribute('fitToHeight', '0');
  722. }
  723. if (!is_null($pSheet->getPageSetup()->getFitToWidth())) {
  724. $objWriter->writeAttribute('fitToWidth', $pSheet->getPageSetup()->getFitToWidth());
  725. } else {
  726. $objWriter->writeAttribute('fitToWidth', '0');
  727. }
  728. if (!is_null($pSheet->getPageSetup()->getFirstPageNumber())) {
  729. $objWriter->writeAttribute('firstPageNumber', $pSheet->getPageSetup()->getFirstPageNumber());
  730. $objWriter->writeAttribute('useFirstPageNumber', '1');
  731. }
  732. $objWriter->endElement();
  733. }
  734. /**
  735. * Write Header / Footer
  736. *
  737. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  738. * @param PHPExcel_Worksheet $pSheet Worksheet
  739. * @throws Exception
  740. */
  741. private function _writeHeaderFooter(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  742. {
  743. // headerFooter
  744. $objWriter->startElement('headerFooter');
  745. $objWriter->writeAttribute('differentOddEven', ($pSheet->getHeaderFooter()->getDifferentOddEven() ? 'true' : 'false'));
  746. $objWriter->writeAttribute('differentFirst', ($pSheet->getHeaderFooter()->getDifferentFirst() ? 'true' : 'false'));
  747. $objWriter->writeAttribute('scaleWithDoc', ($pSheet->getHeaderFooter()->getScaleWithDocument() ? 'true' : 'false'));
  748. $objWriter->writeAttribute('alignWithMargins', ($pSheet->getHeaderFooter()->getAlignWithMargins() ? 'true' : 'false'));
  749. $objWriter->writeElement('oddHeader', $pSheet->getHeaderFooter()->getOddHeader());
  750. $objWriter->writeElement('oddFooter', $pSheet->getHeaderFooter()->getOddFooter());
  751. $objWriter->writeElement('evenHeader', $pSheet->getHeaderFooter()->getEvenHeader());
  752. $objWriter->writeElement('evenFooter', $pSheet->getHeaderFooter()->getEvenFooter());
  753. $objWriter->writeElement('firstHeader', $pSheet->getHeaderFooter()->getFirstHeader());
  754. $objWriter->writeElement('firstFooter', $pSheet->getHeaderFooter()->getFirstFooter());
  755. $objWriter->endElement();
  756. }
  757. /**
  758. * Write Breaks
  759. *
  760. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  761. * @param PHPExcel_Worksheet $pSheet Worksheet
  762. * @throws Exception
  763. */
  764. private function _writeBreaks(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  765. {
  766. // Get row and column breaks
  767. $aRowBreaks = array();
  768. $aColumnBreaks = array();
  769. foreach ($pSheet->getBreaks() as $cell => $breakType) {
  770. if ($breakType == PHPExcel_Worksheet::BREAK_ROW) {
  771. $aRowBreaks[] = $cell;
  772. } else if ($breakType == PHPExcel_Worksheet::BREAK_COLUMN) {
  773. $aColumnBreaks[] = $cell;
  774. }
  775. }
  776. // rowBreaks
  777. if (!empty($aRowBreaks)) {
  778. $objWriter->startElement('rowBreaks');
  779. $objWriter->writeAttribute('count', count($aRowBreaks));
  780. $objWriter->writeAttribute('manualBreakCount', count($aRowBreaks));
  781. foreach ($aRowBreaks as $cell) {
  782. $coords = PHPExcel_Cell::coordinateFromString($cell);
  783. $objWriter->startElement('brk');
  784. $objWriter->writeAttribute('id', $coords[1]);
  785. $objWriter->writeAttribute('man', '1');
  786. $objWriter->endElement();
  787. }
  788. $objWriter->endElement();
  789. }
  790. // Second, write column breaks
  791. if (!empty($aColumnBreaks)) {
  792. $objWriter->startElement('colBreaks');
  793. $objWriter->writeAttribute('count', count($aColumnBreaks));
  794. $objWriter->writeAttribute('manualBreakCount', count($aColumnBreaks));
  795. foreach ($aColumnBreaks as $cell) {
  796. $coords = PHPExcel_Cell::coordinateFromString($cell);
  797. $objWriter->startElement('brk');
  798. $objWriter->writeAttribute('id', PHPExcel_Cell::columnIndexFromString($coords[0]) - 1);
  799. $objWriter->writeAttribute('man', '1');
  800. $objWriter->endElement();
  801. }
  802. $objWriter->endElement();
  803. }
  804. }
  805. /**
  806. * Write SheetData
  807. *
  808. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  809. * @param PHPExcel_Worksheet $pSheet Worksheet
  810. * @param string[] $pStringTable String table
  811. * @throws Exception
  812. */
  813. private function _writeSheetData(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $pStringTable = null)
  814. {
  815. if (is_array($pStringTable)) {
  816. // Flipped stringtable, for faster index searching
  817. $aFlippedStringTable = $this->getParentWriter()->getWriterPart('stringtable')->flipStringTable($pStringTable);
  818. // sheetData
  819. $objWriter->startElement('sheetData');
  820. // Get column count
  821. $colCount = PHPExcel_Cell::columnIndexFromString($pSheet->getHighestColumn());
  822. // Highest row number
  823. $highestRow = $pSheet->getHighestRow();
  824. // Loop through cells
  825. $cellsByRow = array();
  826. foreach ($pSheet->getCellCollection() as $cellID) {
  827. $cellAddress = PHPExcel_Cell::coordinateFromString($cellID);
  828. $cellsByRow[$cellAddress[1]][] = $cellID;
  829. }
  830. $currentRow = 0;
  831. while($currentRow++ < $highestRow) {
  832. // Get row dimension
  833. $rowDimension = $pSheet->getRowDimension($currentRow);
  834. // Write current row?
  835. $writeCurrentRow = isset($cellsByRow[$currentRow]) ||
  836. $rowDimension->getRowHeight() >= 0 ||
  837. $rowDimension->getVisible() == false ||
  838. $rowDimension->getCollapsed() == true ||
  839. $rowDimension->getOutlineLevel() > 0 ||
  840. $rowDimension->getXfIndex() !== null;
  841. if ($writeCurrentRow) {
  842. // Start a new row
  843. $objWriter->startElement('row');
  844. $objWriter->writeAttribute('r', $currentRow);
  845. $objWriter->writeAttribute('spans', '1:' . $colCount);
  846. // Row dimensions
  847. if ($rowDimension->getRowHeight() >= 0) {
  848. $objWriter->writeAttribute('customHeight', '1');
  849. $objWriter->writeAttribute('ht', PHPExcel_Shared_String::FormatNumber($rowDimension->getRowHeight()));
  850. }
  851. // Row visibility
  852. if ($rowDimension->getVisible() == false) {
  853. $objWriter->writeAttribute('hidden', 'true');
  854. }
  855. // Collapsed
  856. if ($rowDimension->getCollapsed() == true) {
  857. $objWriter->writeAttribute('collapsed', 'true');
  858. }
  859. // Outline level
  860. if ($rowDimension->getOutlineLevel() > 0) {
  861. $objWriter->writeAttribute('outlineLevel', $rowDimension->getOutlineLevel());
  862. }
  863. // Style
  864. if ($rowDimension->getXfIndex() !== null) {
  865. $objWriter->writeAttribute('s', $rowDimension->getXfIndex());
  866. $objWriter->writeAttribute('customFormat', '1');
  867. }
  868. // Write cells
  869. if (isset($cellsByRow[$currentRow])) {
  870. foreach($cellsByRow[$currentRow] as $cellAddress) {
  871. // Write cell
  872. $this->_writeCell($objWriter, $pSheet, $cellAddress, $pStringTable, $aFlippedStringTable);
  873. }
  874. }
  875. // End row
  876. $objWriter->endElement();
  877. }
  878. }
  879. $objWriter->endElement();
  880. } else {
  881. throw new Exception("Invalid parameters passed.");
  882. }
  883. }
  884. /**
  885. * Write Cell
  886. *
  887. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  888. * @param PHPExcel_Worksheet $pSheet Worksheet
  889. * @param PHPExcel_Cell $pCellAddress Cell Address
  890. * @param string[] $pStringTable String table
  891. * @param string[] $pFlippedStringTable String table (flipped), for faster index searching
  892. * @throws Exception
  893. */
  894. private function _writeCell(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $pCellAddress = null, $pStringTable = null, $pFlippedStringTable = null)
  895. {
  896. if (is_array($pStringTable) && is_array($pFlippedStringTable)) {
  897. // Cell
  898. $pCell = $pSheet->getCell($pCellAddress);
  899. $objWriter->startElement('c');
  900. $objWriter->writeAttribute('r', $pCellAddress);
  901. // Sheet styles
  902. if ($pCell->getXfIndex() != '') {
  903. $objWriter->writeAttribute('s', $pCell->getXfIndex());
  904. }
  905. // If cell value is supplied, write cell value
  906. $cellValue = $pCell->getValue();
  907. if (is_object($cellValue) || $cellValue !== '') {
  908. // Map type
  909. $mappedType = $pCell->getDataType();
  910. // Write data type depending on its type
  911. switch (strtolower($mappedType)) {
  912. case 'inlinestr': // Inline string
  913. case 's': // String
  914. case 'b': // Boolean
  915. $objWriter->writeAttribute('t', $mappedType);
  916. break;
  917. case 'f': // Formula
  918. $calculatedValue = null;
  919. if ($this->getParentWriter()->getPreCalculateFormulas()) {
  920. $calculatedValue = $pCell->getCalculatedValue();
  921. } else {
  922. $calculatedValue = $cellValue;
  923. }
  924. if (is_string($calculatedValue)) {
  925. $objWriter->writeAttribute('t', 'str');
  926. }
  927. break;
  928. case 'e': // Error
  929. $objWriter->writeAttribute('t', $mappedType);
  930. }
  931. // Write data depending on its type
  932. switch (strtolower($mappedType)) {
  933. case 'inlinestr': // Inline string
  934. if (! $cellValue instanceof PHPExcel_RichText) {
  935. $objWriter->writeElement('t', PHPExcel_Shared_String::ControlCharacterPHP2OOXML( htmlspecialchars($cellValue) ) );
  936. } else if ($cellValue instanceof PHPExcel_RichText) {
  937. $objWriter->startElement('is');
  938. $this->getParentWriter()->getWriterPart('stringtable')->writeRichText($objWriter, $cellValue);
  939. $objWriter->endElement();
  940. }
  941. break;
  942. case 's': // String
  943. if (! $cellValue instanceof PHPExcel_RichText) {
  944. if (isset($pFlippedStringTable[$cellValue])) {
  945. $objWriter->writeElement('v', $pFlippedStringTable[$cellValue]);
  946. }
  947. } else if ($cellValue instanceof PHPExcel_RichText) {
  948. $objWriter->writeElement('v', $pFlippedStringTable[$cellValue->getHashCode()]);
  949. }
  950. break;
  951. case 'f': // Formula
  952. $attributes = $pCell->getFormulaAttributes();
  953. if($attributes['t'] == 'array') {
  954. $objWriter->startElement('f');
  955. $objWriter->writeAttribute('t', 'array');
  956. $objWriter->writeAttribute('ref', $pCellAddress);
  957. $objWriter->writeAttribute('aca', '1');
  958. $objWriter->writeAttribute('ca', '1');
  959. $objWriter->text(substr($cellValue, 1));
  960. $objWriter->endElement();
  961. } else {
  962. $objWriter->writeElement('f', substr($cellValue, 1));
  963. }
  964. if ($this->getParentWriter()->getOffice2003Compatibility() === false) {
  965. if ($this->getParentWriter()->getPreCalculateFormulas()) {
  966. $calculatedValue = $pCell->getCalculatedValue();
  967. if (!is_array($calculatedValue) && substr($calculatedValue, 0, 1) != '#') {
  968. $objWriter->writeElement('v', PHPExcel_Shared_String::FormatNumber($calculatedValue));
  969. } else {
  970. $objWriter->writeElement('v', '0');
  971. }
  972. } else {
  973. $objWriter->writeElement('v', '0');
  974. }
  975. }
  976. break;
  977. case 'n': // Numeric
  978. // force point as decimal separator in case current locale uses comma
  979. $objWriter->writeElement('v', str_replace(',', '.', $cellValue));
  980. break;
  981. case 'b': // Boolean
  982. $objWriter->writeElement('v', ($cellValue ? '1' : '0'));
  983. break;
  984. case 'e': // Error
  985. if (substr($cellValue, 0, 1) == '=') {
  986. $objWriter->writeElement('f', substr($cellValue, 1));
  987. $objWriter->writeElement('v', substr($cellValue, 1));
  988. } else {
  989. $objWriter->writeElement('v', $cellValue);
  990. }
  991. break;
  992. }
  993. }
  994. $objWriter->endElement();
  995. } else {
  996. throw new Exception("Invalid parameters passed.");
  997. }
  998. }
  999. /**
  1000. * Write Drawings
  1001. *
  1002. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  1003. * @param PHPExcel_Worksheet $pSheet Worksheet
  1004. * @param boolean $includeCharts Flag indicating if we should include drawing details for charts
  1005. * @throws Exception
  1006. */
  1007. private function _writeDrawings(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $includeCharts = FALSE)
  1008. {
  1009. $chartCount = ($includeCharts) ? $pSheet->getChartCollection()->count() : 0;
  1010. // If sheet contains drawings, add the relationships
  1011. if (($pSheet->getDrawingCollection()->count() > 0) ||
  1012. ($chartCount > 0)) {
  1013. $objWriter->startElement('drawing');
  1014. $objWriter->writeAttribute('r:id', 'rId1');
  1015. $objWriter->endElement();
  1016. }
  1017. }
  1018. /**
  1019. * Write LegacyDrawing
  1020. *
  1021. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  1022. * @param PHPExcel_Worksheet $pSheet Worksheet
  1023. * @throws Exception
  1024. */
  1025. private function _writeLegacyDrawing(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  1026. {
  1027. // If sheet contains comments, add the relationships
  1028. if (count($pSheet->getComments()) > 0) {
  1029. $objWriter->startElement('legacyDrawing');
  1030. $objWriter->writeAttribute('r:id', 'rId_comments_vml1');
  1031. $objWriter->endElement();
  1032. }
  1033. }
  1034. /**
  1035. * Write LegacyDrawingHF
  1036. *
  1037. * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
  1038. * @param PHPExcel_Worksheet $pSheet Worksheet
  1039. * @throws Exception
  1040. */
  1041. private function _writeLegacyDrawingHF(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
  1042. {
  1043. // If sheet contains images, add the relationships
  1044. if (count($pSheet->getHeaderFooter()->getImages()) > 0) {
  1045. $objWriter->startElement('legacyDrawingHF');
  1046. $objWriter->writeAttribute('r:id', 'rId_headerfooter_vml1');
  1047. $objWriter->endElement();
  1048. }
  1049. }
  1050. }