See Release Notes
Long Term Support Release
<?php namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx; use PhpOffice\PhpSpreadsheet\Shared\StringHelper; use PhpOffice\PhpSpreadsheet\Shared\XMLWriter; use PhpOffice\PhpSpreadsheet\Spreadsheet;> use PhpOffice\PhpSpreadsheet\Style\Alignment;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());> $objWriter->writeAttribute('count', (string) $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());> $objWriter->writeAttribute('count', (string) $this->getParentWriter()->getFontHashTable()->count());// font for ($i = 0; $i < $this->getParentWriter()->getFontHashTable()->count(); ++$i) {< $this->writeFont($objWriter, $this->getParentWriter()->getFontHashTable()->getByIndex($i));> $thisfont = $this->getParentWriter()->getFontHashTable()->getByIndex($i); > if ($thisfont !== null) { > $this->writeFont($objWriter, $thisfont); > }} $objWriter->endElement(); // fills $objWriter->startElement('fills');< $objWriter->writeAttribute('count', $this->getParentWriter()->getFillHashTable()->count());> $objWriter->writeAttribute('count', (string) $this->getParentWriter()->getFillHashTable()->count());// fill for ($i = 0; $i < $this->getParentWriter()->getFillHashTable()->count(); ++$i) {< $this->writeFill($objWriter, $this->getParentWriter()->getFillHashTable()->getByIndex($i));> $thisfill = $this->getParentWriter()->getFillHashTable()->getByIndex($i); > if ($thisfill !== null) { > $this->writeFill($objWriter, $thisfill); > }} $objWriter->endElement(); // borders $objWriter->startElement('borders');< $objWriter->writeAttribute('count', $this->getParentWriter()->getBordersHashTable()->count());> $objWriter->writeAttribute('count', (string) $this->getParentWriter()->getBordersHashTable()->count());// border for ($i = 0; $i < $this->getParentWriter()->getBordersHashTable()->count(); ++$i) {< $this->writeBorder($objWriter, $this->getParentWriter()->getBordersHashTable()->getByIndex($i));> $thisborder = $this->getParentWriter()->getBordersHashTable()->getByIndex($i); > if ($thisborder !== null) { > $this->writeBorder($objWriter, $thisborder); > }} $objWriter->endElement(); // cellStyleXfs $objWriter->startElement('cellStyleXfs');< $objWriter->writeAttribute('count', 1);> $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->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()));> $objWriter->writeAttribute('count', (string) count($spreadsheet->getCellXfCollection()));// xf foreach ($spreadsheet->getCellXfCollection() as $cellXf) { $this->writeCellStyleXf($objWriter, $cellXf, $spreadsheet); } $objWriter->endElement(); // cellStyles $objWriter->startElement('cellStyles');< $objWriter->writeAttribute('count', 1);> $objWriter->writeAttribute('count', '1');// cellStyle $objWriter->startElement('cellStyle'); $objWriter->writeAttribute('name', 'Normal');< $objWriter->writeAttribute('xfId', 0); < $objWriter->writeAttribute('builtinId', 0);> $objWriter->writeAttribute('xfId', '0'); > $objWriter->writeAttribute('builtinId', '0');$objWriter->endElement(); $objWriter->endElement(); // dxfs $objWriter->startElement('dxfs');< $objWriter->writeAttribute('count', $this->getParentWriter()->getStylesConditionalHashTable()->count());> $objWriter->writeAttribute('count', (string) $this->getParentWriter()->getStylesConditionalHashTable()->count());// dxf for ($i = 0; $i < $this->getParentWriter()->getStylesConditionalHashTable()->count(); ++$i) {< $this->writeCellStyleDxf($objWriter, $this->getParentWriter()->getStylesConditionalHashTable()->getByIndex($i)->getStyle());> $thisstyle = $this->getParentWriter()->getStylesConditionalHashTable()->getByIndex($i); > if ($thisstyle !== null) { > $this->writeCellStyleDxf($objWriter, $thisstyle->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', (string) $fill->getFillType()); > $objWriter->writeAttribute('degree', (string) $fill->getRotation());// stop $objWriter->startElement('stop'); $objWriter->writeAttribute('position', '0'); // color> if ($fill->getStartColor()->getARGB() !== null) {$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> if ($fill->getEndColor()->getARGB() !== null) {$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', (string) $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('quotePrefix', 1);> $objWriter->writeAttribute('xfId', '0'); > $objWriter->writeAttribute('fontId', (string) (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', (string) (int) ($this->getParentWriter()->getNumFmtHashTable()->getIndexForHashCode($style->getNumberFormat()->getHashCode()) + 164));} else {< $objWriter->writeAttribute('numFmtId', (int) $pStyle->getNumberFormat()->getBuiltInFormatCode());> $objWriter->writeAttribute('numFmtId', (string) (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', (string) (int) $this->getParentWriter()->getFillHashTable()->getIndexForHashCode($style->getFill()->getHashCode())); > $objWriter->writeAttribute('borderId', (string) (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());> $vertical = Alignment::VERTICAL_ALIGNMENT_FOR_XLSX[$style->getAlignment()->getVertical()] ?? ''; > $horizontal = Alignment::HORIZONTAL_ALIGNMENT_FOR_XLSX[$style->getAlignment()->getHorizontal()] ?? ''; > if ($horizontal !== '') { > $objWriter->writeAttribute('horizontal', $horizontal); > } > if ($vertical !== '') { > $objWriter->writeAttribute('vertical', $vertical); > }$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(); > } else { > $textRotation = 90 - $style->getAlignment()->getTextRotation();}< $objWriter->writeAttribute('textRotation', $textRotation);> $objWriter->writeAttribute('textRotation', (string) $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', (string) $style->getAlignment()->getIndent());}< if ($pStyle->getAlignment()->getReadOrder() > 0) { < $objWriter->writeAttribute('readingOrder', $pStyle->getAlignment()->getReadOrder());> if ($style->getAlignment()->getReadOrder() > 0) { > $objWriter->writeAttribute('readingOrder', (string) $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());> $horizontal = Alignment::HORIZONTAL_ALIGNMENT_FOR_XLSX[$style->getAlignment()->getHorizontal()] ?? ''; > if ($horizontal) { > $objWriter->writeAttribute('horizontal', $horizontal);}< if ($pStyle->getAlignment()->getVertical() !== null) { < $objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical());> $vertical = Alignment::VERTICAL_ALIGNMENT_FOR_XLSX[$style->getAlignment()->getVertical()] ?? ''; > if ($vertical) { > $objWriter->writeAttribute('vertical', $vertical);}< 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(); > } else { > $textRotation = 90 - $style->getAlignment()->getTextRotation();}< $objWriter->writeAttribute('textRotation', $textRotation);> $objWriter->writeAttribute('textRotation', (string) $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 ((!empty($style->getProtection()->getLocked())) || (!empty($style->getProtection()->getHidden()))) { > 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> if ($border->getColor()->getARGB() !== null) {$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 === null) ? null : $numberFormat->getFormatCode();// numFmt if ($formatCode !== null) { $objWriter->startElement('numFmt');< $objWriter->writeAttribute('numFmtId', ($pId + 164));> $objWriter->writeAttribute('numFmtId', (string) ($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; } }