Vendor/phpspreadsheet/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Style.php
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();
    }
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();
    }
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 styles to XML format.

@param Spreadsheet $spreadsheet

@throws \PhpOffice\PhpSpreadsheet\Writer\Exception

@return string XML Output
Write styles to XML format .