Inheritance diagram for PhpOffice\PhpSpreadsheet\Writer\Xlsx:

Collaboration diagram for PhpOffice\PhpSpreadsheet\Writer\Xlsx:

Public Member Functions
	__construct (Spreadsheet $spreadsheet)
	Create a new Xlsx Writer. More...

	getWriterPartChart ()

	getWriterPartComments ()

	getWriterPartContentTypes ()

	getWriterPartDocProps ()

	getWriterPartDrawing ()

	getWriterPartRels ()

	getWriterPartRelsRibbon ()

	getWriterPartRelsVBA ()

	getWriterPartStringTable ()

	getWriterPartStyle ()

	getWriterPartTheme ()

	getWriterPartWorkbook ()

	getWriterPartWorksheet ()

	save ($pFilename)
	Save PhpSpreadsheet to file. More...

	getSpreadsheet ()
	Get Spreadsheet object. More...

	setSpreadsheet (Spreadsheet $spreadsheet)
	Set Spreadsheet object. More...

	getStringTable ()
	Get string table. More...

	getStyleHashTable ()
	Get Style HashTable. More...

	getStylesConditionalHashTable ()
	Get Conditional HashTable. More...

	getFillHashTable ()
	Get Fill HashTable. More...

	getFontHashTable ()
	Get \PhpOffice\PhpSpreadsheet\Style\Font HashTable. More...

	getBordersHashTable ()
	Get Borders HashTable. More...

	getNumFmtHashTable ()
	Get NumberFormat HashTable. More...

	getDrawingHashTable ()
	Get \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet\BaseDrawing HashTable. More...

	getOffice2003Compatibility ()
	Get Office2003 compatibility. More...

	setOffice2003Compatibility ($pValue)
	Set Office2003 compatibility. More...

Public Member Functions inherited from PhpOffice\PhpSpreadsheet\Writer\BaseWriter
	getIncludeCharts ()
	Write charts in workbook? If this is true, then the Writer will write definitions for any charts that exist in the PhpSpreadsheet object. More...

	setIncludeCharts ($pValue)
	Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object. More...

	getPreCalculateFormulas ()
	Get Pre-Calculate Formulas flag If this is true (the default), then the writer will recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file If false, then formulae are not calculated on save. More...

	setPreCalculateFormulas ($pValue)
	Set Pre-Calculate Formulas Set to true (the default) to advise the Writer to calculate all formulae on save Set to false to prevent precalculation of formulae on save. More...

	getUseDiskCaching ()
	Get use disk caching where possible? More...

	setUseDiskCaching ($pValue, $pDirectory=null)
	Set use disk caching where possible? More...

	getDiskCachingDirectory ()
	Get disk caching directory. More...

	openFileHandle ($filename)
	Open file handle. More...

	__construct (Spreadsheet $spreadsheet)
	IWriter constructor. More...

	getIncludeCharts ()
	Write charts in workbook? If this is true, then the Writer will write definitions for any charts that exist in the PhpSpreadsheet object. More...

	setIncludeCharts ($pValue)
	Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object. More...

	getPreCalculateFormulas ()
	Get Pre-Calculate Formulas flag If this is true (the default), then the writer will recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file If false, then formulae are not calculated on save. More...

	setPreCalculateFormulas ($pValue)
	Set Pre-Calculate Formulas Set to true (the default) to advise the Writer to calculate all formulae on save Set to false to prevent precalculation of formulae on save. More...

	save ($pFilename)
	Save PhpSpreadsheet to file. More...

	getUseDiskCaching ()
	Get use disk caching where possible? More...

	setUseDiskCaching ($pValue, $pDirectory=null)
	Set use disk caching where possible? More...

	getDiskCachingDirectory ()
	Get disk caching directory. More...

Private Member Functions
	addZipFile (string $path, string $content)

	addZipFiles (array $zipContent)

Additional Inherited Members
Protected Member Functions inherited from PhpOffice\PhpSpreadsheet\Writer\BaseWriter
	maybeCloseFileHandle ()
	Close file handle only if we opened it ourselves. More...

Protected Attributes inherited from PhpOffice\PhpSpreadsheet\Writer\BaseWriter
	$includeCharts = false

	$preCalculateFormulas = true

	$fileHandle

Detailed Description

Definition at line 36 of file Xlsx.php.

Constructor & Destructor Documentation

◆ __construct()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::__construct ( Spreadsheet $spreadsheet )

Create a new Xlsx Writer.

Implements PhpOffice\PhpSpreadsheet\Writer\IWriter.

Definition at line 183 of file Xlsx.php.

    {
        // Assign PhpSpreadsheet
        $this->setSpreadsheet($spreadsheet);
 
        $this->writerPartChart = new Chart($this);
        $this->writerPartComments = new Comments($this);
        $this->writerPartContentTypes = new ContentTypes($this);
        $this->writerPartDocProps = new DocProps($this);
        $this->writerPartDrawing = new Drawing($this);
        $this->writerPartRels = new Rels($this);
        $this->writerPartRelsRibbon = new RelsRibbon($this);
        $this->writerPartRelsVBA = new RelsVBA($this);
        $this->writerPartStringTable = new StringTable($this);
        $this->writerPartStyle = new Style($this);
        $this->writerPartTheme = new Theme($this);
        $this->writerPartWorkbook = new Workbook($this);
        $this->writerPartWorksheet = new Worksheet($this);
 
        // Set HashTable variables
        // @phpstan-ignore-next-line
        $this->bordersHashTable = new HashTable();
        // @phpstan-ignore-next-line
        $this->drawingHashTable = new HashTable();
        // @phpstan-ignore-next-line
        $this->fillHashTable = new HashTable();
        // @phpstan-ignore-next-line
        $this->fontHashTable = new HashTable();
        // @phpstan-ignore-next-line
        $this->numFmtHashTable = new HashTable();
        // @phpstan-ignore-next-line
        $this->styleHashTable = new HashTable();
        // @phpstan-ignore-next-line
        $this->stylesConditionalHashTable = new HashTable();
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\setSpreadsheet().

Here is the call graph for this function:

Member Function Documentation

◆ addZipFile()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::addZipFile	(	string	$path,
		string	$content
	)

private

Definition at line 654 of file Xlsx.php.

                                                              : void
    {
        if (!in_array($path, $this->pathNames)) {
            $this->pathNames[] = $path;
            $this->zip->addFile($path, $content);
        }
    }

References $path.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\addZipFiles().

Here is the caller graph for this function:

◆ addZipFiles()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::addZipFiles ( array $zipContent )

private

Definition at line 662 of file Xlsx.php.

                                                   : void
    {
        foreach ($zipContent as $path => $content) {
            $this->addZipFile($path, $content);
        }
    }

References $path, and PhpOffice\PhpSpreadsheet\Writer\Xlsx\addZipFile().

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getBordersHashTable()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getBordersHashTable ( )

Get Borders HashTable.

Returns: HashTable<Borders>

Definition at line 603 of file Xlsx.php.

    {
        return $this->bordersHashTable;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$bordersHashTable.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\Style\writeCellStyleXf(), and PhpOffice\PhpSpreadsheet\Writer\Xlsx\Style\writeStyles().

Here is the caller graph for this function:

◆ getDrawingHashTable()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getDrawingHashTable ( )

Get \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet\BaseDrawing HashTable.

Returns: HashTable<BaseDrawing>

Definition at line 623 of file Xlsx.php.

    {
        return $this->drawingHashTable;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$drawingHashTable.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save(), and PhpOffice\PhpSpreadsheet\Writer\Xlsx\ContentTypes\writeContentTypes().

Here is the caller graph for this function:

◆ getFillHashTable()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getFillHashTable ( )

Get Fill HashTable.

Returns: HashTable<Fill>

Definition at line 583 of file Xlsx.php.

    {
        return $this->fillHashTable;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$fillHashTable.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\Style\writeCellStyleXf(), and PhpOffice\PhpSpreadsheet\Writer\Xlsx\Style\writeStyles().

Here is the caller graph for this function:

◆ getFontHashTable()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getFontHashTable ( )

Get \PhpOffice\PhpSpreadsheet\Style\Font HashTable.

Returns: HashTable<Font>

Definition at line 593 of file Xlsx.php.

    {
        return $this->fontHashTable;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$fontHashTable.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\Style\writeCellStyleXf(), and PhpOffice\PhpSpreadsheet\Writer\Xlsx\Style\writeStyles().

Here is the caller graph for this function:

◆ getNumFmtHashTable()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getNumFmtHashTable ( )

Get NumberFormat HashTable.

Returns: HashTable<NumberFormat>

Definition at line 613 of file Xlsx.php.

    {
        return $this->numFmtHashTable;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$numFmtHashTable.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\Style\writeCellStyleXf(), and PhpOffice\PhpSpreadsheet\Writer\Xlsx\Style\writeStyles().

Here is the caller graph for this function:

◆ getOffice2003Compatibility()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getOffice2003Compatibility ( )

Get Office2003 compatibility.

Returns: bool

Definition at line 633 of file Xlsx.php.

    {
        return $this->office2003compatibility;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$office2003compatibility.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet\writeCellFormula(), and PhpOffice\PhpSpreadsheet\Writer\Xlsx\Workbook\writeWorkbook().

Here is the caller graph for this function:

◆ getSpreadsheet()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getSpreadsheet ( )

Get Spreadsheet object.

Returns: Spreadsheet

Definition at line 529 of file Xlsx.php.

    {
        return $this->spreadSheet;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$spreadSheet.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet\writeSheetViews().

Here is the caller graph for this function:

◆ getStringTable()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getStringTable ( )

Get string table.

Returns: string[]

Definition at line 553 of file Xlsx.php.

    {
        return $this->stringTable;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$stringTable.

◆ getStyleHashTable()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getStyleHashTable ( )

Get Style HashTable.

Returns: HashTable<\PhpOffice\PhpSpreadsheet\Style\Style>

Definition at line 563 of file Xlsx.php.

    {
        return $this->styleHashTable;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$styleHashTable.

◆ getStylesConditionalHashTable()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getStylesConditionalHashTable ( )

Get Conditional HashTable.

Returns: HashTable<Conditional>

Definition at line 573 of file Xlsx.php.

    {
        return $this->stylesConditionalHashTable;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$stylesConditionalHashTable.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\Style\writeStyles().

Here is the caller graph for this function:

◆ getWriterPartChart()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartChart ( )

Definition at line 219 of file Xlsx.php.

                                        : Chart
    {
        return $this->writerPartChart;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartChart.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartComments()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartComments ( )

Definition at line 224 of file Xlsx.php.

                                           : Comments
    {
        return $this->writerPartComments;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartComments.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartContentTypes()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartContentTypes ( )

Definition at line 229 of file Xlsx.php.

                                               : ContentTypes
    {
        return $this->writerPartContentTypes;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartContentTypes.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartDocProps()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartDocProps ( )

Definition at line 234 of file Xlsx.php.

                                           : DocProps
    {
        return $this->writerPartDocProps;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartDocProps.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartDrawing()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartDrawing ( )

Definition at line 239 of file Xlsx.php.

                                          : Drawing
    {
        return $this->writerPartDrawing;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartDrawing.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartRels()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartRels ( )

Definition at line 244 of file Xlsx.php.

                                       : Rels
    {
        return $this->writerPartRels;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartRels.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartRelsRibbon()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartRelsRibbon ( )

Definition at line 249 of file Xlsx.php.

                                             : RelsRibbon
    {
        return $this->writerPartRelsRibbon;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartRelsRibbon.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartRelsVBA()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartRelsVBA ( )

Definition at line 254 of file Xlsx.php.

                                          : RelsVBA
    {
        return $this->writerPartRelsVBA;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartRelsVBA.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartStringTable()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartStringTable ( )

Definition at line 259 of file Xlsx.php.

                                              : StringTable
    {
        return $this->writerPartStringTable;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartStringTable.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartStyle()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartStyle ( )

Definition at line 264 of file Xlsx.php.

                                        : Style
    {
        return $this->writerPartStyle;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartStyle.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartTheme()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartTheme ( )

Definition at line 269 of file Xlsx.php.

                                        : Theme
    {
        return $this->writerPartTheme;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartTheme.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartWorkbook()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartWorkbook ( )

Definition at line 274 of file Xlsx.php.

                                           : Workbook
    {
        return $this->writerPartWorkbook;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartWorkbook.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ getWriterPartWorksheet()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::getWriterPartWorksheet ( )

Definition at line 279 of file Xlsx.php.

                                            : Worksheet
    {
        return $this->writerPartWorksheet;
    }

References PhpOffice\PhpSpreadsheet\Writer\Xlsx\$writerPartWorksheet.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

Here is the caller graph for this function:

◆ save()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::save ( $pFilename )

Save PhpSpreadsheet to file.

Parameters

resource | string $pFilename

Implements PhpOffice\PhpSpreadsheet\Writer\IWriter.

Definition at line 289 of file Xlsx.php.

                                    : void
    {
        // garbage collect
        $this->pathNames = [];
        $this->spreadSheet->garbageCollect();
 
        $saveDebugLog = Calculation::getInstance($this->spreadSheet)->getDebugLog()->getWriteDebugLog();
        Calculation::getInstance($this->spreadSheet)->getDebugLog()->setWriteDebugLog(false);
        $saveDateReturnType = Functions::getReturnDateType();
        Functions::setReturnDateType(Functions::RETURNDATE_EXCEL);
 
        // Create string lookup table
        $this->stringTable = [];
        for ($i = 0; $i < $this->spreadSheet->getSheetCount(); ++$i) {
            $this->stringTable = $this->getWriterPartStringTable()->createStringTable($this->spreadSheet->getSheet($i), $this->stringTable);
        }
 
        // Create styles dictionaries
        $this->styleHashTable->addFromSource($this->getWriterPartStyle()->allStyles($this->spreadSheet));
        $this->stylesConditionalHashTable->addFromSource($this->getWriterPartStyle()->allConditionalStyles($this->spreadSheet));
        $this->fillHashTable->addFromSource($this->getWriterPartStyle()->allFills($this->spreadSheet));
        $this->fontHashTable->addFromSource($this->getWriterPartStyle()->allFonts($this->spreadSheet));
        $this->bordersHashTable->addFromSource($this->getWriterPartStyle()->allBorders($this->spreadSheet));
        $this->numFmtHashTable->addFromSource($this->getWriterPartStyle()->allNumberFormats($this->spreadSheet));
 
        // Create drawing dictionary
        $this->drawingHashTable->addFromSource($this->getWriterPartDrawing()->allDrawings($this->spreadSheet));
 
        $zipContent = [];
        // Add [Content_Types].xml to ZIP file
        $zipContent['[Content_Types].xml'] = $this->getWriterPartContentTypes()->writeContentTypes($this->spreadSheet, $this->includeCharts);
 
        //if hasMacros, add the vbaProject.bin file, Certificate file(if exists)
        if ($this->spreadSheet->hasMacros()) {
            $macrosCode = $this->spreadSheet->getMacrosCode();
            if ($macrosCode !== null) {
                // we have the code ?
                $zipContent['xl/vbaProject.bin'] = $macrosCode; //allways in 'xl', allways named vbaProject.bin
                if ($this->spreadSheet->hasMacrosCertificate()) {
                    //signed macros ?
                    // Yes : add the certificate file and the related rels file
                    $zipContent['xl/vbaProjectSignature.bin'] = $this->spreadSheet->getMacrosCertificate();
                    $zipContent['xl/_rels/vbaProject.bin.rels'] = $this->getWriterPartRelsVBA()->writeVBARelationships($this->spreadSheet);
                }
            }
        }
        //a custom UI in this workbook ? add it ("base" xml and additional objects (pictures) and rels)
        if ($this->spreadSheet->hasRibbon()) {
            $tmpRibbonTarget = $this->spreadSheet->getRibbonXMLData('target');
            $zipContent[$tmpRibbonTarget] = $this->spreadSheet->getRibbonXMLData('data');
            if ($this->spreadSheet->hasRibbonBinObjects()) {
                $tmpRootPath = dirname($tmpRibbonTarget) . '/';
                $ribbonBinObjects = $this->spreadSheet->getRibbonBinObjects('data'); //the files to write
                foreach ($ribbonBinObjects as $aPath => $aContent) {
                    $zipContent[$tmpRootPath . $aPath] = $aContent;
                }
                //the rels for files
                $zipContent[$tmpRootPath . '_rels/' . basename($tmpRibbonTarget) . '.rels'] = $this->getWriterPartRelsRibbon()->writeRibbonRelationships($this->spreadSheet);
            }
        }
 
        // Add relationships to ZIP file
        $zipContent['_rels/.rels'] = $this->getWriterPartRels()->writeRelationships($this->spreadSheet);
        $zipContent['xl/_rels/workbook.xml.rels'] = $this->getWriterPartRels()->writeWorkbookRelationships($this->spreadSheet);
 
        // Add document properties to ZIP file
        $zipContent['docProps/app.xml'] = $this->getWriterPartDocProps()->writeDocPropsApp($this->spreadSheet);
        $zipContent['docProps/core.xml'] = $this->getWriterPartDocProps()->writeDocPropsCore($this->spreadSheet);
        $customPropertiesPart = $this->getWriterPartDocProps()->writeDocPropsCustom($this->spreadSheet);
        if ($customPropertiesPart !== null) {
            $zipContent['docProps/custom.xml'] = $customPropertiesPart;
        }
 
        // Add theme to ZIP file
        $zipContent['xl/theme/theme1.xml'] = $this->getWriterPartTheme()->writeTheme($this->spreadSheet);
 
        // Add string table to ZIP file
        $zipContent['xl/sharedStrings.xml'] = $this->getWriterPartStringTable()->writeStringTable($this->stringTable);
 
        // Add styles to ZIP file
        $zipContent['xl/styles.xml'] = $this->getWriterPartStyle()->writeStyles($this->spreadSheet);
 
        // Add workbook to ZIP file
        $zipContent['xl/workbook.xml'] = $this->getWriterPartWorkbook()->writeWorkbook($this->spreadSheet, $this->preCalculateFormulas);
 
        $chartCount = 0;
        // Add worksheets
        for ($i = 0; $i < $this->spreadSheet->getSheetCount(); ++$i) {
            $zipContent['xl/worksheets/sheet' . ($i + 1) . '.xml'] = $this->getWriterPartWorksheet()->writeWorksheet($this->spreadSheet->getSheet($i), $this->stringTable, $this->includeCharts);
            if ($this->includeCharts) {
                $charts = $this->spreadSheet->getSheet($i)->getChartCollection();
                if (count($charts) > 0) {
                    foreach ($charts as $chart) {
                        $zipContent['xl/charts/chart' . ($chartCount + 1) . '.xml'] = $this->getWriterPartChart()->writeChart($chart, $this->preCalculateFormulas);
                        ++$chartCount;
                    }
                }
            }
        }
 
        $chartRef1 = 0;
        // Add worksheet relationships (drawings, ...)
        for ($i = 0; $i < $this->spreadSheet->getSheetCount(); ++$i) {
            // Add relationships
            $zipContent['xl/worksheets/_rels/sheet' . ($i + 1) . '.xml.rels'] = $this->getWriterPartRels()->writeWorksheetRelationships($this->spreadSheet->getSheet($i), ($i + 1), $this->includeCharts);
 
            // Add unparsedLoadedData
            $sheetCodeName = $this->spreadSheet->getSheet($i)->getCodeName();
            $unparsedLoadedData = $this->spreadSheet->getUnparsedLoadedData();
            if (isset($unparsedLoadedData['sheets'][$sheetCodeName]['ctrlProps'])) {
                foreach ($unparsedLoadedData['sheets'][$sheetCodeName]['ctrlProps'] as $ctrlProp) {
                    $zipContent[$ctrlProp['filePath']] = $ctrlProp['content'];
                }
            }
            if (isset($unparsedLoadedData['sheets'][$sheetCodeName]['printerSettings'])) {
                foreach ($unparsedLoadedData['sheets'][$sheetCodeName]['printerSettings'] as $ctrlProp) {
                    $zipContent[$ctrlProp['filePath']] = $ctrlProp['content'];
                }
            }
 
            $drawings = $this->spreadSheet->getSheet($i)->getDrawingCollection();
            $drawingCount = count($drawings);
            if ($this->includeCharts) {
                $chartCount = $this->spreadSheet->getSheet($i)->getChartCount();
            }
 
            // Add drawing and image relationship parts
            if (($drawingCount > 0) || ($chartCount > 0)) {
                // Drawing relationships
                $zipContent['xl/drawings/_rels/drawing' . ($i + 1) . '.xml.rels'] = $this->getWriterPartRels()->writeDrawingRelationships($this->spreadSheet->getSheet($i), $chartRef1, $this->includeCharts);
 
                // Drawings
                $zipContent['xl/drawings/drawing' . ($i + 1) . '.xml'] = $this->getWriterPartDrawing()->writeDrawings($this->spreadSheet->getSheet($i), $this->includeCharts);
            } elseif (isset($unparsedLoadedData['sheets'][$sheetCodeName]['drawingAlternateContents'])) {
                // Drawings
                $zipContent['xl/drawings/drawing' . ($i + 1) . '.xml'] = $this->getWriterPartDrawing()->writeDrawings($this->spreadSheet->getSheet($i), $this->includeCharts);
            }
 
            // Add unparsed drawings
            if (isset($unparsedLoadedData['sheets'][$sheetCodeName]['Drawings'])) {
                foreach ($unparsedLoadedData['sheets'][$sheetCodeName]['Drawings'] as $relId => $drawingXml) {
                    $drawingFile = array_search($relId, $unparsedLoadedData['sheets'][$sheetCodeName]['drawingOriginalIds']);
                    if ($drawingFile !== false) {
                        $drawingFile = ltrim($drawingFile, '.');
                        $zipContent['xl' . $drawingFile] = $drawingXml;
                    }
                }
            }
 
            // Add comment relationship parts
            if (count($this->spreadSheet->getSheet($i)->getComments()) > 0) {
                // VML Comments
                $zipContent['xl/drawings/vmlDrawing' . ($i + 1) . '.vml'] = $this->getWriterPartComments()->writeVMLComments($this->spreadSheet->getSheet($i));
 
                // Comments
                $zipContent['xl/comments' . ($i + 1) . '.xml'] = $this->getWriterPartComments()->writeComments($this->spreadSheet->getSheet($i));
            }
 
            // Add unparsed relationship parts
            if (isset($unparsedLoadedData['sheets'][$sheetCodeName]['vmlDrawings'])) {
                foreach ($unparsedLoadedData['sheets'][$sheetCodeName]['vmlDrawings'] as $vmlDrawing) {
                    $zipContent[$vmlDrawing['filePath']] = $vmlDrawing['content'];
                }
            }
 
            // Add header/footer relationship parts
            if (count($this->spreadSheet->getSheet($i)->getHeaderFooter()->getImages()) > 0) {
                // VML Drawings
                $zipContent['xl/drawings/vmlDrawingHF' . ($i + 1) . '.vml'] = $this->getWriterPartDrawing()->writeVMLHeaderFooterImages($this->spreadSheet->getSheet($i));
 
                // VML Drawing relationships
                $zipContent['xl/drawings/_rels/vmlDrawingHF' . ($i + 1) . '.vml.rels'] = $this->getWriterPartRels()->writeHeaderFooterDrawingRelationships($this->spreadSheet->getSheet($i));
 
                // Media
                foreach ($this->spreadSheet->getSheet($i)->getHeaderFooter()->getImages() as $image) {
                    $zipContent['xl/media/' . $image->getIndexedFilename()] = file_get_contents($image->getPath());
                }
            }
        }
 
        // Add media
        for ($i = 0; $i < $this->getDrawingHashTable()->count(); ++$i) {
            if ($this->getDrawingHashTable()->getByIndex($i) instanceof WorksheetDrawing) {
                $imageContents = null;
                $imagePath = $this->getDrawingHashTable()->getByIndex($i)->getPath();
                if (strpos($imagePath, 'zip://') !== false) {
                    $imagePath = substr($imagePath, 6);
                    $imagePathSplitted = explode('#', $imagePath);
 
                    $imageZip = new ZipArchive();
                    $imageZip->open($imagePathSplitted[0]);
                    $imageContents = $imageZip->getFromName($imagePathSplitted[1]);
                    $imageZip->close();
                    unset($imageZip);
                } else {
                    $imageContents = file_get_contents($imagePath);
                }
 
                $zipContent['xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename())] = $imageContents;
            } elseif ($this->getDrawingHashTable()->getByIndex($i) instanceof MemoryDrawing) {
                ob_start();
                call_user_func(
                    $this->getDrawingHashTable()->getByIndex($i)->getRenderingFunction(),
                    $this->getDrawingHashTable()->getByIndex($i)->getImageResource()
                );
                $imageContents = ob_get_contents();
                ob_end_clean();
 
                $zipContent['xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename())] = $imageContents;
            }
        }
 
        Functions::setReturnDateType($saveDateReturnType);
        Calculation::getInstance($this->spreadSheet)->getDebugLog()->setWriteDebugLog($saveDebugLog);
 
        $this->openFileHandle($pFilename);
 
        $options = new Archive();
        $options->setEnableZip64(false);
        $options->setOutputStream($this->fileHandle);
 
        $this->zip = new ZipStream(null, $options);
 
        $this->addZipFiles($zipContent);
 
        // Close file
        try {
            $this->zip->finish();
        } catch (OverflowException $e) {
            throw new WriterException('Could not close resource.');
        }
 
        $this->maybeCloseFileHandle();
    }

Here is the call graph for this function:

◆ setOffice2003Compatibility()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::setOffice2003Compatibility ( $pValue )

Set Office2003 compatibility.

Parameters

bool $pValue Office2003 compatibility?

Returns: $this

Definition at line 645 of file Xlsx.php.

    {
        $this->office2003compatibility = $pValue;
 
        return $this;
    }

◆ setSpreadsheet()

PhpOffice\PhpSpreadsheet\Writer\Xlsx::setSpreadsheet ( Spreadsheet $spreadsheet )

Set Spreadsheet object.

Parameters

Spreadsheet $spreadsheet PhpSpreadsheet object

Returns: $this

Definition at line 541 of file Xlsx.php.

    {
        $this->spreadSheet = $spreadsheet;
 
        return $this;
    }

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\__construct().

Here is the caller graph for this function:

Field Documentation

◆ $bordersHashTable

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$bordersHashTable

private

Definition at line 92 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getBordersHashTable().

◆ $drawingHashTable

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$drawingHashTable

private

Definition at line 106 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getDrawingHashTable().

◆ $fillHashTable

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$fillHashTable

private

Definition at line 78 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getFillHashTable().

◆ $fontHashTable

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$fontHashTable

private

Definition at line 85 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getFontHashTable().

◆ $numFmtHashTable

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$numFmtHashTable

private

Definition at line 99 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getNumFmtHashTable().

◆ $office2003compatibility

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$office2003compatibility = false

private

Definition at line 43 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getOffice2003Compatibility().

◆ $pathNames

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$pathNames = []

private

Definition at line 652 of file Xlsx.php.

◆ $spreadSheet

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$spreadSheet

private

Definition at line 50 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getSpreadsheet().

◆ $stringTable

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$stringTable = []

private

Definition at line 57 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\StringTable\flipStringTable(), PhpOffice\PhpSpreadsheet\Writer\Xlsx\getStringTable(), and PhpOffice\PhpSpreadsheet\Writer\Xlsx\save().

◆ $styleHashTable

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$styleHashTable

private

Definition at line 71 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getStyleHashTable().

◆ $stylesConditionalHashTable

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$stylesConditionalHashTable

private

Definition at line 64 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getStylesConditionalHashTable().

◆ $writerPartChart

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartChart

private

Definition at line 118 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartChart().

◆ $writerPartComments

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartComments

private

Definition at line 123 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartComments().

◆ $writerPartContentTypes

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartContentTypes

private

Definition at line 128 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartContentTypes().

◆ $writerPartDocProps

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartDocProps

private

Definition at line 133 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartDocProps().

◆ $writerPartDrawing

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartDrawing

private

Definition at line 138 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartDrawing().

◆ $writerPartRels

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartRels

private

Definition at line 143 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartRels().

◆ $writerPartRelsRibbon

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartRelsRibbon

private

Definition at line 148 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartRelsRibbon().

◆ $writerPartRelsVBA

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartRelsVBA

private

Definition at line 153 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartRelsVBA().

◆ $writerPartStringTable

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartStringTable

private

Definition at line 158 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartStringTable().

◆ $writerPartStyle

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartStyle

private

Definition at line 163 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartStyle().

◆ $writerPartTheme

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartTheme

private

Definition at line 168 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartTheme().

◆ $writerPartWorkbook

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartWorkbook

private

Definition at line 173 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartWorkbook().

◆ $writerPartWorksheet

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$writerPartWorksheet

private

Definition at line 178 of file Xlsx.php.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xlsx\getWriterPartWorksheet().

◆ $zip

PhpOffice\PhpSpreadsheet\Writer\Xlsx::$zip

private

Definition at line 113 of file Xlsx.php.

The documentation for this class was generated from the following file:

libs/composer/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php

Private Attributes
	$office2003compatibility = false

	$spreadSheet

	$stringTable = []

	$stylesConditionalHashTable

	$styleHashTable

	$fillHashTable

	$fontHashTable

	$bordersHashTable

	$numFmtHashTable

	$drawingHashTable

	$zip

	$writerPartChart

	$writerPartComments

	$writerPartContentTypes

	$writerPartDocProps

	$writerPartDrawing

	$writerPartRels

	$writerPartRelsRibbon

	$writerPartRelsVBA

	$writerPartStringTable

	$writerPartStyle

	$writerPartTheme

	$writerPartWorkbook

	$writerPartWorksheet

	$pathNames = []

Public Member Functions

Private Member Functions

Private Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addZipFile()

◆ addZipFiles()

◆ getBordersHashTable()

◆ getDrawingHashTable()

◆ getFillHashTable()

◆ getFontHashTable()

◆ getNumFmtHashTable()

◆ getOffice2003Compatibility()

◆ getSpreadsheet()

◆ getStringTable()

◆ getStyleHashTable()

◆ getStylesConditionalHashTable()

◆ getWriterPartChart()

◆ getWriterPartComments()

◆ getWriterPartContentTypes()

◆ getWriterPartDocProps()

◆ getWriterPartDrawing()

◆ getWriterPartRels()

◆ getWriterPartRelsRibbon()

◆ getWriterPartRelsVBA()

◆ getWriterPartStringTable()

◆ getWriterPartStyle()

◆ getWriterPartTheme()

◆ getWriterPartWorkbook()

◆ getWriterPartWorksheet()

◆ save()

◆ setOffice2003Compatibility()

◆ setSpreadsheet()

Field Documentation

◆ $bordersHashTable

◆ $drawingHashTable

◆ $fillHashTable

◆ $fontHashTable

◆ $numFmtHashTable

◆ $office2003compatibility

◆ $pathNames

◆ $spreadSheet

◆ $stringTable

◆ $styleHashTable

◆ $stylesConditionalHashTable

◆ $writerPartChart

◆ $writerPartComments

◆ $writerPartContentTypes

◆ $writerPartDocProps

◆ $writerPartDrawing

◆ $writerPartRels

◆ $writerPartRelsRibbon

◆ $writerPartRelsVBA

◆ $writerPartStringTable

◆ $writerPartStyle

◆ $writerPartTheme

◆ $writerPartWorkbook

◆ $writerPartWorksheet

◆ $zip