ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
Public Member Functions | Private Member Functions
PHPExcel_Writer_Excel2007_Worksheet Class Reference
+ Inheritance diagram for PHPExcel_Writer_Excel2007_Worksheet:
+ Collaboration diagram for PHPExcel_Writer_Excel2007_Worksheet:

Public Member Functions

 writeWorksheet ($pSheet=null, $pStringTable=null, $includeCharts=FALSE)
 Write worksheet to XML format. More...
 
- Public Member Functions inherited from PHPExcel_Writer_Excel2007_WriterPart
 setParentWriter (PHPExcel_Writer_IWriter $pWriter=null)
 Set parent IWriter object. More...
 
 getParentWriter ()
 Get parent IWriter object. More...
 
 __construct (PHPExcel_Writer_IWriter $pWriter=null)
 Set parent IWriter object. More...
 

Private Member Functions

 _writeSheetPr (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write SheetPr. More...
 
 _writeDimension (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write Dimension. More...
 
 _writeSheetViews (PHPExcel_Shared_XMLWriter $objWriter=NULL, PHPExcel_Worksheet $pSheet=NULL)
 Write SheetViews. More...
 
 _writeSheetFormatPr (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write SheetFormatPr. More...
 
 _writeCols (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write Cols. More...
 
 _writeSheetProtection (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write SheetProtection. More...
 
 _writeConditionalFormatting (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write ConditionalFormatting. More...
 
 _writeDataValidations (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write DataValidations. More...
 
 _writeHyperlinks (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write Hyperlinks. More...
 
 _writeProtectedRanges (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write ProtectedRanges. More...
 
 _writeMergeCells (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write MergeCells. More...
 
 _writePrintOptions (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write PrintOptions. More...
 
 _writePageMargins (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write PageMargins. More...
 
 _writeAutoFilter (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write AutoFilter. More...
 
 _writePageSetup (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write PageSetup. More...
 
 _writeHeaderFooter (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write Header / Footer. More...
 
 _writeBreaks (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write Breaks. More...
 
 _writeSheetData (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pStringTable=null)
 Write SheetData. More...
 
 _writeCell (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pCellAddress=null, $pStringTable=null, $pFlippedStringTable=null)
 Write Cell. More...
 
 _writeDrawings (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $includeCharts=FALSE)
 Write Drawings. More...
 
 _writeLegacyDrawing (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write LegacyDrawing. More...
 
 _writeLegacyDrawingHF (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
 Write LegacyDrawingHF. More...
 

Detailed Description

Definition at line 36 of file Worksheet.php.

Member Function Documentation

◆ _writeAutoFilter()

PHPExcel_Writer_Excel2007_Worksheet::_writeAutoFilter ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write AutoFilter.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 749 of file Worksheet.php.

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 }
$objWriter
$objWriter
Definition: 01pharSimple.php:81
$column
$column
Definition: 39dropdown.php:62
$columns
if(! $in) $columns
Definition: Utf8Test.php:45
PHPExcel_Cell\splitRange
static splitRange($pRange='A1:A1')
Split range into coordinate strings.
Definition: Cell.php:660
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_COLUMN_RULE_TOPTEN_TOP
const AUTOFILTER_COLUMN_RULE_TOPTEN_TOP
Definition: Rule.php:189
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT
const AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT
Definition: Rule.php:182
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_COLUMN_RULE_EQUAL
const AUTOFILTER_COLUMN_RULE_EQUAL
Definition: Rule.php:165
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_RULETYPE_DYNAMICFILTER
const AUTOFILTER_RULETYPE_DYNAMICFILTER
Definition: Rule.php:41
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_RULETYPE_TOPTENFILTER
const AUTOFILTER_RULETYPE_TOPTENFILTER
Definition: Rule.php:42
PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_RULETYPE_DATEGROUP
const AUTOFILTER_RULETYPE_DATEGROUP
Definition: Rule.php:39
PHPExcel_Worksheet_AutoFilter_Column\AUTOFILTER_FILTERTYPE_FILTER
const AUTOFILTER_FILTERTYPE_FILTER
Definition: Column.php:38
PHPExcel_Worksheet_AutoFilter_Column\AUTOFILTER_COLUMN_JOIN_AND
const AUTOFILTER_COLUMN_JOIN_AND
Definition: Column.php:64
PHPExcel_Worksheet\getAutoFilter
getAutoFilter()
Get Autofilter.
Definition: Worksheet.php:1892
$key
$key
Definition: croninfo.php:18
$rule
$rule
Definition: showstats.php:43

References $column, $columns, $key, $objWriter, $rule, PHPExcel_Worksheet_AutoFilter_Column\AUTOFILTER_COLUMN_JOIN_AND, PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_COLUMN_RULE_EQUAL, PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT, PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_COLUMN_RULE_TOPTEN_TOP, PHPExcel_Worksheet_AutoFilter_Column\AUTOFILTER_FILTERTYPE_FILTER, PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_RULETYPE_DATEGROUP, PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_RULETYPE_DYNAMICFILTER, PHPExcel_Worksheet_AutoFilter_Column_Rule\AUTOFILTER_RULETYPE_TOPTENFILTER, and PHPExcel_Cell\splitRange().

Referenced by writeWorksheet().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeBreaks()

PHPExcel_Writer_Excel2007_Worksheet::_writeBreaks ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write Breaks.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 901 of file Worksheet.php.

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 }
PHPExcel_Cell\coordinateFromString
static coordinateFromString($pCoordinateString='A1')
Coordinate from string.
Definition: Cell.php:580
PHPExcel_Cell\columnIndexFromString
static columnIndexFromString($pString='A')
Column index from string.
Definition: Cell.php:782
PHPExcel_Worksheet\getBreaks
getBreaks()
Get breaks.
Definition: Worksheet.php:1675
PHPExcel_Worksheet\BREAK_ROW
const BREAK_ROW
Definition: Worksheet.php:40
PHPExcel_Worksheet\BREAK_COLUMN
const BREAK_COLUMN
Definition: Worksheet.php:41
$coords
$coords
Definition: example_030.php:88

References $coords, $objWriter, PHPExcel_Worksheet\BREAK_COLUMN, PHPExcel_Worksheet\BREAK_ROW, PHPExcel_Cell\columnIndexFromString(), and PHPExcel_Cell\coordinateFromString().

Referenced by writeWorksheet().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeCell()

PHPExcel_Writer_Excel2007_Worksheet::_writeCell ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null,
  $pCellAddress = null,
  $pStringTable = null,
  $pFlippedStringTable = null 
)
private

Write Cell.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
PHPExcel_Cell$pCellAddressCell Address
string[]$pStringTableString table
string[]$pFlippedStringTableString table (flipped), for faster index searching
Exceptions
PHPExcel_Writer_Exception

Definition at line 1056 of file Worksheet.php.

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 }
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_Shared_String\ControlCharacterPHP2OOXML
static ControlCharacterPHP2OOXML($value='')
Convert from PHP control character to OpenXML escaped control character.
Definition: String.php:373
PHPExcel_Worksheet\getCell
getCell($pCoordinate='A1')
Get cell at a specific coordinate.
Definition: Worksheet.php:1153
PHPExcel_Writer_Excel2007_WriterPart\getParentWriter
getParentWriter()
Get parent IWriter object.
Definition: WriterPart.php:61
PHPExcel_Writer_Exception
Definition: Exception.php:36
PHPExcel_RichText
$attributes
$attributes
Definition: serviceValidate.php:33

References $attributes, $objWriter, PHPExcel_Shared_String\ControlCharacterPHP2OOXML(), PHPExcel_Shared_String\FormatNumber(), and PHPExcel_Writer_Excel2007_WriterPart\getParentWriter().

Referenced by _writeSheetData().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeCols()

PHPExcel_Writer_Excel2007_Worksheet::_writeCols ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write Cols.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 367 of file Worksheet.php.

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 }
PHPExcel_Worksheet\calculateColumnWidths
calculateColumnWidths($calculateMergeCells=false)
Calculate widths for auto-size columns.
Definition: Worksheet.php:724
PHPExcel_Worksheet\getDefaultColumnDimension
getDefaultColumnDimension()
Get default column dimension.
Definition: Worksheet.php:544
PHPExcel_Worksheet\getColumnDimensions
getColumnDimensions()
Get collection of column dimensions.
Definition: Worksheet.php:534

References $objWriter, PHPExcel_Cell\columnIndexFromString(), and PHPExcel_Shared_String\FormatNumber().

Referenced by writeWorksheet().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeConditionalFormatting()

PHPExcel_Writer_Excel2007_Worksheet::_writeConditionalFormatting ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write ConditionalFormatting.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 467 of file Worksheet.php.

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 }
PHPExcel_Style_Conditional\CONDITION_EXPRESSION
const CONDITION_EXPRESSION
Definition: Conditional.php:42
PHPExcel_Style_Conditional\CONDITION_NONE
const CONDITION_NONE
Definition: Conditional.php:39
PHPExcel_Style_Conditional\OPERATOR_NOTCONTAINS
const OPERATOR_NOTCONTAINS
Definition: Conditional.php:55
PHPExcel_Style_Conditional\OPERATOR_CONTAINSTEXT
const OPERATOR_CONTAINSTEXT
Definition: Conditional.php:54
PHPExcel_Style_Conditional\OPERATOR_BEGINSWITH
const OPERATOR_BEGINSWITH
Definition: Conditional.php:46
PHPExcel_Style_Conditional\CONDITION_CONTAINSTEXT
const CONDITION_CONTAINSTEXT
Definition: Conditional.php:41
PHPExcel_Style_Conditional\OPERATOR_NONE
const OPERATOR_NONE
Definition: Conditional.php:45
PHPExcel_Style_Conditional\CONDITION_CELLIS
const CONDITION_CELLIS
Definition: Conditional.php:40
PHPExcel_Style_Conditional\OPERATOR_ENDSWITH
const OPERATOR_ENDSWITH
Definition: Conditional.php:47
PHPExcel_Worksheet\getConditionalStylesCollection
getConditionalStylesCollection()
Get collection of conditional styles.
Definition: Worksheet.php:1470
$id
if(!array_key_exists('StateId', $_REQUEST)) $id
Definition: expirywarning.php:14

References $conditionalStyles, $id, $objWriter, PHPExcel_Style_Conditional\CONDITION_CELLIS, PHPExcel_Style_Conditional\CONDITION_CONTAINSTEXT, PHPExcel_Style_Conditional\CONDITION_EXPRESSION, PHPExcel_Style_Conditional\CONDITION_NONE, PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), PHPExcel_Style_Conditional\OPERATOR_BEGINSWITH, PHPExcel_Style_Conditional\OPERATOR_CONTAINSTEXT, PHPExcel_Style_Conditional\OPERATOR_ENDSWITH, PHPExcel_Style_Conditional\OPERATOR_NONE, and PHPExcel_Style_Conditional\OPERATOR_NOTCONTAINS.

Referenced by writeWorksheet().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeDataValidations()

PHPExcel_Writer_Excel2007_Worksheet::_writeDataValidations ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write DataValidations.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 542 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getDataValidationCollection
getDataValidationCollection()
Get collection of data validations.
Definition: Worksheet.php:2774

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeDimension()

PHPExcel_Writer_Excel2007_Worksheet::_writeDimension ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write Dimension.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 193 of file Worksheet.php.

194 {
195 // dimension
196 $objWriter->startElement('dimension');
197 $objWriter->writeAttribute('ref', $pSheet->calculateWorksheetDimension());
198 $objWriter->endElement();
199 }
PHPExcel_Worksheet\calculateWorksheetDimension
calculateWorksheetDimension()
Calculate worksheet dimension.
Definition: Worksheet.php:701

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeDrawings()

PHPExcel_Writer_Excel2007_Worksheet::_writeDrawings ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null,
  $includeCharts = FALSE 
)
private

Write Drawings.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
boolean$includeChartsFlag indicating if we should include drawing details for charts
Exceptions
PHPExcel_Writer_Exception

Definition at line 1175 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getChartCollection
getChartCollection()
Get collection of charts.
Definition: Worksheet.php:564
PHPExcel_Worksheet\getDrawingCollection
getDrawingCollection()
Get collection of drawings.
Definition: Worksheet.php:554

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeHeaderFooter()

PHPExcel_Writer_Excel2007_Worksheet::_writeHeaderFooter ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write Header / Footer.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 876 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getHeaderFooter
getHeaderFooter()
Get page header/footer.
Definition: Worksheet.php:958

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeHyperlinks()

PHPExcel_Writer_Excel2007_Worksheet::_writeHyperlinks ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write Hyperlinks.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 608 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getHyperlinkCollection
getHyperlinkCollection()
Get collection of hyperlinks.
Definition: Worksheet.php:2719

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeLegacyDrawing()

PHPExcel_Writer_Excel2007_Worksheet::_writeLegacyDrawing ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write LegacyDrawing.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 1194 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getComments
getComments()
Get comments.
Definition: Worksheet.php:2225

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeLegacyDrawingHF()

PHPExcel_Writer_Excel2007_Worksheet::_writeLegacyDrawingHF ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write LegacyDrawingHF.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 1211 of file Worksheet.php.

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 }

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeMergeCells()

PHPExcel_Writer_Excel2007_Worksheet::_writeMergeCells ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write MergeCells.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 678 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getMergeCells
getMergeCells()
Get merge cells array.
Definition: Worksheet.php:1781

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writePageMargins()

PHPExcel_Writer_Excel2007_Worksheet::_writePageMargins ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write PageMargins.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 729 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getPageMargins
getPageMargins()
Get page margins.
Definition: Worksheet.php:936

References $objWriter, and PHPExcel_Shared_String\FormatNumber().

Referenced by writeWorksheet().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writePageSetup()

PHPExcel_Writer_Excel2007_Worksheet::_writePageSetup ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write PageSetup.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 841 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getPageSetup
getPageSetup()
Get page setup.
Definition: Worksheet.php:914

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writePrintOptions()

PHPExcel_Writer_Excel2007_Worksheet::_writePrintOptions ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write PrintOptions.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 703 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getPrintGridlines
getPrintGridlines()
Print gridlines?
Definition: Worksheet.php:2145

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeProtectedRanges()

PHPExcel_Writer_Excel2007_Worksheet::_writeProtectedRanges ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write ProtectedRanges.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 649 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getProtectedCells
getProtectedCells()
Get protected cells.
Definition: Worksheet.php:1882

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeSheetData()

PHPExcel_Writer_Excel2007_Worksheet::_writeSheetData ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null,
  $pStringTable = null 
)
private

Write SheetData.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
string[]$pStringTableString table
Exceptions
PHPExcel_Writer_Exception

Definition at line 959 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getHighestColumn
getHighestColumn($row=null)
Get highest worksheet column.
Definition: Worksheet.php:1028
PHPExcel_Worksheet\getRowDimension
getRowDimension($pRow=1, $create=TRUE)
Get row dimension at a specific row.
Definition: Worksheet.php:1315
PHPExcel_Worksheet\getHighestRow
getHighestRow($column=null)
Get highest worksheet row.
Definition: Worksheet.php:1055
PHPExcel_Worksheet\getCellCollection
getCellCollection($pSorted=true)
Get collection of cells.
Definition: Worksheet.php:484
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

References $objWriter, _writeCell(), PHPExcel_Cell\columnIndexFromString(), PHPExcel_Cell\coordinateFromString(), PHPExcel_Shared_String\FormatNumber(), and PHPExcel_Writer_Excel2007_WriterPart\getParentWriter().

Referenced by writeWorksheet().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeSheetFormatPr()

PHPExcel_Writer_Excel2007_Worksheet::_writeSheetFormatPr ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write SheetFormatPr.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 315 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getDefaultRowDimension
getDefaultRowDimension()
Get default row dimension.
Definition: Worksheet.php:524
PHPExcel_Worksheet\getRowDimensions
getRowDimensions()
Get collection of row dimensions.
Definition: Worksheet.php:514

References $objWriter, and PHPExcel_Shared_String\FormatNumber().

Referenced by writeWorksheet().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeSheetPr()

PHPExcel_Writer_Excel2007_Worksheet::_writeSheetPr ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write SheetPr.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 146 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getShowSummaryRight
getShowSummaryRight()
Show summary right? (Row/Column outlining)
Definition: Worksheet.php:2205
PHPExcel_Worksheet\setCodeName
setCodeName($pValue=null)
Define the code name of the sheet.
Definition: Worksheet.php:2887
PHPExcel_Worksheet\getTabColor
getTabColor()
Get tab color.
Definition: Worksheet.php:2811
PHPExcel_Worksheet\isTabColorSet
isTabColorSet()
Tab color set?
Definition: Worksheet.php:2837
PHPExcel_Worksheet\getShowSummaryBelow
getShowSummaryBelow()
Show summary below? (Row/Column outlining)
Definition: Worksheet.php:2185
PHPExcel_Worksheet\getTitle
getTitle()
Get title.
Definition: Worksheet.php:817
PHPExcel_Worksheet\getCodeName
getCodeName()
Return the code name of the sheet.
Definition: Worksheet.php:2935
PHPExcel_Worksheet\hasCodeName
hasCodeName()
Sheet has a code name ?
Definition: Worksheet.php:2942
PHPExcel_Worksheet\getParent
getParent()
Get parent.
Definition: Worksheet.php:786

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeSheetProtection()

PHPExcel_Writer_Excel2007_Worksheet::_writeSheetProtection ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null 
)
private

Write SheetProtection.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 432 of file Worksheet.php.

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 }
PHPExcel_Worksheet\getProtection
getProtection()
Get Protection.
Definition: Worksheet.php:1002

References $objWriter.

Referenced by writeWorksheet().

+ Here is the caller graph for this function:

◆ _writeSheetViews()

PHPExcel_Writer_Excel2007_Worksheet::_writeSheetViews ( PHPExcel_Shared_XMLWriter  $objWriter = NULL,
PHPExcel_Worksheet  $pSheet = NULL 
)
private

Write SheetViews.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheetWorksheet
Exceptions
PHPExcel_Writer_Exception

Definition at line 208 of file Worksheet.php.

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 }
PHPExcel_Worksheet_SheetView\SHEETVIEW_NORMAL
const SHEETVIEW_NORMAL
Definition: SheetView.php:40
PHPExcel_Worksheet\getSheetView
getSheetView()
Get sheet view.
Definition: Worksheet.php:980
PHPExcel_Worksheet\getShowGridlines
getShowGridlines()
Show gridlines?
Definition: Worksheet.php:2125
PHPExcel_Worksheet\getRightToLeft
getRightToLeft()
Get right-to-left.
Definition: Worksheet.php:2380
PHPExcel_Worksheet\getActiveCell
getActiveCell()
Get active cell.
Definition: Worksheet.php:2302
PHPExcel_Worksheet\getFreezePane
getFreezePane()
Get Freeze Pane.
Definition: Worksheet.php:1952
PHPExcel_Worksheet\getShowRowColHeaders
getShowRowColHeaders()
Show row and column headers?
Definition: Worksheet.php:2165

References $objWriter, PHPExcel_Cell\columnIndexFromString(), PHPExcel_Cell\coordinateFromString(), PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), and PHPExcel_Worksheet_SheetView\SHEETVIEW_NORMAL.

Referenced by writeWorksheet().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ writeWorksheet()

PHPExcel_Writer_Excel2007_Worksheet::writeWorksheet (   $pSheet = null,
  $pStringTable = null,
  $includeCharts = FALSE 
)

Write worksheet to XML format.

Parameters
PHPExcel_Worksheet$pSheet
string[]$pStringTable
boolean$includeChartsFlag indicating if we should write charts
Returns
string XML Output
Exceptions
PHPExcel_Writer_Exception

Definition at line 47 of file Worksheet.php.

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 }
PHPExcel_Shared_XMLWriter
Definition: XMLWriter.php:44
PHPExcel_Shared_XMLWriter\STORAGE_DISK
const STORAGE_DISK
Definition: XMLWriter.php:47
PHPExcel_Shared_XMLWriter\STORAGE_MEMORY
const STORAGE_MEMORY
Temporary storage method.
Definition: XMLWriter.php:46
PHPExcel_Writer_Excel2007_Worksheet\_writeSheetData
_writeSheetData(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pStringTable=null)
Write SheetData.
Definition: Worksheet.php:959
PHPExcel_Writer_Excel2007_Worksheet\_writeConditionalFormatting
_writeConditionalFormatting(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write ConditionalFormatting.
Definition: Worksheet.php:467
PHPExcel_Writer_Excel2007_Worksheet\_writePageMargins
_writePageMargins(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write PageMargins.
Definition: Worksheet.php:729
PHPExcel_Writer_Excel2007_Worksheet\_writeSheetViews
_writeSheetViews(PHPExcel_Shared_XMLWriter $objWriter=NULL, PHPExcel_Worksheet $pSheet=NULL)
Write SheetViews.
Definition: Worksheet.php:208
PHPExcel_Writer_Excel2007_Worksheet\_writeLegacyDrawing
_writeLegacyDrawing(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write LegacyDrawing.
Definition: Worksheet.php:1194
PHPExcel_Writer_Excel2007_Worksheet\_writeCols
_writeCols(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write Cols.
Definition: Worksheet.php:367
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\_writeHeaderFooter
_writeHeaderFooter(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write Header / Footer.
Definition: Worksheet.php:876
PHPExcel_Writer_Excel2007_Worksheet\_writePrintOptions
_writePrintOptions(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write PrintOptions.
Definition: Worksheet.php:703
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\_writeDataValidations
_writeDataValidations(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write DataValidations.
Definition: Worksheet.php:542
PHPExcel_Writer_Excel2007_Worksheet\_writeDrawings
_writeDrawings(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $includeCharts=FALSE)
Write Drawings.
Definition: Worksheet.php:1175
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\_writeProtectedRanges
_writeProtectedRanges(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write ProtectedRanges.
Definition: Worksheet.php:649
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\_writeSheetPr
_writeSheetPr(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write SheetPr.
Definition: Worksheet.php:146
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\_writeAutoFilter
_writeAutoFilter(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write AutoFilter.
Definition: Worksheet.php:749
PHPExcel_Writer_Excel2007_Worksheet\_writeLegacyDrawingHF
_writeLegacyDrawingHF(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write LegacyDrawingHF.
Definition: Worksheet.php:1211
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\_writeMergeCells
_writeMergeCells(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null)
Write MergeCells.
Definition: Worksheet.php:678

References $objWriter, _writeAutoFilter(), _writeBreaks(), _writeCols(), _writeConditionalFormatting(), _writeDataValidations(), _writeDimension(), _writeDrawings(), _writeHeaderFooter(), _writeHyperlinks(), _writeLegacyDrawing(), _writeLegacyDrawingHF(), _writeMergeCells(), _writePageMargins(), _writePageSetup(), _writePrintOptions(), _writeProtectedRanges(), _writeSheetData(), _writeSheetFormatPr(), _writeSheetPr(), _writeSheetProtection(), _writeSheetViews(), PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), PHPExcel_Shared_XMLWriter\STORAGE_DISK, and PHPExcel_Shared_XMLWriter\STORAGE_MEMORY.

+ Here is the call graph for this function:
The documentation for this class was generated from the following file: