New file |
0,0 → 1,701 |
<?php |
/** |
* PHPExcel |
* |
* Copyright (c) 2006 - 2013 PHPExcel |
* |
* This library is free software; you can redistribute it and/or |
* modify it under the terms of the GNU Lesser General Public |
* License as published by the Free Software Foundation; either |
* version 2.1 of the License, or (at your option) any later version. |
* |
* This library is distributed in the hope that it will be useful, |
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
* Lesser General Public License for more details. |
* |
* You should have received a copy of the GNU Lesser General Public |
* License along with this library; if not, write to the Free Software |
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA |
* |
* @category PHPExcel |
* @package PHPExcel_Writer_Excel2007 |
* @copyright Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel) |
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL |
* @version ##VERSION##, ##DATE## |
*/ |
|
|
/** |
* PHPExcel_Writer_Excel2007_Style |
* |
* @category PHPExcel |
* @package PHPExcel_Writer_Excel2007 |
* @copyright Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel) |
*/ |
class PHPExcel_Writer_Excel2007_Style extends PHPExcel_Writer_Excel2007_WriterPart |
{ |
/** |
* Write styles to XML format |
* |
* @param PHPExcel $pPHPExcel |
* @return string XML Output |
* @throws PHPExcel_Writer_Exception |
*/ |
public function writeStyles(PHPExcel $pPHPExcel = null) |
{ |
// Create XML writer |
$objWriter = null; |
if ($this->getParentWriter()->getUseDiskCaching()) { |
$objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory()); |
} else { |
$objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY); |
} |
|
// XML header |
$objWriter->startDocument('1.0','UTF-8','yes'); |
|
// styleSheet |
$objWriter->startElement('styleSheet'); |
$objWriter->writeAttribute('xml:space', 'preserve'); |
$objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main'); |
|
// numFmts |
$objWriter->startElement('numFmts'); |
$objWriter->writeAttribute('count', $this->getParentWriter()->getNumFmtHashTable()->count()); |
|
// numFmt |
for ($i = 0; $i < $this->getParentWriter()->getNumFmtHashTable()->count(); ++$i) { |
$this->_writeNumFmt($objWriter, $this->getParentWriter()->getNumFmtHashTable()->getByIndex($i), $i); |
} |
|
$objWriter->endElement(); |
|
// fonts |
$objWriter->startElement('fonts'); |
$objWriter->writeAttribute('count', $this->getParentWriter()->getFontHashTable()->count()); |
|
// font |
for ($i = 0; $i < $this->getParentWriter()->getFontHashTable()->count(); ++$i) { |
$this->_writeFont($objWriter, $this->getParentWriter()->getFontHashTable()->getByIndex($i)); |
} |
|
$objWriter->endElement(); |
|
// fills |
$objWriter->startElement('fills'); |
$objWriter->writeAttribute('count', $this->getParentWriter()->getFillHashTable()->count()); |
|
// fill |
for ($i = 0; $i < $this->getParentWriter()->getFillHashTable()->count(); ++$i) { |
$this->_writeFill($objWriter, $this->getParentWriter()->getFillHashTable()->getByIndex($i)); |
} |
|
$objWriter->endElement(); |
|
// borders |
$objWriter->startElement('borders'); |
$objWriter->writeAttribute('count', $this->getParentWriter()->getBordersHashTable()->count()); |
|
// border |
for ($i = 0; $i < $this->getParentWriter()->getBordersHashTable()->count(); ++$i) { |
$this->_writeBorder($objWriter, $this->getParentWriter()->getBordersHashTable()->getByIndex($i)); |
} |
|
$objWriter->endElement(); |
|
// cellStyleXfs |
$objWriter->startElement('cellStyleXfs'); |
$objWriter->writeAttribute('count', 1); |
|
// xf |
$objWriter->startElement('xf'); |
$objWriter->writeAttribute('numFmtId', 0); |
$objWriter->writeAttribute('fontId', 0); |
$objWriter->writeAttribute('fillId', 0); |
$objWriter->writeAttribute('borderId', 0); |
$objWriter->endElement(); |
|
$objWriter->endElement(); |
|
// cellXfs |
$objWriter->startElement('cellXfs'); |
$objWriter->writeAttribute('count', count($pPHPExcel->getCellXfCollection())); |
|
// xf |
foreach ($pPHPExcel->getCellXfCollection() as $cellXf) { |
$this->_writeCellStyleXf($objWriter, $cellXf, $pPHPExcel); |
} |
|
$objWriter->endElement(); |
|
// cellStyles |
$objWriter->startElement('cellStyles'); |
$objWriter->writeAttribute('count', 1); |
|
// cellStyle |
$objWriter->startElement('cellStyle'); |
$objWriter->writeAttribute('name', 'Normal'); |
$objWriter->writeAttribute('xfId', 0); |
$objWriter->writeAttribute('builtinId', 0); |
$objWriter->endElement(); |
|
$objWriter->endElement(); |
|
// dxfs |
$objWriter->startElement('dxfs'); |
$objWriter->writeAttribute('count', $this->getParentWriter()->getStylesConditionalHashTable()->count()); |
|
// dxf |
for ($i = 0; $i < $this->getParentWriter()->getStylesConditionalHashTable()->count(); ++$i) { |
$this->_writeCellStyleDxf($objWriter, $this->getParentWriter()->getStylesConditionalHashTable()->getByIndex($i)->getStyle()); |
} |
|
$objWriter->endElement(); |
|
// tableStyles |
$objWriter->startElement('tableStyles'); |
$objWriter->writeAttribute('defaultTableStyle', 'TableStyleMedium9'); |
$objWriter->writeAttribute('defaultPivotStyle', 'PivotTableStyle1'); |
$objWriter->endElement(); |
|
$objWriter->endElement(); |
|
// Return |
return $objWriter->getData(); |
} |
|
/** |
* Write Fill |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param PHPExcel_Style_Fill $pFill Fill style |
* @throws PHPExcel_Writer_Exception |
*/ |
private function _writeFill(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Fill $pFill = null) |
{ |
// Check if this is a pattern type or gradient type |
if ($pFill->getFillType() === PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR || |
$pFill->getFillType() === PHPExcel_Style_Fill::FILL_GRADIENT_PATH) { |
// Gradient fill |
$this->_writeGradientFill($objWriter, $pFill); |
} elseif($pFill->getFillType() !== NULL) { |
// Pattern fill |
$this->_writePatternFill($objWriter, $pFill); |
} |
} |
|
/** |
* Write Gradient Fill |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param PHPExcel_Style_Fill $pFill Fill style |
* @throws PHPExcel_Writer_Exception |
*/ |
private function _writeGradientFill(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Fill $pFill = null) |
{ |
// fill |
$objWriter->startElement('fill'); |
|
// gradientFill |
$objWriter->startElement('gradientFill'); |
$objWriter->writeAttribute('type', $pFill->getFillType()); |
$objWriter->writeAttribute('degree', $pFill->getRotation()); |
|
// stop |
$objWriter->startElement('stop'); |
$objWriter->writeAttribute('position', '0'); |
|
// color |
$objWriter->startElement('color'); |
$objWriter->writeAttribute('rgb', $pFill->getStartColor()->getARGB()); |
$objWriter->endElement(); |
|
$objWriter->endElement(); |
|
// stop |
$objWriter->startElement('stop'); |
$objWriter->writeAttribute('position', '1'); |
|
// color |
$objWriter->startElement('color'); |
$objWriter->writeAttribute('rgb', $pFill->getEndColor()->getARGB()); |
$objWriter->endElement(); |
|
$objWriter->endElement(); |
|
$objWriter->endElement(); |
|
$objWriter->endElement(); |
} |
|
/** |
* Write Pattern Fill |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param PHPExcel_Style_Fill $pFill Fill style |
* @throws PHPExcel_Writer_Exception |
*/ |
private function _writePatternFill(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Fill $pFill = null) |
{ |
// fill |
$objWriter->startElement('fill'); |
|
// patternFill |
$objWriter->startElement('patternFill'); |
$objWriter->writeAttribute('patternType', $pFill->getFillType()); |
|
if ($pFill->getFillType() !== PHPExcel_Style_Fill::FILL_NONE) { |
// fgColor |
if ($pFill->getStartColor()->getARGB()) { |
$objWriter->startElement('fgColor'); |
$objWriter->writeAttribute('rgb', $pFill->getStartColor()->getARGB()); |
$objWriter->endElement(); |
} |
} |
if ($pFill->getFillType() !== PHPExcel_Style_Fill::FILL_NONE) { |
// bgColor |
if ($pFill->getEndColor()->getARGB()) { |
$objWriter->startElement('bgColor'); |
$objWriter->writeAttribute('rgb', $pFill->getEndColor()->getARGB()); |
$objWriter->endElement(); |
} |
} |
|
$objWriter->endElement(); |
|
$objWriter->endElement(); |
} |
|
/** |
* Write Font |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param PHPExcel_Style_Font $pFont Font style |
* @throws PHPExcel_Writer_Exception |
*/ |
private function _writeFont(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Font $pFont = null) |
{ |
// font |
$objWriter->startElement('font'); |
// Weird! The order of these elements actually makes a difference when opening Excel2007 |
// files in Excel2003 with the compatibility pack. It's not documented behaviour, |
// and makes for a real WTF! |
|
// Bold. We explicitly write this element also when false (like MS Office Excel 2007 does |
// for conditional formatting). Otherwise it will apparently not be picked up in conditional |
// formatting style dialog |
if ($pFont->getBold() !== NULL) { |
$objWriter->startElement('b'); |
$objWriter->writeAttribute('val', $pFont->getBold() ? '1' : '0'); |
$objWriter->endElement(); |
} |
|
// Italic |
if ($pFont->getItalic() !== NULL) { |
$objWriter->startElement('i'); |
$objWriter->writeAttribute('val', $pFont->getItalic() ? '1' : '0'); |
$objWriter->endElement(); |
} |
|
// Strikethrough |
if ($pFont->getStrikethrough() !== NULL) { |
$objWriter->startElement('strike'); |
$objWriter->writeAttribute('val', $pFont->getStrikethrough() ? '1' : '0'); |
$objWriter->endElement(); |
} |
|
// Underline |
if ($pFont->getUnderline() !== NULL) { |
$objWriter->startElement('u'); |
$objWriter->writeAttribute('val', $pFont->getUnderline()); |
$objWriter->endElement(); |
} |
|
// Superscript / subscript |
if ($pFont->getSuperScript() === TRUE || $pFont->getSubScript() === TRUE) { |
$objWriter->startElement('vertAlign'); |
if ($pFont->getSuperScript() === TRUE) { |
$objWriter->writeAttribute('val', 'superscript'); |
} else if ($pFont->getSubScript() === TRUE) { |
$objWriter->writeAttribute('val', 'subscript'); |
} |
$objWriter->endElement(); |
} |
|
// Size |
if ($pFont->getSize() !== NULL) { |
$objWriter->startElement('sz'); |
$objWriter->writeAttribute('val', $pFont->getSize()); |
$objWriter->endElement(); |
} |
|
// Foreground color |
if ($pFont->getColor()->getARGB() !== NULL) { |
$objWriter->startElement('color'); |
$objWriter->writeAttribute('rgb', $pFont->getColor()->getARGB()); |
$objWriter->endElement(); |
} |
|
// Name |
if ($pFont->getName() !== NULL) { |
$objWriter->startElement('name'); |
$objWriter->writeAttribute('val', $pFont->getName()); |
$objWriter->endElement(); |
} |
|
$objWriter->endElement(); |
} |
|
/** |
* Write Border |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param PHPExcel_Style_Borders $pBorders Borders style |
* @throws PHPExcel_Writer_Exception |
*/ |
private function _writeBorder(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Borders $pBorders = null) |
{ |
// Write border |
$objWriter->startElement('border'); |
// Diagonal? |
switch ($pBorders->getDiagonalDirection()) { |
case PHPExcel_Style_Borders::DIAGONAL_UP: |
$objWriter->writeAttribute('diagonalUp', 'true'); |
$objWriter->writeAttribute('diagonalDown', 'false'); |
break; |
case PHPExcel_Style_Borders::DIAGONAL_DOWN: |
$objWriter->writeAttribute('diagonalUp', 'false'); |
$objWriter->writeAttribute('diagonalDown', 'true'); |
break; |
case PHPExcel_Style_Borders::DIAGONAL_BOTH: |
$objWriter->writeAttribute('diagonalUp', 'true'); |
$objWriter->writeAttribute('diagonalDown', 'true'); |
break; |
} |
|
// BorderPr |
$this->_writeBorderPr($objWriter, 'left', $pBorders->getLeft()); |
$this->_writeBorderPr($objWriter, 'right', $pBorders->getRight()); |
$this->_writeBorderPr($objWriter, 'top', $pBorders->getTop()); |
$this->_writeBorderPr($objWriter, 'bottom', $pBorders->getBottom()); |
$this->_writeBorderPr($objWriter, 'diagonal', $pBorders->getDiagonal()); |
$objWriter->endElement(); |
} |
|
/** |
* Write Cell Style Xf |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param PHPExcel_Style $pStyle Style |
* @param PHPExcel $pPHPExcel Workbook |
* @throws PHPExcel_Writer_Exception |
*/ |
private function _writeCellStyleXf(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style $pStyle = null, PHPExcel $pPHPExcel = null) |
{ |
// xf |
$objWriter->startElement('xf'); |
$objWriter->writeAttribute('xfId', 0); |
$objWriter->writeAttribute('fontId', (int)$this->getParentWriter()->getFontHashTable()->getIndexForHashCode($pStyle->getFont()->getHashCode())); |
|
if ($pStyle->getNumberFormat()->getBuiltInFormatCode() === false) { |
$objWriter->writeAttribute('numFmtId', (int)($this->getParentWriter()->getNumFmtHashTable()->getIndexForHashCode($pStyle->getNumberFormat()->getHashCode()) + 164) ); |
} else { |
$objWriter->writeAttribute('numFmtId', (int)$pStyle->getNumberFormat()->getBuiltInFormatCode()); |
} |
|
$objWriter->writeAttribute('fillId', (int)$this->getParentWriter()->getFillHashTable()->getIndexForHashCode($pStyle->getFill()->getHashCode())); |
$objWriter->writeAttribute('borderId', (int)$this->getParentWriter()->getBordersHashTable()->getIndexForHashCode($pStyle->getBorders()->getHashCode())); |
|
// Apply styles? |
$objWriter->writeAttribute('applyFont', ($pPHPExcel->getDefaultStyle()->getFont()->getHashCode() != $pStyle->getFont()->getHashCode()) ? '1' : '0'); |
$objWriter->writeAttribute('applyNumberFormat', ($pPHPExcel->getDefaultStyle()->getNumberFormat()->getHashCode() != $pStyle->getNumberFormat()->getHashCode()) ? '1' : '0'); |
$objWriter->writeAttribute('applyFill', ($pPHPExcel->getDefaultStyle()->getFill()->getHashCode() != $pStyle->getFill()->getHashCode()) ? '1' : '0'); |
$objWriter->writeAttribute('applyBorder', ($pPHPExcel->getDefaultStyle()->getBorders()->getHashCode() != $pStyle->getBorders()->getHashCode()) ? '1' : '0'); |
$objWriter->writeAttribute('applyAlignment', ($pPHPExcel->getDefaultStyle()->getAlignment()->getHashCode() != $pStyle->getAlignment()->getHashCode()) ? '1' : '0'); |
if ($pStyle->getProtection()->getLocked() != PHPExcel_Style_Protection::PROTECTION_INHERIT || $pStyle->getProtection()->getHidden() != PHPExcel_Style_Protection::PROTECTION_INHERIT) { |
$objWriter->writeAttribute('applyProtection', 'true'); |
} |
|
// alignment |
$objWriter->startElement('alignment'); |
$objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal()); |
$objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical()); |
|
$textRotation = 0; |
if ($pStyle->getAlignment()->getTextRotation() >= 0) { |
$textRotation = $pStyle->getAlignment()->getTextRotation(); |
} else if ($pStyle->getAlignment()->getTextRotation() < 0) { |
$textRotation = 90 - $pStyle->getAlignment()->getTextRotation(); |
} |
$objWriter->writeAttribute('textRotation', $textRotation); |
|
$objWriter->writeAttribute('wrapText', ($pStyle->getAlignment()->getWrapText() ? 'true' : 'false')); |
$objWriter->writeAttribute('shrinkToFit', ($pStyle->getAlignment()->getShrinkToFit() ? 'true' : 'false')); |
|
if ($pStyle->getAlignment()->getIndent() > 0) { |
$objWriter->writeAttribute('indent', $pStyle->getAlignment()->getIndent()); |
} |
$objWriter->endElement(); |
|
// protection |
if ($pStyle->getProtection()->getLocked() != PHPExcel_Style_Protection::PROTECTION_INHERIT || $pStyle->getProtection()->getHidden() != PHPExcel_Style_Protection::PROTECTION_INHERIT) { |
$objWriter->startElement('protection'); |
if ($pStyle->getProtection()->getLocked() != PHPExcel_Style_Protection::PROTECTION_INHERIT) { |
$objWriter->writeAttribute('locked', ($pStyle->getProtection()->getLocked() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false')); |
} |
if ($pStyle->getProtection()->getHidden() != PHPExcel_Style_Protection::PROTECTION_INHERIT) { |
$objWriter->writeAttribute('hidden', ($pStyle->getProtection()->getHidden() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false')); |
} |
$objWriter->endElement(); |
} |
|
$objWriter->endElement(); |
} |
|
/** |
* Write Cell Style Dxf |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param PHPExcel_Style $pStyle Style |
* @throws PHPExcel_Writer_Exception |
*/ |
private function _writeCellStyleDxf(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style $pStyle = null) |
{ |
// dxf |
$objWriter->startElement('dxf'); |
|
// font |
$this->_writeFont($objWriter, $pStyle->getFont()); |
|
// numFmt |
$this->_writeNumFmt($objWriter, $pStyle->getNumberFormat()); |
|
// fill |
$this->_writeFill($objWriter, $pStyle->getFill()); |
|
// alignment |
$objWriter->startElement('alignment'); |
if ($pStyle->getAlignment()->getHorizontal() !== NULL) { |
$objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal()); |
} |
if ($pStyle->getAlignment()->getVertical() !== NULL) { |
$objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical()); |
} |
|
if ($pStyle->getAlignment()->getTextRotation() !== NULL) { |
$textRotation = 0; |
if ($pStyle->getAlignment()->getTextRotation() >= 0) { |
$textRotation = $pStyle->getAlignment()->getTextRotation(); |
} else if ($pStyle->getAlignment()->getTextRotation() < 0) { |
$textRotation = 90 - $pStyle->getAlignment()->getTextRotation(); |
} |
$objWriter->writeAttribute('textRotation', $textRotation); |
} |
$objWriter->endElement(); |
|
// border |
$this->_writeBorder($objWriter, $pStyle->getBorders()); |
|
// protection |
if (($pStyle->getProtection()->getLocked() !== NULL) || |
($pStyle->getProtection()->getHidden() !== NULL)) { |
if ($pStyle->getProtection()->getLocked() !== PHPExcel_Style_Protection::PROTECTION_INHERIT || |
$pStyle->getProtection()->getHidden() !== PHPExcel_Style_Protection::PROTECTION_INHERIT) { |
$objWriter->startElement('protection'); |
if (($pStyle->getProtection()->getLocked() !== NULL) && |
($pStyle->getProtection()->getLocked() !== PHPExcel_Style_Protection::PROTECTION_INHERIT)) { |
$objWriter->writeAttribute('locked', ($pStyle->getProtection()->getLocked() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false')); |
} |
if (($pStyle->getProtection()->getHidden() !== NULL) && |
($pStyle->getProtection()->getHidden() !== PHPExcel_Style_Protection::PROTECTION_INHERIT)) { |
$objWriter->writeAttribute('hidden', ($pStyle->getProtection()->getHidden() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false')); |
} |
$objWriter->endElement(); |
} |
} |
|
$objWriter->endElement(); |
} |
|
/** |
* Write BorderPr |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param string $pName Element name |
* @param PHPExcel_Style_Border $pBorder Border style |
* @throws PHPExcel_Writer_Exception |
*/ |
private function _writeBorderPr(PHPExcel_Shared_XMLWriter $objWriter = null, $pName = 'left', PHPExcel_Style_Border $pBorder = null) |
{ |
// Write BorderPr |
if ($pBorder->getBorderStyle() != PHPExcel_Style_Border::BORDER_NONE) { |
$objWriter->startElement($pName); |
$objWriter->writeAttribute('style', $pBorder->getBorderStyle()); |
|
// color |
$objWriter->startElement('color'); |
$objWriter->writeAttribute('rgb', $pBorder->getColor()->getARGB()); |
$objWriter->endElement(); |
|
$objWriter->endElement(); |
} |
} |
|
/** |
* Write NumberFormat |
* |
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer |
* @param PHPExcel_Style_NumberFormat $pNumberFormat Number Format |
* @param int $pId Number Format identifier |
* @throws PHPExcel_Writer_Exception |
*/ |
private function _writeNumFmt(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_NumberFormat $pNumberFormat = null, $pId = 0) |
{ |
// Translate formatcode |
$formatCode = $pNumberFormat->getFormatCode(); |
|
// numFmt |
if ($formatCode !== NULL) { |
$objWriter->startElement('numFmt'); |
$objWriter->writeAttribute('numFmtId', ($pId + 164)); |
$objWriter->writeAttribute('formatCode', $formatCode); |
$objWriter->endElement(); |
} |
} |
|
/** |
* Get an array of all styles |
* |
* @param PHPExcel $pPHPExcel |
* @return PHPExcel_Style[] All styles in PHPExcel |
* @throws PHPExcel_Writer_Exception |
*/ |
public function allStyles(PHPExcel $pPHPExcel = null) |
{ |
$aStyles = $pPHPExcel->getCellXfCollection(); |
|
return $aStyles; |
} |
|
/** |
* Get an array of all conditional styles |
* |
* @param PHPExcel $pPHPExcel |
* @return PHPExcel_Style_Conditional[] All conditional styles in PHPExcel |
* @throws PHPExcel_Writer_Exception |
*/ |
public function allConditionalStyles(PHPExcel $pPHPExcel = null) |
{ |
// Get an array of all styles |
$aStyles = array(); |
|
$sheetCount = $pPHPExcel->getSheetCount(); |
for ($i = 0; $i < $sheetCount; ++$i) { |
foreach ($pPHPExcel->getSheet($i)->getConditionalStylesCollection() as $conditionalStyles) { |
foreach ($conditionalStyles as $conditionalStyle) { |
$aStyles[] = $conditionalStyle; |
} |
} |
} |
|
return $aStyles; |
} |
|
/** |
* Get an array of all fills |
* |
* @param PHPExcel $pPHPExcel |
* @return PHPExcel_Style_Fill[] All fills in PHPExcel |
* @throws PHPExcel_Writer_Exception |
*/ |
public function allFills(PHPExcel $pPHPExcel = null) |
{ |
// Get an array of unique fills |
$aFills = array(); |
|
// Two first fills are predefined |
$fill0 = new PHPExcel_Style_Fill(); |
$fill0->setFillType(PHPExcel_Style_Fill::FILL_NONE); |
$aFills[] = $fill0; |
|
$fill1 = new PHPExcel_Style_Fill(); |
$fill1->setFillType(PHPExcel_Style_Fill::FILL_PATTERN_GRAY125); |
$aFills[] = $fill1; |
// The remaining fills |
$aStyles = $this->allStyles($pPHPExcel); |
foreach ($aStyles as $style) { |
if (!array_key_exists($style->getFill()->getHashCode(), $aFills)) { |
$aFills[ $style->getFill()->getHashCode() ] = $style->getFill(); |
} |
} |
|
return $aFills; |
} |
|
/** |
* Get an array of all fonts |
* |
* @param PHPExcel $pPHPExcel |
* @return PHPExcel_Style_Font[] All fonts in PHPExcel |
* @throws PHPExcel_Writer_Exception |
*/ |
public function allFonts(PHPExcel $pPHPExcel = null) |
{ |
// Get an array of unique fonts |
$aFonts = array(); |
$aStyles = $this->allStyles($pPHPExcel); |
|
foreach ($aStyles as $style) { |
if (!array_key_exists($style->getFont()->getHashCode(), $aFonts)) { |
$aFonts[ $style->getFont()->getHashCode() ] = $style->getFont(); |
} |
} |
|
return $aFonts; |
} |
|
/** |
* Get an array of all borders |
* |
* @param PHPExcel $pPHPExcel |
* @return PHPExcel_Style_Borders[] All borders in PHPExcel |
* @throws PHPExcel_Writer_Exception |
*/ |
public function allBorders(PHPExcel $pPHPExcel = null) |
{ |
// Get an array of unique borders |
$aBorders = array(); |
$aStyles = $this->allStyles($pPHPExcel); |
|
foreach ($aStyles as $style) { |
if (!array_key_exists($style->getBorders()->getHashCode(), $aBorders)) { |
$aBorders[ $style->getBorders()->getHashCode() ] = $style->getBorders(); |
} |
} |
|
return $aBorders; |
} |
|
/** |
* Get an array of all number formats |
* |
* @param PHPExcel $pPHPExcel |
* @return PHPExcel_Style_NumberFormat[] All number formats in PHPExcel |
* @throws PHPExcel_Writer_Exception |
*/ |
public function allNumberFormats(PHPExcel $pPHPExcel = null) |
{ |
// Get an array of unique number formats |
$aNumFmts = array(); |
$aStyles = $this->allStyles($pPHPExcel); |
|
foreach ($aStyles as $style) { |
if ($style->getNumberFormat()->getBuiltInFormatCode() === false && !array_key_exists($style->getNumberFormat()->getHashCode(), $aNumFmts)) { |
$aNumFmts[ $style->getNumberFormat()->getHashCode() ] = $style->getNumberFormat(); |
} |
} |
|
return $aNumFmts; |
} |
} |