<?php
namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Style\Borders;
use PhpOffice\PhpSpreadsheet\Style\Conditional;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\Font;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;
use PhpOffice\PhpSpreadsheet\Style\Protection;
class Style extends WriterPart
{
/**
* Write styles to XML format.
*
< * @param Spreadsheet $spreadsheet
< *
< * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
< *
* @return string XML Output
*/
public function writeStyles(Spreadsheet $spreadsheet)
{
// Create XML writer
$objWriter = null;
if ($this->getParentWriter()->getUseDiskCaching()) {
$objWriter = new XMLWriter(XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
} else {
$objWriter = new XMLWriter(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($spreadsheet->getCellXfCollection()));
// xf
foreach ($spreadsheet->getCellXfCollection() as $cellXf) {
$this->writeCellStyleXf($objWriter, $cellXf, $spreadsheet);
}
$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 XMLWriter $objWriter XML Writer
< * @param Fill $pFill Fill style
*/
< private function writeFill(XMLWriter $objWriter, Fill $pFill)
> private function writeFill(XMLWriter $objWriter, Fill $fill): void
{
// Check if this is a pattern type or gradient type
< if ($pFill->getFillType() === Fill::FILL_GRADIENT_LINEAR ||
< $pFill->getFillType() === Fill::FILL_GRADIENT_PATH) {
> if (
> $fill->getFillType() === Fill::FILL_GRADIENT_LINEAR ||
> $fill->getFillType() === Fill::FILL_GRADIENT_PATH
> ) {
// Gradient fill
< $this->writeGradientFill($objWriter, $pFill);
< } elseif ($pFill->getFillType() !== null) {
> $this->writeGradientFill($objWriter, $fill);
> } elseif ($fill->getFillType() !== null) {
// Pattern fill
< $this->writePatternFill($objWriter, $pFill);
> $this->writePatternFill($objWriter, $fill);
}
}
/**
* Write Gradient Fill.
< *
< * @param XMLWriter $objWriter XML Writer
< * @param Fill $pFill Fill style
*/
< private function writeGradientFill(XMLWriter $objWriter, Fill $pFill)
> private function writeGradientFill(XMLWriter $objWriter, Fill $fill): void
{
// fill
$objWriter->startElement('fill');
// gradientFill
$objWriter->startElement('gradientFill');
< $objWriter->writeAttribute('type', $pFill->getFillType());
< $objWriter->writeAttribute('degree', $pFill->getRotation());
> $objWriter->writeAttribute('type', $fill->getFillType());
> $objWriter->writeAttribute('degree', $fill->getRotation());
// stop
$objWriter->startElement('stop');
$objWriter->writeAttribute('position', '0');
// color
$objWriter->startElement('color');
< $objWriter->writeAttribute('rgb', $pFill->getStartColor()->getARGB());
> $objWriter->writeAttribute('rgb', $fill->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->writeAttribute('rgb', $fill->getEndColor()->getARGB());
$objWriter->endElement();
$objWriter->endElement();
$objWriter->endElement();
$objWriter->endElement();
}
> private static function writePatternColors(Fill $fill): bool
/**
> {
* Write Pattern Fill.
> if ($fill->getFillType() === Fill::FILL_NONE) {
*
> return false;
* @param XMLWriter $objWriter XML Writer
> }
* @param Fill $pFill Fill style
>
*/
> return $fill->getFillType() === Fill::FILL_SOLID || $fill->getColorsChanged();
private function writePatternFill(XMLWriter $objWriter, Fill $pFill)
> }
{
>
< *
< * @param XMLWriter $objWriter XML Writer
< * @param Fill $pFill Fill style
< private function writePatternFill(XMLWriter $objWriter, Fill $pFill)
> private function writePatternFill(XMLWriter $objWriter, Fill $fill): void
$objWriter->startElement('patternFill');
< $objWriter->writeAttribute('patternType', $pFill->getFillType());
> $objWriter->writeAttribute('patternType', $fill->getFillType());
< if ($pFill->getFillType() !== Fill::FILL_NONE) {
> if (self::writePatternColors($fill)) {
// fgColor
< if ($pFill->getStartColor()->getARGB()) {
> if ($fill->getStartColor()->getARGB()) {
$objWriter->startElement('fgColor');
< $objWriter->writeAttribute('rgb', $pFill->getStartColor()->getARGB());
> $objWriter->writeAttribute('rgb', $fill->getStartColor()->getARGB());
$objWriter->endElement();
}
< }
< if ($pFill->getFillType() !== Fill::FILL_NONE) {
// bgColor
< if ($pFill->getEndColor()->getARGB()) {
> if ($fill->getEndColor()->getARGB()) {
$objWriter->startElement('bgColor');
< $objWriter->writeAttribute('rgb', $pFill->getEndColor()->getARGB());
> $objWriter->writeAttribute('rgb', $fill->getEndColor()->getARGB());
$objWriter->endElement();
}
}
$objWriter->endElement();
$objWriter->endElement();
}
/**
* Write Font.
< *
< * @param XMLWriter $objWriter XML Writer
< * @param Font $pFont Font style
*/
< private function writeFont(XMLWriter $objWriter, Font $pFont)
> private function writeFont(XMLWriter $objWriter, Font $font): void
{
// font
$objWriter->startElement('font');
// Weird! The order of these elements actually makes a difference when opening Xlsx
// 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) {
> if ($font->getBold() !== null) {
$objWriter->startElement('b');
< $objWriter->writeAttribute('val', $pFont->getBold() ? '1' : '0');
> $objWriter->writeAttribute('val', $font->getBold() ? '1' : '0');
$objWriter->endElement();
}
// Italic
< if ($pFont->getItalic() !== null) {
> if ($font->getItalic() !== null) {
$objWriter->startElement('i');
< $objWriter->writeAttribute('val', $pFont->getItalic() ? '1' : '0');
> $objWriter->writeAttribute('val', $font->getItalic() ? '1' : '0');
$objWriter->endElement();
}
// Strikethrough
< if ($pFont->getStrikethrough() !== null) {
> if ($font->getStrikethrough() !== null) {
$objWriter->startElement('strike');
< $objWriter->writeAttribute('val', $pFont->getStrikethrough() ? '1' : '0');
> $objWriter->writeAttribute('val', $font->getStrikethrough() ? '1' : '0');
$objWriter->endElement();
}
// Underline
< if ($pFont->getUnderline() !== null) {
> if ($font->getUnderline() !== null) {
$objWriter->startElement('u');
< $objWriter->writeAttribute('val', $pFont->getUnderline());
> $objWriter->writeAttribute('val', $font->getUnderline());
$objWriter->endElement();
}
// Superscript / subscript
< if ($pFont->getSuperscript() === true || $pFont->getSubscript() === true) {
> if ($font->getSuperscript() === true || $font->getSubscript() === true) {
$objWriter->startElement('vertAlign');
< if ($pFont->getSuperscript() === true) {
> if ($font->getSuperscript() === true) {
$objWriter->writeAttribute('val', 'superscript');
< } elseif ($pFont->getSubscript() === true) {
> } elseif ($font->getSubscript() === true) {
$objWriter->writeAttribute('val', 'subscript');
}
$objWriter->endElement();
}
// Size
< if ($pFont->getSize() !== null) {
> if ($font->getSize() !== null) {
$objWriter->startElement('sz');
< $objWriter->writeAttribute('val', StringHelper::formatNumber($pFont->getSize()));
> $objWriter->writeAttribute('val', StringHelper::formatNumber($font->getSize()));
$objWriter->endElement();
}
// Foreground color
< if ($pFont->getColor()->getARGB() !== null) {
> if ($font->getColor()->getARGB() !== null) {
$objWriter->startElement('color');
< $objWriter->writeAttribute('rgb', $pFont->getColor()->getARGB());
> $objWriter->writeAttribute('rgb', $font->getColor()->getARGB());
$objWriter->endElement();
}
// Name
< if ($pFont->getName() !== null) {
> if ($font->getName() !== null) {
$objWriter->startElement('name');
< $objWriter->writeAttribute('val', $pFont->getName());
> $objWriter->writeAttribute('val', $font->getName());
$objWriter->endElement();
}
$objWriter->endElement();
}
/**
* Write Border.
< *
< * @param XMLWriter $objWriter XML Writer
< * @param Borders $pBorders Borders style
*/
< private function writeBorder(XMLWriter $objWriter, Borders $pBorders)
> private function writeBorder(XMLWriter $objWriter, Borders $borders): void
{
// Write border
$objWriter->startElement('border');
// Diagonal?
< switch ($pBorders->getDiagonalDirection()) {
> switch ($borders->getDiagonalDirection()) {
case Borders::DIAGONAL_UP:
$objWriter->writeAttribute('diagonalUp', 'true');
$objWriter->writeAttribute('diagonalDown', 'false');
break;
case Borders::DIAGONAL_DOWN:
$objWriter->writeAttribute('diagonalUp', 'false');
$objWriter->writeAttribute('diagonalDown', 'true');
break;
case 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());
> $this->writeBorderPr($objWriter, 'left', $borders->getLeft());
> $this->writeBorderPr($objWriter, 'right', $borders->getRight());
> $this->writeBorderPr($objWriter, 'top', $borders->getTop());
> $this->writeBorderPr($objWriter, 'bottom', $borders->getBottom());
> $this->writeBorderPr($objWriter, 'diagonal', $borders->getDiagonal());
$objWriter->endElement();
}
/**
* Write Cell Style Xf.
< *
< * @param XMLWriter $objWriter XML Writer
< * @param \PhpOffice\PhpSpreadsheet\Style\Style $pStyle Style
< * @param Spreadsheet $spreadsheet Workbook
< *
< * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
*/
< private function writeCellStyleXf(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style $pStyle, Spreadsheet $spreadsheet)
> private function writeCellStyleXf(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style $style, Spreadsheet $spreadsheet): void
{
// xf
$objWriter->startElement('xf');
$objWriter->writeAttribute('xfId', 0);
< $objWriter->writeAttribute('fontId', (int) $this->getParentWriter()->getFontHashTable()->getIndexForHashCode($pStyle->getFont()->getHashCode()));
< if ($pStyle->getQuotePrefix()) {
> $objWriter->writeAttribute('fontId', (int) $this->getParentWriter()->getFontHashTable()->getIndexForHashCode($style->getFont()->getHashCode()));
> if ($style->getQuotePrefix()) {
$objWriter->writeAttribute('quotePrefix', 1);
}
< if ($pStyle->getNumberFormat()->getBuiltInFormatCode() === false) {
< $objWriter->writeAttribute('numFmtId', (int) ($this->getParentWriter()->getNumFmtHashTable()->getIndexForHashCode($pStyle->getNumberFormat()->getHashCode()) + 164));
> if ($style->getNumberFormat()->getBuiltInFormatCode() === false) {
> $objWriter->writeAttribute('numFmtId', (int) ($this->getParentWriter()->getNumFmtHashTable()->getIndexForHashCode($style->getNumberFormat()->getHashCode()) + 164));
} else {
< $objWriter->writeAttribute('numFmtId', (int) $pStyle->getNumberFormat()->getBuiltInFormatCode());
> $objWriter->writeAttribute('numFmtId', (int) $style->getNumberFormat()->getBuiltInFormatCode());
}
< $objWriter->writeAttribute('fillId', (int) $this->getParentWriter()->getFillHashTable()->getIndexForHashCode($pStyle->getFill()->getHashCode()));
< $objWriter->writeAttribute('borderId', (int) $this->getParentWriter()->getBordersHashTable()->getIndexForHashCode($pStyle->getBorders()->getHashCode()));
> $objWriter->writeAttribute('fillId', (int) $this->getParentWriter()->getFillHashTable()->getIndexForHashCode($style->getFill()->getHashCode()));
> $objWriter->writeAttribute('borderId', (int) $this->getParentWriter()->getBordersHashTable()->getIndexForHashCode($style->getBorders()->getHashCode()));
// Apply styles?
< $objWriter->writeAttribute('applyFont', ($spreadsheet->getDefaultStyle()->getFont()->getHashCode() != $pStyle->getFont()->getHashCode()) ? '1' : '0');
< $objWriter->writeAttribute('applyNumberFormat', ($spreadsheet->getDefaultStyle()->getNumberFormat()->getHashCode() != $pStyle->getNumberFormat()->getHashCode()) ? '1' : '0');
< $objWriter->writeAttribute('applyFill', ($spreadsheet->getDefaultStyle()->getFill()->getHashCode() != $pStyle->getFill()->getHashCode()) ? '1' : '0');
< $objWriter->writeAttribute('applyBorder', ($spreadsheet->getDefaultStyle()->getBorders()->getHashCode() != $pStyle->getBorders()->getHashCode()) ? '1' : '0');
< $objWriter->writeAttribute('applyAlignment', ($spreadsheet->getDefaultStyle()->getAlignment()->getHashCode() != $pStyle->getAlignment()->getHashCode()) ? '1' : '0');
< if ($pStyle->getProtection()->getLocked() != Protection::PROTECTION_INHERIT || $pStyle->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {
> $objWriter->writeAttribute('applyFont', ($spreadsheet->getDefaultStyle()->getFont()->getHashCode() != $style->getFont()->getHashCode()) ? '1' : '0');
> $objWriter->writeAttribute('applyNumberFormat', ($spreadsheet->getDefaultStyle()->getNumberFormat()->getHashCode() != $style->getNumberFormat()->getHashCode()) ? '1' : '0');
> $objWriter->writeAttribute('applyFill', ($spreadsheet->getDefaultStyle()->getFill()->getHashCode() != $style->getFill()->getHashCode()) ? '1' : '0');
> $objWriter->writeAttribute('applyBorder', ($spreadsheet->getDefaultStyle()->getBorders()->getHashCode() != $style->getBorders()->getHashCode()) ? '1' : '0');
> $objWriter->writeAttribute('applyAlignment', ($spreadsheet->getDefaultStyle()->getAlignment()->getHashCode() != $style->getAlignment()->getHashCode()) ? '1' : '0');
> if ($style->getProtection()->getLocked() != Protection::PROTECTION_INHERIT || $style->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {
$objWriter->writeAttribute('applyProtection', 'true');
}
// alignment
$objWriter->startElement('alignment');
< $objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal());
< $objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical());
> $objWriter->writeAttribute('horizontal', $style->getAlignment()->getHorizontal());
> $objWriter->writeAttribute('vertical', $style->getAlignment()->getVertical());
$textRotation = 0;
< if ($pStyle->getAlignment()->getTextRotation() >= 0) {
< $textRotation = $pStyle->getAlignment()->getTextRotation();
< } elseif ($pStyle->getAlignment()->getTextRotation() < 0) {
< $textRotation = 90 - $pStyle->getAlignment()->getTextRotation();
> if ($style->getAlignment()->getTextRotation() >= 0) {
> $textRotation = $style->getAlignment()->getTextRotation();
> } elseif ($style->getAlignment()->getTextRotation() < 0) {
> $textRotation = 90 - $style->getAlignment()->getTextRotation();
}
$objWriter->writeAttribute('textRotation', $textRotation);
< $objWriter->writeAttribute('wrapText', ($pStyle->getAlignment()->getWrapText() ? 'true' : 'false'));
< $objWriter->writeAttribute('shrinkToFit', ($pStyle->getAlignment()->getShrinkToFit() ? 'true' : 'false'));
> $objWriter->writeAttribute('wrapText', ($style->getAlignment()->getWrapText() ? 'true' : 'false'));
> $objWriter->writeAttribute('shrinkToFit', ($style->getAlignment()->getShrinkToFit() ? 'true' : 'false'));
< if ($pStyle->getAlignment()->getIndent() > 0) {
< $objWriter->writeAttribute('indent', $pStyle->getAlignment()->getIndent());
> if ($style->getAlignment()->getIndent() > 0) {
> $objWriter->writeAttribute('indent', $style->getAlignment()->getIndent());
}
< if ($pStyle->getAlignment()->getReadOrder() > 0) {
< $objWriter->writeAttribute('readingOrder', $pStyle->getAlignment()->getReadOrder());
> if ($style->getAlignment()->getReadOrder() > 0) {
> $objWriter->writeAttribute('readingOrder', $style->getAlignment()->getReadOrder());
}
$objWriter->endElement();
// protection
< if ($pStyle->getProtection()->getLocked() != Protection::PROTECTION_INHERIT || $pStyle->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {
> if ($style->getProtection()->getLocked() != Protection::PROTECTION_INHERIT || $style->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {
$objWriter->startElement('protection');
< if ($pStyle->getProtection()->getLocked() != Protection::PROTECTION_INHERIT) {
< $objWriter->writeAttribute('locked', ($pStyle->getProtection()->getLocked() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
> if ($style->getProtection()->getLocked() != Protection::PROTECTION_INHERIT) {
> $objWriter->writeAttribute('locked', ($style->getProtection()->getLocked() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
}
< if ($pStyle->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {
< $objWriter->writeAttribute('hidden', ($pStyle->getProtection()->getHidden() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
> if ($style->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {
> $objWriter->writeAttribute('hidden', ($style->getProtection()->getHidden() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
}
$objWriter->endElement();
}
$objWriter->endElement();
}
/**
* Write Cell Style Dxf.
< *
< * @param XMLWriter $objWriter XML Writer
< * @param \PhpOffice\PhpSpreadsheet\Style\Style $pStyle Style
*/
< private function writeCellStyleDxf(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style $pStyle)
> private function writeCellStyleDxf(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style $style): void
{
// dxf
$objWriter->startElement('dxf');
// font
< $this->writeFont($objWriter, $pStyle->getFont());
> $this->writeFont($objWriter, $style->getFont());
// numFmt
< $this->writeNumFmt($objWriter, $pStyle->getNumberFormat());
> $this->writeNumFmt($objWriter, $style->getNumberFormat());
// fill
< $this->writeFill($objWriter, $pStyle->getFill());
> $this->writeFill($objWriter, $style->getFill());
// alignment
$objWriter->startElement('alignment');
< if ($pStyle->getAlignment()->getHorizontal() !== null) {
< $objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal());
> if ($style->getAlignment()->getHorizontal() !== null) {
> $objWriter->writeAttribute('horizontal', $style->getAlignment()->getHorizontal());
}
< if ($pStyle->getAlignment()->getVertical() !== null) {
< $objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical());
> if ($style->getAlignment()->getVertical() !== null) {
> $objWriter->writeAttribute('vertical', $style->getAlignment()->getVertical());
}
< if ($pStyle->getAlignment()->getTextRotation() !== null) {
> if ($style->getAlignment()->getTextRotation() !== null) {
$textRotation = 0;
< if ($pStyle->getAlignment()->getTextRotation() >= 0) {
< $textRotation = $pStyle->getAlignment()->getTextRotation();
< } elseif ($pStyle->getAlignment()->getTextRotation() < 0) {
< $textRotation = 90 - $pStyle->getAlignment()->getTextRotation();
> if ($style->getAlignment()->getTextRotation() >= 0) {
> $textRotation = $style->getAlignment()->getTextRotation();
> } elseif ($style->getAlignment()->getTextRotation() < 0) {
> $textRotation = 90 - $style->getAlignment()->getTextRotation();
}
$objWriter->writeAttribute('textRotation', $textRotation);
}
$objWriter->endElement();
// border
< $this->writeBorder($objWriter, $pStyle->getBorders());
> $this->writeBorder($objWriter, $style->getBorders());
// protection
< if (($pStyle->getProtection()->getLocked() !== null) || ($pStyle->getProtection()->getHidden() !== null)) {
< if ($pStyle->getProtection()->getLocked() !== Protection::PROTECTION_INHERIT ||
< $pStyle->getProtection()->getHidden() !== Protection::PROTECTION_INHERIT) {
> if (($style->getProtection()->getLocked() !== null) || ($style->getProtection()->getHidden() !== null)) {
> if (
> $style->getProtection()->getLocked() !== Protection::PROTECTION_INHERIT ||
> $style->getProtection()->getHidden() !== Protection::PROTECTION_INHERIT
> ) {
$objWriter->startElement('protection');
< if (($pStyle->getProtection()->getLocked() !== null) &&
< ($pStyle->getProtection()->getLocked() !== Protection::PROTECTION_INHERIT)) {
< $objWriter->writeAttribute('locked', ($pStyle->getProtection()->getLocked() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
< }
< if (($pStyle->getProtection()->getHidden() !== null) &&
< ($pStyle->getProtection()->getHidden() !== Protection::PROTECTION_INHERIT)) {
< $objWriter->writeAttribute('hidden', ($pStyle->getProtection()->getHidden() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
> if (
> ($style->getProtection()->getLocked() !== null) &&
> ($style->getProtection()->getLocked() !== Protection::PROTECTION_INHERIT)
> ) {
> $objWriter->writeAttribute('locked', ($style->getProtection()->getLocked() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
> }
> if (
> ($style->getProtection()->getHidden() !== null) &&
> ($style->getProtection()->getHidden() !== Protection::PROTECTION_INHERIT)
> ) {
> $objWriter->writeAttribute('hidden', ($style->getProtection()->getHidden() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
}
$objWriter->endElement();
}
}
$objWriter->endElement();
}
/**
* Write BorderPr.
*
< * @param XMLWriter $objWriter XML Writer
< * @param string $pName Element name
< * @param Border $pBorder Border style
> * @param string $name Element name
*/
< private function writeBorderPr(XMLWriter $objWriter, $pName, Border $pBorder)
> private function writeBorderPr(XMLWriter $objWriter, $name, Border $border): void
{
// Write BorderPr
< if ($pBorder->getBorderStyle() != Border::BORDER_NONE) {
< $objWriter->startElement($pName);
< $objWriter->writeAttribute('style', $pBorder->getBorderStyle());
> if ($border->getBorderStyle() != Border::BORDER_NONE) {
> $objWriter->startElement($name);
> $objWriter->writeAttribute('style', $border->getBorderStyle());
// color
$objWriter->startElement('color');
< $objWriter->writeAttribute('rgb', $pBorder->getColor()->getARGB());
> $objWriter->writeAttribute('rgb', $border->getColor()->getARGB());
$objWriter->endElement();
$objWriter->endElement();
}
}
/**
* Write NumberFormat.
*
< * @param XMLWriter $objWriter XML Writer
< * @param NumberFormat $pNumberFormat Number Format
< * @param int $pId Number Format identifier
> * @param int $id Number Format identifier
*/
< private function writeNumFmt(XMLWriter $objWriter, NumberFormat $pNumberFormat, $pId = 0)
> private function writeNumFmt(XMLWriter $objWriter, NumberFormat $numberFormat, $id = 0): void
{
// Translate formatcode
< $formatCode = $pNumberFormat->getFormatCode();
> $formatCode = $numberFormat->getFormatCode();
// numFmt
if ($formatCode !== null) {
$objWriter->startElement('numFmt');
< $objWriter->writeAttribute('numFmtId', ($pId + 164));
> $objWriter->writeAttribute('numFmtId', ($id + 164));
$objWriter->writeAttribute('formatCode', $formatCode);
$objWriter->endElement();
}
}
/**
* Get an array of all styles.
*
< * @param Spreadsheet $spreadsheet
< *
* @return \PhpOffice\PhpSpreadsheet\Style\Style[] All styles in PhpSpreadsheet
*/
public function allStyles(Spreadsheet $spreadsheet)
{
return $spreadsheet->getCellXfCollection();
}
/**
* Get an array of all conditional styles.
*
< * @param Spreadsheet $spreadsheet
< *
* @return Conditional[] All conditional styles in PhpSpreadsheet
*/
public function allConditionalStyles(Spreadsheet $spreadsheet)
{
// Get an array of all styles
$aStyles = [];
$sheetCount = $spreadsheet->getSheetCount();
for ($i = 0; $i < $sheetCount; ++$i) {
foreach ($spreadsheet->getSheet($i)->getConditionalStylesCollection() as $conditionalStyles) {
foreach ($conditionalStyles as $conditionalStyle) {
$aStyles[] = $conditionalStyle;
}
}
}
return $aStyles;
}
/**
* Get an array of all fills.
*
< * @param Spreadsheet $spreadsheet
< *
* @return Fill[] All fills in PhpSpreadsheet
*/
public function allFills(Spreadsheet $spreadsheet)
{
// Get an array of unique fills
$aFills = [];
// Two first fills are predefined
$fill0 = new Fill();
$fill0->setFillType(Fill::FILL_NONE);
$aFills[] = $fill0;
$fill1 = new Fill();
$fill1->setFillType(Fill::FILL_PATTERN_GRAY125);
$aFills[] = $fill1;
// The remaining fills
$aStyles = $this->allStyles($spreadsheet);
/** @var \PhpOffice\PhpSpreadsheet\Style\Style $style */
foreach ($aStyles as $style) {
if (!isset($aFills[$style->getFill()->getHashCode()])) {
$aFills[$style->getFill()->getHashCode()] = $style->getFill();
}
}
return $aFills;
}
/**
* Get an array of all fonts.
*
< * @param Spreadsheet $spreadsheet
< *
* @return Font[] All fonts in PhpSpreadsheet
*/
public function allFonts(Spreadsheet $spreadsheet)
{
// Get an array of unique fonts
$aFonts = [];
$aStyles = $this->allStyles($spreadsheet);
/** @var \PhpOffice\PhpSpreadsheet\Style\Style $style */
foreach ($aStyles as $style) {
if (!isset($aFonts[$style->getFont()->getHashCode()])) {
$aFonts[$style->getFont()->getHashCode()] = $style->getFont();
}
}
return $aFonts;
}
/**
* Get an array of all borders.
*
< * @param Spreadsheet $spreadsheet
< *
* @return Borders[] All borders in PhpSpreadsheet
*/
public function allBorders(Spreadsheet $spreadsheet)
{
// Get an array of unique borders
$aBorders = [];
$aStyles = $this->allStyles($spreadsheet);
/** @var \PhpOffice\PhpSpreadsheet\Style\Style $style */
foreach ($aStyles as $style) {
if (!isset($aBorders[$style->getBorders()->getHashCode()])) {
$aBorders[$style->getBorders()->getHashCode()] = $style->getBorders();
}
}
return $aBorders;
}
/**
* Get an array of all number formats.
< *
< * @param Spreadsheet $spreadsheet
*
* @return NumberFormat[] All number formats in PhpSpreadsheet
*/
public function allNumberFormats(Spreadsheet $spreadsheet)
{
// Get an array of unique number formats
$aNumFmts = [];
$aStyles = $this->allStyles($spreadsheet);
/** @var \PhpOffice\PhpSpreadsheet\Style\Style $style */
foreach ($aStyles as $style) {
if ($style->getNumberFormat()->getBuiltInFormatCode() === false && !isset($aNumFmts[$style->getNumberFormat()->getHashCode()])) {
$aNumFmts[$style->getNumberFormat()->getHashCode()] = $style->getNumberFormat();
}
}
return $aNumFmts;
}
}