ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
Worksheet.php
Go to the documentation of this file.
1 <?php
36 class PHPExcel_Writer_Excel2007_Worksheet extends PHPExcel_Writer_Excel2007_WriterPart
37 {
47  public function writeWorksheet($pSheet = null, $pStringTable = null, $includeCharts = FALSE)
48  {
49  if (!is_null($pSheet)) {
50  // Create XML writer
51  $objWriter = null;
52  if ($this->getParentWriter()->getUseDiskCaching()) {
53  $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
54  } else {
55  $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
56  }
57 
58  // XML header
59  $objWriter->startDocument('1.0','UTF-8','yes');
60 
61  // Worksheet
62  $objWriter->startElement('worksheet');
63  $objWriter->writeAttribute('xml:space', 'preserve');
64  $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');
65  $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
66 
67  // sheetPr
68  $this->_writeSheetPr($objWriter, $pSheet);
69 
70  // Dimension
71  $this->_writeDimension($objWriter, $pSheet);
72 
73  // sheetViews
74  $this->_writeSheetViews($objWriter, $pSheet);
75 
76  // sheetFormatPr
77  $this->_writeSheetFormatPr($objWriter, $pSheet);
78 
79  // cols
80  $this->_writeCols($objWriter, $pSheet);
81 
82  // sheetData
83  $this->_writeSheetData($objWriter, $pSheet, $pStringTable);
84 
85  // sheetProtection
86  $this->_writeSheetProtection($objWriter, $pSheet);
87 
88  // protectedRanges
89  $this->_writeProtectedRanges($objWriter, $pSheet);
90 
91  // autoFilter
92  $this->_writeAutoFilter($objWriter, $pSheet);
93 
94  // mergeCells
95  $this->_writeMergeCells($objWriter, $pSheet);
96 
97  // conditionalFormatting
98  $this->_writeConditionalFormatting($objWriter, $pSheet);
99 
100  // dataValidations
101  $this->_writeDataValidations($objWriter, $pSheet);
102 
103  // hyperlinks
104  $this->_writeHyperlinks($objWriter, $pSheet);
105 
106  // Print options
107  $this->_writePrintOptions($objWriter, $pSheet);
108 
109  // Page margins
110  $this->_writePageMargins($objWriter, $pSheet);
111 
112  // Page setup
113  $this->_writePageSetup($objWriter, $pSheet);
114 
115  // Header / footer
116  $this->_writeHeaderFooter($objWriter, $pSheet);
117 
118  // Breaks
119  $this->_writeBreaks($objWriter, $pSheet);
120 
121  // Drawings and/or Charts
122  $this->_writeDrawings($objWriter, $pSheet, $includeCharts);
123 
124  // LegacyDrawing
125  $this->_writeLegacyDrawing($objWriter, $pSheet);
126 
127  // LegacyDrawingHF
128  $this->_writeLegacyDrawingHF($objWriter, $pSheet);
129 
130  $objWriter->endElement();
131 
132  // Return
133  return $objWriter->getData();
134  } else {
135  throw new PHPExcel_Writer_Exception("Invalid PHPExcel_Worksheet object passed.");
136  }
137  }
138 
146  private function _writeSheetPr(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
147  {
148  // sheetPr
149  $objWriter->startElement('sheetPr');
150  //$objWriter->writeAttribute('codeName', $pSheet->getTitle());
151  if($pSheet->getParent()->hasMacros()){//if the workbook have macros, we need to have codeName for the sheet
152  if($pSheet->hasCodeName()==false){
153  $pSheet->setCodeName($pSheet->getTitle());
154  }
155  $objWriter->writeAttribute('codeName', $pSheet->getCodeName());
156  }
157  $autoFilterRange = $pSheet->getAutoFilter()->getRange();
158  if (!empty($autoFilterRange)) {
159  $objWriter->writeAttribute('filterMode', 1);
160  $pSheet->getAutoFilter()->showHideRows();
161  }
162 
163  // tabColor
164  if ($pSheet->isTabColorSet()) {
165  $objWriter->startElement('tabColor');
166  $objWriter->writeAttribute('rgb', $pSheet->getTabColor()->getARGB());
167  $objWriter->endElement();
168  }
169 
170  // outlinePr
171  $objWriter->startElement('outlinePr');
172  $objWriter->writeAttribute('summaryBelow', ($pSheet->getShowSummaryBelow() ? '1' : '0'));
173  $objWriter->writeAttribute('summaryRight', ($pSheet->getShowSummaryRight() ? '1' : '0'));
174  $objWriter->endElement();
175 
176  // pageSetUpPr
177  if ($pSheet->getPageSetup()->getFitToPage()) {
178  $objWriter->startElement('pageSetUpPr');
179  $objWriter->writeAttribute('fitToPage', '1');
180  $objWriter->endElement();
181  }
182 
183  $objWriter->endElement();
184  }
185 
193  private function _writeDimension(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
194  {
195  // dimension
196  $objWriter->startElement('dimension');
197  $objWriter->writeAttribute('ref', $pSheet->calculateWorksheetDimension());
198  $objWriter->endElement();
199  }
200 
208  private function _writeSheetViews(PHPExcel_Shared_XMLWriter $objWriter = NULL, PHPExcel_Worksheet $pSheet = NULL)
209  {
210  // sheetViews
211  $objWriter->startElement('sheetViews');
212 
213  // Sheet selected?
214  $sheetSelected = false;
215  if ($this->getParentWriter()->getPHPExcel()->getIndex($pSheet) == $this->getParentWriter()->getPHPExcel()->getActiveSheetIndex())
216  $sheetSelected = true;
217 
218 
219  // sheetView
220  $objWriter->startElement('sheetView');
221  $objWriter->writeAttribute('tabSelected', $sheetSelected ? '1' : '0');
222  $objWriter->writeAttribute('workbookViewId', '0');
223 
224  // Zoom scales
225  if ($pSheet->getSheetView()->getZoomScale() != 100) {
226  $objWriter->writeAttribute('zoomScale', $pSheet->getSheetView()->getZoomScale());
227  }
228  if ($pSheet->getSheetView()->getZoomScaleNormal() != 100) {
229  $objWriter->writeAttribute('zoomScaleNormal', $pSheet->getSheetView()->getZoomScaleNormal());
230  }
231 
232  // View Layout Type
233  if ($pSheet->getSheetView()->getView() !== PHPExcel_Worksheet_SheetView::SHEETVIEW_NORMAL) {
234  $objWriter->writeAttribute('view', $pSheet->getSheetView()->getView());
235  }
236 
237  // Gridlines
238  if ($pSheet->getShowGridlines()) {
239  $objWriter->writeAttribute('showGridLines', 'true');
240  } else {
241  $objWriter->writeAttribute('showGridLines', 'false');
242  }
243 
244  // Row and column headers
245  if ($pSheet->getShowRowColHeaders()) {
246  $objWriter->writeAttribute('showRowColHeaders', '1');
247  } else {
248  $objWriter->writeAttribute('showRowColHeaders', '0');
249  }
250 
251  // Right-to-left
252  if ($pSheet->getRightToLeft()) {
253  $objWriter->writeAttribute('rightToLeft', 'true');
254  }
255 
256  $activeCell = $pSheet->getActiveCell();
257 
258  // Pane
259  $pane = '';
260  $topLeftCell = $pSheet->getFreezePane();
261  if (($topLeftCell != '') && ($topLeftCell != 'A1')) {
262  $activeCell = $topLeftCell;
263  // Calculate freeze coordinates
264  $xSplit = $ySplit = 0;
265 
266  list($xSplit, $ySplit) = PHPExcel_Cell::coordinateFromString($topLeftCell);
267  $xSplit = PHPExcel_Cell::columnIndexFromString($xSplit);
268 
269  // pane
270  $pane = 'topRight';
271  $objWriter->startElement('pane');
272  if ($xSplit > 1)
273  $objWriter->writeAttribute('xSplit', $xSplit - 1);
274  if ($ySplit > 1) {
275  $objWriter->writeAttribute('ySplit', $ySplit - 1);
276  $pane = ($xSplit > 1) ? 'bottomRight' : 'bottomLeft';
277  }
278  $objWriter->writeAttribute('topLeftCell', $topLeftCell);
279  $objWriter->writeAttribute('activePane', $pane);
280  $objWriter->writeAttribute('state', 'frozen');
281  $objWriter->endElement();
282 
283  if (($xSplit > 1) && ($ySplit > 1)) {
284  // Write additional selections if more than two panes (ie both an X and a Y split)
285  $objWriter->startElement('selection'); $objWriter->writeAttribute('pane', 'topRight'); $objWriter->endElement();
286  $objWriter->startElement('selection'); $objWriter->writeAttribute('pane', 'bottomLeft'); $objWriter->endElement();
287  }
288  }
289 
290  // Selection
291 // if ($pane != '') {
292  // Only need to write selection element if we have a split pane
293  // We cheat a little by over-riding the active cell selection, setting it to the split cell
294  $objWriter->startElement('selection');
295  if ($pane != '') {
296  $objWriter->writeAttribute('pane', $pane);
297  }
298  $objWriter->writeAttribute('activeCell', $activeCell);
299  $objWriter->writeAttribute('sqref', $activeCell);
300  $objWriter->endElement();
301 // }
302 
303  $objWriter->endElement();
304 
305  $objWriter->endElement();
306  }
307 
315  private function _writeSheetFormatPr(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
316  {
317  // sheetFormatPr
318  $objWriter->startElement('sheetFormatPr');
319 
320  // Default row height
321  if ($pSheet->getDefaultRowDimension()->getRowHeight() >= 0) {
322  $objWriter->writeAttribute('customHeight', 'true');
323  $objWriter->writeAttribute('defaultRowHeight', PHPExcel_Shared_String::FormatNumber($pSheet->getDefaultRowDimension()->getRowHeight()));
324  } else {
325  $objWriter->writeAttribute('defaultRowHeight', '14.4');
326  }
327 
328  // Set Zero Height row
329  if ((string)$pSheet->getDefaultRowDimension()->getZeroHeight() == '1' ||
330  strtolower((string)$pSheet->getDefaultRowDimension()->getZeroHeight()) == 'true' ) {
331  $objWriter->writeAttribute('zeroHeight', '1');
332  }
333 
334  // Default column width
335  if ($pSheet->getDefaultColumnDimension()->getWidth() >= 0) {
336  $objWriter->writeAttribute('defaultColWidth', PHPExcel_Shared_String::FormatNumber($pSheet->getDefaultColumnDimension()->getWidth()));
337  }
338 
339  // Outline level - row
340  $outlineLevelRow = 0;
341  foreach ($pSheet->getRowDimensions() as $dimension) {
342  if ($dimension->getOutlineLevel() > $outlineLevelRow) {
343  $outlineLevelRow = $dimension->getOutlineLevel();
344  }
345  }
346  $objWriter->writeAttribute('outlineLevelRow', (int)$outlineLevelRow);
347 
348  // Outline level - column
349  $outlineLevelCol = 0;
350  foreach ($pSheet->getColumnDimensions() as $dimension) {
351  if ($dimension->getOutlineLevel() > $outlineLevelCol) {
352  $outlineLevelCol = $dimension->getOutlineLevel();
353  }
354  }
355  $objWriter->writeAttribute('outlineLevelCol', (int)$outlineLevelCol);
356 
357  $objWriter->endElement();
358  }
359 
367  private function _writeCols(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
368  {
369  // cols
370  if (count($pSheet->getColumnDimensions()) > 0) {
371  $objWriter->startElement('cols');
372 
373  $pSheet->calculateColumnWidths();
374 
375  // Loop through column dimensions
376  foreach ($pSheet->getColumnDimensions() as $colDimension) {
377  // col
378  $objWriter->startElement('col');
379  $objWriter->writeAttribute('min', PHPExcel_Cell::columnIndexFromString($colDimension->getColumnIndex()));
380  $objWriter->writeAttribute('max', PHPExcel_Cell::columnIndexFromString($colDimension->getColumnIndex()));
381 
382  if ($colDimension->getWidth() < 0) {
383  // No width set, apply default of 10
384  $objWriter->writeAttribute('width', '9.10');
385  } else {
386  // Width set
387  $objWriter->writeAttribute('width', PHPExcel_Shared_String::FormatNumber($colDimension->getWidth()));
388  }
389 
390  // Column visibility
391  if ($colDimension->getVisible() == false) {
392  $objWriter->writeAttribute('hidden', 'true');
393  }
394 
395  // Auto size?
396  if ($colDimension->getAutoSize()) {
397  $objWriter->writeAttribute('bestFit', 'true');
398  }
399 
400  // Custom width?
401  if ($colDimension->getWidth() != $pSheet->getDefaultColumnDimension()->getWidth()) {
402  $objWriter->writeAttribute('customWidth', 'true');
403  }
404 
405  // Collapsed
406  if ($colDimension->getCollapsed() == true) {
407  $objWriter->writeAttribute('collapsed', 'true');
408  }
409 
410  // Outline level
411  if ($colDimension->getOutlineLevel() > 0) {
412  $objWriter->writeAttribute('outlineLevel', $colDimension->getOutlineLevel());
413  }
414 
415  // Style
416  $objWriter->writeAttribute('style', $colDimension->getXfIndex());
417 
418  $objWriter->endElement();
419  }
420 
421  $objWriter->endElement();
422  }
423  }
424 
432  private function _writeSheetProtection(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
433  {
434  // sheetProtection
435  $objWriter->startElement('sheetProtection');
436 
437  if ($pSheet->getProtection()->getPassword() != '') {
438  $objWriter->writeAttribute('password', $pSheet->getProtection()->getPassword());
439  }
440 
441  $objWriter->writeAttribute('sheet', ($pSheet->getProtection()->getSheet() ? 'true' : 'false'));
442  $objWriter->writeAttribute('objects', ($pSheet->getProtection()->getObjects() ? 'true' : 'false'));
443  $objWriter->writeAttribute('scenarios', ($pSheet->getProtection()->getScenarios() ? 'true' : 'false'));
444  $objWriter->writeAttribute('formatCells', ($pSheet->getProtection()->getFormatCells() ? 'true' : 'false'));
445  $objWriter->writeAttribute('formatColumns', ($pSheet->getProtection()->getFormatColumns() ? 'true' : 'false'));
446  $objWriter->writeAttribute('formatRows', ($pSheet->getProtection()->getFormatRows() ? 'true' : 'false'));
447  $objWriter->writeAttribute('insertColumns', ($pSheet->getProtection()->getInsertColumns() ? 'true' : 'false'));
448  $objWriter->writeAttribute('insertRows', ($pSheet->getProtection()->getInsertRows() ? 'true' : 'false'));
449  $objWriter->writeAttribute('insertHyperlinks', ($pSheet->getProtection()->getInsertHyperlinks() ? 'true' : 'false'));
450  $objWriter->writeAttribute('deleteColumns', ($pSheet->getProtection()->getDeleteColumns() ? 'true' : 'false'));
451  $objWriter->writeAttribute('deleteRows', ($pSheet->getProtection()->getDeleteRows() ? 'true' : 'false'));
452  $objWriter->writeAttribute('selectLockedCells', ($pSheet->getProtection()->getSelectLockedCells() ? 'true' : 'false'));
453  $objWriter->writeAttribute('sort', ($pSheet->getProtection()->getSort() ? 'true' : 'false'));
454  $objWriter->writeAttribute('autoFilter', ($pSheet->getProtection()->getAutoFilter() ? 'true' : 'false'));
455  $objWriter->writeAttribute('pivotTables', ($pSheet->getProtection()->getPivotTables() ? 'true' : 'false'));
456  $objWriter->writeAttribute('selectUnlockedCells', ($pSheet->getProtection()->getSelectUnlockedCells() ? 'true' : 'false'));
457  $objWriter->endElement();
458  }
459 
467  private function _writeConditionalFormatting(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
468  {
469  // Conditional id
470  $id = 1;
471 
472  // Loop through styles in the current worksheet
473  foreach ($pSheet->getConditionalStylesCollection() as $cellCoordinate => $conditionalStyles) {
474  foreach ($conditionalStyles as $conditional) {
475  // WHY was this again?
476  // if ($this->getParentWriter()->getStylesConditionalHashTable()->getIndexForHashCode( $conditional->getHashCode() ) == '') {
477  // continue;
478  // }
479  if ($conditional->getConditionType() != PHPExcel_Style_Conditional::CONDITION_NONE) {
480  // conditionalFormatting
481  $objWriter->startElement('conditionalFormatting');
482  $objWriter->writeAttribute('sqref', $cellCoordinate);
483 
484  // cfRule
485  $objWriter->startElement('cfRule');
486  $objWriter->writeAttribute('type', $conditional->getConditionType());
487  $objWriter->writeAttribute('dxfId', $this->getParentWriter()->getStylesConditionalHashTable()->getIndexForHashCode( $conditional->getHashCode() ));
488  $objWriter->writeAttribute('priority', $id++);
489 
490  if (($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CELLIS
491  ||
492  $conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT)
493  && $conditional->getOperatorType() != PHPExcel_Style_Conditional::OPERATOR_NONE) {
494  $objWriter->writeAttribute('operator', $conditional->getOperatorType());
495  }
496 
497  if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
498  && !is_null($conditional->getText())) {
499  $objWriter->writeAttribute('text', $conditional->getText());
500  }
501 
502  if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
503  && $conditional->getOperatorType() == PHPExcel_Style_Conditional::OPERATOR_CONTAINSTEXT
504  && !is_null($conditional->getText())) {
505  $objWriter->writeElement('formula', 'NOT(ISERROR(SEARCH("' . $conditional->getText() . '",' . $cellCoordinate . ')))');
506  } else if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
507  && $conditional->getOperatorType() == PHPExcel_Style_Conditional::OPERATOR_BEGINSWITH
508  && !is_null($conditional->getText())) {
509  $objWriter->writeElement('formula', 'LEFT(' . $cellCoordinate . ',' . strlen($conditional->getText()) . ')="' . $conditional->getText() . '"');
510  } else if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
511  && $conditional->getOperatorType() == PHPExcel_Style_Conditional::OPERATOR_ENDSWITH
512  && !is_null($conditional->getText())) {
513  $objWriter->writeElement('formula', 'RIGHT(' . $cellCoordinate . ',' . strlen($conditional->getText()) . ')="' . $conditional->getText() . '"');
514  } else if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
515  && $conditional->getOperatorType() == PHPExcel_Style_Conditional::OPERATOR_NOTCONTAINS
516  && !is_null($conditional->getText())) {
517  $objWriter->writeElement('formula', 'ISERROR(SEARCH("' . $conditional->getText() . '",' . $cellCoordinate . '))');
518  } else if ($conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CELLIS
519  || $conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT
520  || $conditional->getConditionType() == PHPExcel_Style_Conditional::CONDITION_EXPRESSION) {
521  foreach ($conditional->getConditions() as $formula) {
522  // Formula
523  $objWriter->writeElement('formula', $formula);
524  }
525  }
526 
527  $objWriter->endElement();
528 
529  $objWriter->endElement();
530  }
531  }
532  }
533  }
534 
542  private function _writeDataValidations(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
543  {
544  // Datavalidation collection
545  $dataValidationCollection = $pSheet->getDataValidationCollection();
546 
547  // Write data validations?
548  if (!empty($dataValidationCollection)) {
549  $objWriter->startElement('dataValidations');
550  $objWriter->writeAttribute('count', count($dataValidationCollection));
551 
552  foreach ($dataValidationCollection as $coordinate => $dv) {
553  $objWriter->startElement('dataValidation');
554 
555  if ($dv->getType() != '') {
556  $objWriter->writeAttribute('type', $dv->getType());
557  }
558 
559  if ($dv->getErrorStyle() != '') {
560  $objWriter->writeAttribute('errorStyle', $dv->getErrorStyle());
561  }
562 
563  if ($dv->getOperator() != '') {
564  $objWriter->writeAttribute('operator', $dv->getOperator());
565  }
566 
567  $objWriter->writeAttribute('allowBlank', ($dv->getAllowBlank() ? '1' : '0'));
568  $objWriter->writeAttribute('showDropDown', (!$dv->getShowDropDown() ? '1' : '0'));
569  $objWriter->writeAttribute('showInputMessage', ($dv->getShowInputMessage() ? '1' : '0'));
570  $objWriter->writeAttribute('showErrorMessage', ($dv->getShowErrorMessage() ? '1' : '0'));
571 
572  if ($dv->getErrorTitle() !== '') {
573  $objWriter->writeAttribute('errorTitle', $dv->getErrorTitle());
574  }
575  if ($dv->getError() !== '') {
576  $objWriter->writeAttribute('error', $dv->getError());
577  }
578  if ($dv->getPromptTitle() !== '') {
579  $objWriter->writeAttribute('promptTitle', $dv->getPromptTitle());
580  }
581  if ($dv->getPrompt() !== '') {
582  $objWriter->writeAttribute('prompt', $dv->getPrompt());
583  }
584 
585  $objWriter->writeAttribute('sqref', $coordinate);
586 
587  if ($dv->getFormula1() !== '') {
588  $objWriter->writeElement('formula1', $dv->getFormula1());
589  }
590  if ($dv->getFormula2() !== '') {
591  $objWriter->writeElement('formula2', $dv->getFormula2());
592  }
593 
594  $objWriter->endElement();
595  }
596 
597  $objWriter->endElement();
598  }
599  }
600 
608  private function _writeHyperlinks(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
609  {
610  // Hyperlink collection
611  $hyperlinkCollection = $pSheet->getHyperlinkCollection();
612 
613  // Relation ID
614  $relationId = 1;
615 
616  // Write hyperlinks?
617  if (!empty($hyperlinkCollection)) {
618  $objWriter->startElement('hyperlinks');
619 
620  foreach ($hyperlinkCollection as $coordinate => $hyperlink) {
621  $objWriter->startElement('hyperlink');
622 
623  $objWriter->writeAttribute('ref', $coordinate);
624  if (!$hyperlink->isInternal()) {
625  $objWriter->writeAttribute('r:id', 'rId_hyperlink_' . $relationId);
626  ++$relationId;
627  } else {
628  $objWriter->writeAttribute('location', str_replace('sheet://', '', $hyperlink->getUrl()));
629  }
630 
631  if ($hyperlink->getTooltip() != '') {
632  $objWriter->writeAttribute('tooltip', $hyperlink->getTooltip());
633  }
634 
635  $objWriter->endElement();
636  }
637 
638  $objWriter->endElement();
639  }
640  }
641 
649  private function _writeProtectedRanges(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
650  {
651  if (count($pSheet->getProtectedCells()) > 0) {
652  // protectedRanges
653  $objWriter->startElement('protectedRanges');
654 
655  // Loop protectedRanges
656  foreach ($pSheet->getProtectedCells() as $protectedCell => $passwordHash) {
657  // protectedRange
658  $objWriter->startElement('protectedRange');
659  $objWriter->writeAttribute('name', 'p' . md5($protectedCell));
660  $objWriter->writeAttribute('sqref', $protectedCell);
661  if (!empty($passwordHash)) {
662  $objWriter->writeAttribute('password', $passwordHash);
663  }
664  $objWriter->endElement();
665  }
666 
667  $objWriter->endElement();
668  }
669  }
670 
678  private function _writeMergeCells(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
679  {
680  if (count($pSheet->getMergeCells()) > 0) {
681  // mergeCells
682  $objWriter->startElement('mergeCells');
683 
684  // Loop mergeCells
685  foreach ($pSheet->getMergeCells() as $mergeCell) {
686  // mergeCell
687  $objWriter->startElement('mergeCell');
688  $objWriter->writeAttribute('ref', $mergeCell);
689  $objWriter->endElement();
690  }
691 
692  $objWriter->endElement();
693  }
694  }
695 
703  private function _writePrintOptions(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
704  {
705  // printOptions
706  $objWriter->startElement('printOptions');
707 
708  $objWriter->writeAttribute('gridLines', ($pSheet->getPrintGridlines() ? 'true': 'false'));
709  $objWriter->writeAttribute('gridLinesSet', 'true');
710 
711  if ($pSheet->getPageSetup()->getHorizontalCentered()) {
712  $objWriter->writeAttribute('horizontalCentered', 'true');
713  }
714 
715  if ($pSheet->getPageSetup()->getVerticalCentered()) {
716  $objWriter->writeAttribute('verticalCentered', 'true');
717  }
718 
719  $objWriter->endElement();
720  }
721 
729  private function _writePageMargins(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
730  {
731  // pageMargins
732  $objWriter->startElement('pageMargins');
733  $objWriter->writeAttribute('left', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getLeft()));
734  $objWriter->writeAttribute('right', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getRight()));
735  $objWriter->writeAttribute('top', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getTop()));
736  $objWriter->writeAttribute('bottom', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getBottom()));
737  $objWriter->writeAttribute('header', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getHeader()));
738  $objWriter->writeAttribute('footer', PHPExcel_Shared_String::FormatNumber($pSheet->getPageMargins()->getFooter()));
739  $objWriter->endElement();
740  }
741 
749  private function _writeAutoFilter(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
750  {
751  $autoFilterRange = $pSheet->getAutoFilter()->getRange();
752  if (!empty($autoFilterRange)) {
753  // autoFilter
754  $objWriter->startElement('autoFilter');
755 
756  // Strip any worksheet reference from the filter coordinates
757  $range = PHPExcel_Cell::splitRange($autoFilterRange);
758  $range = $range[0];
759  // Strip any worksheet ref
760  if (strpos($range[0],'!') !== false) {
761  list($ws,$range[0]) = explode('!',$range[0]);
762  }
763  $range = implode(':', $range);
764 
765  $objWriter->writeAttribute('ref', str_replace('$','',$range));
766 
767  $columns = $pSheet->getAutoFilter()->getColumns();
768  if (count($columns > 0)) {
769  foreach($columns as $columnID => $column) {
770  $rules = $column->getRules();
771  if (count($rules > 0)) {
772  $objWriter->startElement('filterColumn');
773  $objWriter->writeAttribute('colId', $pSheet->getAutoFilter()->getColumnOffset($columnID));
774 
775  $objWriter->startElement( $column->getFilterType());
776  if ($column->getJoin() == PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_COLUMN_JOIN_AND) {
777  $objWriter->writeAttribute('and', 1);
778  }
779 
780  foreach ($rules as $rule) {
781  if (($column->getFilterType() === PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_FILTERTYPE_FILTER) &&
782  ($rule->getOperator() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_EQUAL) &&
783  ($rule->getValue() === '')) {
784  // Filter rule for Blanks
785  $objWriter->writeAttribute('blank', 1);
786  } elseif($rule->getRuleType() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMICFILTER) {
787  // Dynamic Filter Rule
788  $objWriter->writeAttribute('type', $rule->getGrouping());
789  $val = $column->getAttribute('val');
790  if ($val !== NULL) {
791  $objWriter->writeAttribute('val', $val);
792  }
793  $maxVal = $column->getAttribute('maxVal');
794  if ($maxVal !== NULL) {
795  $objWriter->writeAttribute('maxVal', $maxVal);
796  }
797  } elseif($rule->getRuleType() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_TOPTENFILTER) {
798  // Top 10 Filter Rule
799  $objWriter->writeAttribute('val', $rule->getValue());
800  $objWriter->writeAttribute('percent', (($rule->getOperator() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT) ? '1' : '0'));
801  $objWriter->writeAttribute('top', (($rule->getGrouping() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_TOPTEN_TOP) ? '1': '0'));
802  } else {
803  // Filter, DateGroupItem or CustomFilter
804  $objWriter->startElement($rule->getRuleType());
805 
806  if ($rule->getOperator() !== PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_EQUAL) {
807  $objWriter->writeAttribute('operator', $rule->getOperator());
808  }
809  if ($rule->getRuleType() === PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DATEGROUP) {
810  // Date Group filters
811  foreach($rule->getValue() as $key => $value) {
812  if ($value > '') $objWriter->writeAttribute($key, $value);
813  }
814  $objWriter->writeAttribute('dateTimeGrouping', $rule->getGrouping());
815  } else {
816  $objWriter->writeAttribute('val', $rule->getValue());
817  }
818 
819  $objWriter->endElement();
820  }
821  }
822 
823  $objWriter->endElement();
824 
825  $objWriter->endElement();
826  }
827  }
828  }
829 
830  $objWriter->endElement();
831  }
832  }
833 
841  private function _writePageSetup(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
842  {
843  // pageSetup
844  $objWriter->startElement('pageSetup');
845  $objWriter->writeAttribute('paperSize', $pSheet->getPageSetup()->getPaperSize());
846  $objWriter->writeAttribute('orientation', $pSheet->getPageSetup()->getOrientation());
847 
848  if (!is_null($pSheet->getPageSetup()->getScale())) {
849  $objWriter->writeAttribute('scale', $pSheet->getPageSetup()->getScale());
850  }
851  if (!is_null($pSheet->getPageSetup()->getFitToHeight())) {
852  $objWriter->writeAttribute('fitToHeight', $pSheet->getPageSetup()->getFitToHeight());
853  } else {
854  $objWriter->writeAttribute('fitToHeight', '0');
855  }
856  if (!is_null($pSheet->getPageSetup()->getFitToWidth())) {
857  $objWriter->writeAttribute('fitToWidth', $pSheet->getPageSetup()->getFitToWidth());
858  } else {
859  $objWriter->writeAttribute('fitToWidth', '0');
860  }
861  if (!is_null($pSheet->getPageSetup()->getFirstPageNumber())) {
862  $objWriter->writeAttribute('firstPageNumber', $pSheet->getPageSetup()->getFirstPageNumber());
863  $objWriter->writeAttribute('useFirstPageNumber', '1');
864  }
865 
866  $objWriter->endElement();
867  }
868 
876  private function _writeHeaderFooter(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
877  {
878  // headerFooter
879  $objWriter->startElement('headerFooter');
880  $objWriter->writeAttribute('differentOddEven', ($pSheet->getHeaderFooter()->getDifferentOddEven() ? 'true' : 'false'));
881  $objWriter->writeAttribute('differentFirst', ($pSheet->getHeaderFooter()->getDifferentFirst() ? 'true' : 'false'));
882  $objWriter->writeAttribute('scaleWithDoc', ($pSheet->getHeaderFooter()->getScaleWithDocument() ? 'true' : 'false'));
883  $objWriter->writeAttribute('alignWithMargins', ($pSheet->getHeaderFooter()->getAlignWithMargins() ? 'true' : 'false'));
884 
885  $objWriter->writeElement('oddHeader', $pSheet->getHeaderFooter()->getOddHeader());
886  $objWriter->writeElement('oddFooter', $pSheet->getHeaderFooter()->getOddFooter());
887  $objWriter->writeElement('evenHeader', $pSheet->getHeaderFooter()->getEvenHeader());
888  $objWriter->writeElement('evenFooter', $pSheet->getHeaderFooter()->getEvenFooter());
889  $objWriter->writeElement('firstHeader', $pSheet->getHeaderFooter()->getFirstHeader());
890  $objWriter->writeElement('firstFooter', $pSheet->getHeaderFooter()->getFirstFooter());
891  $objWriter->endElement();
892  }
893 
901  private function _writeBreaks(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
902  {
903  // Get row and column breaks
904  $aRowBreaks = array();
905  $aColumnBreaks = array();
906  foreach ($pSheet->getBreaks() as $cell => $breakType) {
907  if ($breakType == PHPExcel_Worksheet::BREAK_ROW) {
908  $aRowBreaks[] = $cell;
909  } else if ($breakType == PHPExcel_Worksheet::BREAK_COLUMN) {
910  $aColumnBreaks[] = $cell;
911  }
912  }
913 
914  // rowBreaks
915  if (!empty($aRowBreaks)) {
916  $objWriter->startElement('rowBreaks');
917  $objWriter->writeAttribute('count', count($aRowBreaks));
918  $objWriter->writeAttribute('manualBreakCount', count($aRowBreaks));
919 
920  foreach ($aRowBreaks as $cell) {
921  $coords = PHPExcel_Cell::coordinateFromString($cell);
922 
923  $objWriter->startElement('brk');
924  $objWriter->writeAttribute('id', $coords[1]);
925  $objWriter->writeAttribute('man', '1');
926  $objWriter->endElement();
927  }
928 
929  $objWriter->endElement();
930  }
931 
932  // Second, write column breaks
933  if (!empty($aColumnBreaks)) {
934  $objWriter->startElement('colBreaks');
935  $objWriter->writeAttribute('count', count($aColumnBreaks));
936  $objWriter->writeAttribute('manualBreakCount', count($aColumnBreaks));
937 
938  foreach ($aColumnBreaks as $cell) {
939  $coords = PHPExcel_Cell::coordinateFromString($cell);
940 
941  $objWriter->startElement('brk');
942  $objWriter->writeAttribute('id', PHPExcel_Cell::columnIndexFromString($coords[0]) - 1);
943  $objWriter->writeAttribute('man', '1');
944  $objWriter->endElement();
945  }
946 
947  $objWriter->endElement();
948  }
949  }
950 
959  private function _writeSheetData(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $pStringTable = null)
960  {
961  if (is_array($pStringTable)) {
962  // Flipped stringtable, for faster index searching
963  $aFlippedStringTable = $this->getParentWriter()->getWriterPart('stringtable')->flipStringTable($pStringTable);
964 
965  // sheetData
966  $objWriter->startElement('sheetData');
967 
968  // Get column count
969  $colCount = PHPExcel_Cell::columnIndexFromString($pSheet->getHighestColumn());
970 
971  // Highest row number
972  $highestRow = $pSheet->getHighestRow();
973 
974  // Loop through cells
975  $cellsByRow = array();
976  foreach ($pSheet->getCellCollection() as $cellID) {
977  $cellAddress = PHPExcel_Cell::coordinateFromString($cellID);
978  $cellsByRow[$cellAddress[1]][] = $cellID;
979  }
980 
981  $currentRow = 0;
982  while($currentRow++ < $highestRow) {
983  // Get row dimension
984  $rowDimension = $pSheet->getRowDimension($currentRow);
985 
986  // Write current row?
987  $writeCurrentRow = isset($cellsByRow[$currentRow]) ||
988  $rowDimension->getRowHeight() >= 0 ||
989  $rowDimension->getVisible() == false ||
990  $rowDimension->getCollapsed() == true ||
991  $rowDimension->getOutlineLevel() > 0 ||
992  $rowDimension->getXfIndex() !== null;
993 
994  if ($writeCurrentRow) {
995  // Start a new row
996  $objWriter->startElement('row');
997  $objWriter->writeAttribute('r', $currentRow);
998  $objWriter->writeAttribute('spans', '1:' . $colCount);
999 
1000  // Row dimensions
1001  if ($rowDimension->getRowHeight() >= 0) {
1002  $objWriter->writeAttribute('customHeight', '1');
1003  $objWriter->writeAttribute('ht', PHPExcel_Shared_String::FormatNumber($rowDimension->getRowHeight()));
1004  }
1005 
1006  // Row visibility
1007  if ($rowDimension->getVisible() == false) {
1008  $objWriter->writeAttribute('hidden', 'true');
1009  }
1010 
1011  // Collapsed
1012  if ($rowDimension->getCollapsed() == true) {
1013  $objWriter->writeAttribute('collapsed', 'true');
1014  }
1015 
1016  // Outline level
1017  if ($rowDimension->getOutlineLevel() > 0) {
1018  $objWriter->writeAttribute('outlineLevel', $rowDimension->getOutlineLevel());
1019  }
1020 
1021  // Style
1022  if ($rowDimension->getXfIndex() !== null) {
1023  $objWriter->writeAttribute('s', $rowDimension->getXfIndex());
1024  $objWriter->writeAttribute('customFormat', '1');
1025  }
1026 
1027  // Write cells
1028  if (isset($cellsByRow[$currentRow])) {
1029  foreach($cellsByRow[$currentRow] as $cellAddress) {
1030  // Write cell
1031  $this->_writeCell($objWriter, $pSheet, $cellAddress, $pStringTable, $aFlippedStringTable);
1032  }
1033  }
1034 
1035  // End row
1036  $objWriter->endElement();
1037  }
1038  }
1039 
1040  $objWriter->endElement();
1041  } else {
1042  throw new PHPExcel_Writer_Exception("Invalid parameters passed.");
1043  }
1044  }
1045 
1056  private function _writeCell(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $pCellAddress = null, $pStringTable = null, $pFlippedStringTable = null)
1057  {
1058  if (is_array($pStringTable) && is_array($pFlippedStringTable)) {
1059  // Cell
1060  $pCell = $pSheet->getCell($pCellAddress);
1061  $objWriter->startElement('c');
1062  $objWriter->writeAttribute('r', $pCellAddress);
1063 
1064  // Sheet styles
1065  if ($pCell->getXfIndex() != '') {
1066  $objWriter->writeAttribute('s', $pCell->getXfIndex());
1067  }
1068 
1069  // If cell value is supplied, write cell value
1070  $cellValue = $pCell->getValue();
1071  if (is_object($cellValue) || $cellValue !== '') {
1072  // Map type
1073  $mappedType = $pCell->getDataType();
1074 
1075  // Write data type depending on its type
1076  switch (strtolower($mappedType)) {
1077  case 'inlinestr': // Inline string
1078  case 's': // String
1079  case 'b': // Boolean
1080  $objWriter->writeAttribute('t', $mappedType);
1081  break;
1082  case 'f': // Formula
1083  $calculatedValue = ($this->getParentWriter()->getPreCalculateFormulas()) ?
1084  $pCell->getCalculatedValue() :
1085  $cellValue;
1086  if (is_string($calculatedValue)) {
1087  $objWriter->writeAttribute('t', 'str');
1088  }
1089  break;
1090  case 'e': // Error
1091  $objWriter->writeAttribute('t', $mappedType);
1092  }
1093 
1094  // Write data depending on its type
1095  switch (strtolower($mappedType)) {
1096  case 'inlinestr': // Inline string
1097  if (! $cellValue instanceof PHPExcel_RichText) {
1098  $objWriter->writeElement('t', PHPExcel_Shared_String::ControlCharacterPHP2OOXML( htmlspecialchars($cellValue) ) );
1099  } else if ($cellValue instanceof PHPExcel_RichText) {
1100  $objWriter->startElement('is');
1101  $this->getParentWriter()->getWriterPart('stringtable')->writeRichText($objWriter, $cellValue);
1102  $objWriter->endElement();
1103  }
1104 
1105  break;
1106  case 's': // String
1107  if (! $cellValue instanceof PHPExcel_RichText) {
1108  if (isset($pFlippedStringTable[$cellValue])) {
1109  $objWriter->writeElement('v', $pFlippedStringTable[$cellValue]);
1110  }
1111  } else if ($cellValue instanceof PHPExcel_RichText) {
1112  $objWriter->writeElement('v', $pFlippedStringTable[$cellValue->getHashCode()]);
1113  }
1114 
1115  break;
1116  case 'f': // Formula
1117  $attributes = $pCell->getFormulaAttributes();
1118  if($attributes['t'] == 'array') {
1119  $objWriter->startElement('f');
1120  $objWriter->writeAttribute('t', 'array');
1121  $objWriter->writeAttribute('ref', $pCellAddress);
1122  $objWriter->writeAttribute('aca', '1');
1123  $objWriter->writeAttribute('ca', '1');
1124  $objWriter->text(substr($cellValue, 1));
1125  $objWriter->endElement();
1126  } else {
1127  $objWriter->writeElement('f', substr($cellValue, 1));
1128  }
1129  if ($this->getParentWriter()->getOffice2003Compatibility() === false) {
1130  if ($this->getParentWriter()->getPreCalculateFormulas()) {
1131 // $calculatedValue = $pCell->getCalculatedValue();
1132  if (!is_array($calculatedValue) && substr($calculatedValue, 0, 1) != '#') {
1133  $objWriter->writeElement('v', PHPExcel_Shared_String::FormatNumber($calculatedValue));
1134  } else {
1135  $objWriter->writeElement('v', '0');
1136  }
1137  } else {
1138  $objWriter->writeElement('v', '0');
1139  }
1140  }
1141  break;
1142  case 'n': // Numeric
1143  // force point as decimal separator in case current locale uses comma
1144  $objWriter->writeElement('v', str_replace(',', '.', $cellValue));
1145  break;
1146  case 'b': // Boolean
1147  $objWriter->writeElement('v', ($cellValue ? '1' : '0'));
1148  break;
1149  case 'e': // Error
1150  if (substr($cellValue, 0, 1) == '=') {
1151  $objWriter->writeElement('f', substr($cellValue, 1));
1152  $objWriter->writeElement('v', substr($cellValue, 1));
1153  } else {
1154  $objWriter->writeElement('v', $cellValue);
1155  }
1156 
1157  break;
1158  }
1159  }
1160 
1161  $objWriter->endElement();
1162  } else {
1163  throw new PHPExcel_Writer_Exception("Invalid parameters passed.");
1164  }
1165  }
1166 
1175  private function _writeDrawings(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $includeCharts = FALSE)
1176  {
1177  $chartCount = ($includeCharts) ? $pSheet->getChartCollection()->count() : 0;
1178  // If sheet contains drawings, add the relationships
1179  if (($pSheet->getDrawingCollection()->count() > 0) ||
1180  ($chartCount > 0)) {
1181  $objWriter->startElement('drawing');
1182  $objWriter->writeAttribute('r:id', 'rId1');
1183  $objWriter->endElement();
1184  }
1185  }
1186 
1194  private function _writeLegacyDrawing(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
1195  {
1196  // If sheet contains comments, add the relationships
1197  if (count($pSheet->getComments()) > 0) {
1198  $objWriter->startElement('legacyDrawing');
1199  $objWriter->writeAttribute('r:id', 'rId_comments_vml1');
1200  $objWriter->endElement();
1201  }
1202  }
1203 
1211  private function _writeLegacyDrawingHF(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
1212  {
1213  // If sheet contains images, add the relationships
1214  if (count($pSheet->getHeaderFooter()->getImages()) > 0) {
1215  $objWriter->startElement('legacyDrawingHF');
1216  $objWriter->writeAttribute('r:id', 'rId_headerfooter_vml1');
1217  $objWriter->endElement();
1218  }
1219  }
1220 }
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT
const AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT
Definition: Rule.php:182
PHPExcel_Writer_Excel2007_Worksheet\_writeAutoFilter
_writeAutoFilter(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write AutoFilter.
Definition: Worksheet.php:749
PHPExcel_Writer_Excel2007_Worksheet\_writeCols
_writeCols(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write Cols.
Definition: Worksheet.php:367
PHPExcel_Cell\splitRange
static splitRange($pRange='A1:A1')
Split range into coordinate strings.
Definition: Cell.php:660
PHPExcel_Style_Conditional\CONDITION_CONTAINSTEXT
const CONDITION_CONTAINSTEXT
Definition: Conditional.php:41
PHPExcel_Writer_Excel2007_Worksheet\_writeSheetData
_writeSheetData(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pStringTable=null)
Write SheetData.
Definition: Worksheet.php:959
PHPExcel_Cell\coordinateFromString
static coordinateFromString($pCoordinateString='A1')
Coordinate from string.
Definition: Cell.php:580
PHPExcel_Writer_Excel2007_Worksheet\_writeHyperlinks
_writeHyperlinks(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write Hyperlinks.
Definition: Worksheet.php:608
PHPExcel_Writer_Excel2007_Worksheet\_writeDimension
_writeDimension(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write Dimension.
Definition: Worksheet.php:193
PHPExcel_Writer_Excel2007_Worksheet\_writeSheetProtection
_writeSheetProtection(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write SheetProtection.
Definition: Worksheet.php:432
PHPExcel_Writer_Excel2007_Worksheet\_writeSheetFormatPr
_writeSheetFormatPr(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write SheetFormatPr.
Definition: Worksheet.php:315
PHPExcel_Writer_Excel2007_Worksheet\_writePrintOptions
_writePrintOptions(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write PrintOptions.
Definition: Worksheet.php:703
PHPExcel_Worksheet_AutoFilter_Column\AUTOFILTER_FILTERTYPE_FILTER
const AUTOFILTER_FILTERTYPE_FILTER
Definition: Column.php:38
PHPExcel_Shared_String\FormatNumber
static FormatNumber($value)
Formats a numeric value as a string for output in various output writers forcing point as decimal sep...
Definition: String.php:416
PHPExcel_Writer_Exception
Definition: Exception.php:36
$id
if(!array_key_exists('StateId', $_REQUEST)) $id
Definition: expirywarning.php:14
PHPExcel_Writer_Excel2007_Worksheet\_writeConditionalFormatting
_writeConditionalFormatting(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write ConditionalFormatting.
Definition: Worksheet.php:467
PHPExcel_Worksheet\BREAK_ROW
const BREAK_ROW
Definition: Worksheet.php:40
PHPExcel_Worksheet\BREAK_COLUMN
const BREAK_COLUMN
Definition: Worksheet.php:41
$attributes
$attributes
Definition: serviceValidate.php:33
PHPExcel_Writer_Excel2007_Worksheet\_writeDataValidations
_writeDataValidations(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write DataValidations.
Definition: Worksheet.php:542
PHPExcel_Writer_Excel2007_Worksheet\_writeHeaderFooter
_writeHeaderFooter(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write Header / Footer.
Definition: Worksheet.php:876
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_RULETYPE_DATEGROUP
const AUTOFILTER_RULETYPE_DATEGROUP
Definition: Rule.php:39
PHPExcel_Writer_Excel2007_Worksheet\_writeSheetPr
_writeSheetPr(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write SheetPr.
Definition: Worksheet.php:146
PHPExcel_Writer_Excel2007_Worksheet\_writeMergeCells
_writeMergeCells(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write MergeCells.
Definition: Worksheet.php:678
PHPExcel_Writer_Excel2007_WriterPart\getParentWriter
getParentWriter()
Get parent IWriter object.
Definition: WriterPart.php:61
$coords
$coords
Definition: example_030.php:88
PHPExcel_Writer_Excel2007_Worksheet
Definition: Worksheet.php:36
PHPExcel_Writer_Excel2007_Worksheet\_writeLegacyDrawingHF
_writeLegacyDrawingHF(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write LegacyDrawingHF.
Definition: Worksheet.php:1211
PHPExcel_RichText
PHPExcel_Writer_Excel2007_Worksheet\_writeProtectedRanges
_writeProtectedRanges(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write ProtectedRanges.
Definition: Worksheet.php:649
$objWriter
$objWriter
Definition: 01pharSimple.php:81
PHPExcel_Style_Conditional\OPERATOR_CONTAINSTEXT
const OPERATOR_CONTAINSTEXT
Definition: Conditional.php:54
PHPExcel_Worksheet
PHPExcel_Writer_Excel2007_Worksheet\_writePageSetup
_writePageSetup(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write PageSetup.
Definition: Worksheet.php:841
PHPExcel_Writer_Excel2007_Worksheet\_writeDrawings
_writeDrawings(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $includeCharts=FALSE)
Write Drawings.
Definition: Worksheet.php:1175
$column
$column
Definition: 39dropdown.php:62
PHPExcel_Writer_Excel2007_Worksheet\_writeSheetViews
_writeSheetViews(PHPExcel_Shared_XMLWriter $objWriter=NULL, PHPExcel_Worksheet $pSheet=NULL)
Write SheetViews.
Definition: Worksheet.php:208
$rule
$rule
Definition: showstats.php:43
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_RULETYPE_TOPTENFILTER
const AUTOFILTER_RULETYPE_TOPTENFILTER
Definition: Rule.php:42
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_COLUMN_RULE_TOPTEN_TOP
const AUTOFILTER_COLUMN_RULE_TOPTEN_TOP
Definition: Rule.php:189
PHPExcel_Style_Conditional\OPERATOR_ENDSWITH
const OPERATOR_ENDSWITH
Definition: Conditional.php:47
PHPExcel_Shared_XMLWriter\STORAGE_DISK
const STORAGE_DISK
Definition: XMLWriter.php:47
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_COLUMN_RULE_EQUAL
const AUTOFILTER_COLUMN_RULE_EQUAL
Definition: Rule.php:165
PHPExcel_Worksheet_SheetView\SHEETVIEW_NORMAL
const SHEETVIEW_NORMAL
Definition: SheetView.php:40
PHPExcel_Writer_Excel2007_Worksheet\_writeCell
_writeCell(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pCellAddress=null, $pStringTable=null, $pFlippedStringTable=null)
Write Cell.
Definition: Worksheet.php:1056
PHPExcel_Worksheet_AutoFilter_Column\AUTOFILTER_COLUMN_JOIN_AND
const AUTOFILTER_COLUMN_JOIN_AND
Definition: Column.php:64
array
Create styles array
The data for the language used.
Definition: 40duplicateStyle.php:19
PHPExcel_Style_Conditional\CONDITION_CELLIS
const CONDITION_CELLIS
Definition: Conditional.php:40
PHPExcel_Style_Conditional\OPERATOR_NONE
const OPERATOR_NONE
Definition: Conditional.php:45
PHPExcel_Style_Conditional\CONDITION_EXPRESSION
const CONDITION_EXPRESSION
Definition: Conditional.php:42
PHPExcel_Cell\columnIndexFromString
static columnIndexFromString($pString='A')
Column index from string.
Definition: Cell.php:782
PHPExcel_Style_Conditional\CONDITION_NONE
const CONDITION_NONE
Definition: Conditional.php:39
PHPExcel_Style_Conditional\OPERATOR_BEGINSWITH
const OPERATOR_BEGINSWITH
Definition: Conditional.php:46
PHPExcel_Writer_Excel2007_WriterPart
Definition: WriterPart.php:36
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_RULETYPE_DYNAMICFILTER
const AUTOFILTER_RULETYPE_DYNAMICFILTER
Definition: Rule.php:41
PHPExcel_Shared_XMLWriter\STORAGE_MEMORY
const STORAGE_MEMORY
Temporary storage method.
Definition: XMLWriter.php:46
$columns
if(! $in) $columns
Definition: Utf8Test.php:45
PHPExcel_Writer_Excel2007_Worksheet\_writePageMargins
_writePageMargins(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write PageMargins.
Definition: Worksheet.php:729
$key
$key
Definition: croninfo.php:18
PHPExcel_Shared_XMLWriter
Definition: XMLWriter.php:44
PHPExcel_Shared_String\ControlCharacterPHP2OOXML
static ControlCharacterPHP2OOXML($value='')
Convert from PHP control character to OpenXML escaped control character.
Definition: String.php:373
PHPExcel_Writer_Excel2007_Worksheet\_writeBreaks
_writeBreaks(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write Breaks.
Definition: Worksheet.php:901
PHPExcel_Writer_Excel2007_Worksheet\_writeLegacyDrawing
_writeLegacyDrawing(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write LegacyDrawing.
Definition: Worksheet.php:1194
PHPExcel_Style_Conditional\OPERATOR_NOTCONTAINS
const OPERATOR_NOTCONTAINS
Definition: Conditional.php:55
PHPExcel_Writer_Excel2007_Worksheet\writeWorksheet
writeWorksheet($pSheet=null, $pStringTable=null, $includeCharts=FALSE)
Write worksheet to XML format.
Definition: Worksheet.php:47