Inheritance diagram for PHPExcel_Writer_Excel2007:

Collaboration diagram for PHPExcel_Writer_Excel2007:

Public Member Functions
	__construct (PHPExcel $pPHPExcel=null)
	Create a new PHPExcel_Writer_Excel2007. More...

	getWriterPart ($pPartName='')
	Get writer part. More...

	save ($pFilename=null)
	Save PHPExcel to file. More...

	getPHPExcel ()
	Get PHPExcel object. More...

	setPHPExcel (PHPExcel $pPHPExcel=null)
	Set PHPExcel object. More...

	getStringTable ()
	Get string table. More...

	getStyleHashTable ()
	Get PHPExcel_Style HashTable. More...

	getStylesConditionalHashTable ()
	Get PHPExcel_Style_Conditional HashTable. More...

	getFillHashTable ()
	Get PHPExcel_Style_Fill HashTable. More...

	getFontHashTable ()
	Get PHPExcel_Style_Font HashTable. More...

	getBordersHashTable ()
	Get PHPExcel_Style_Borders HashTable. More...

	getNumFmtHashTable ()
	Get PHPExcel_Style_NumberFormat HashTable. More...

	getDrawingHashTable ()
	Get PHPExcel_Worksheet_BaseDrawing HashTable. More...

	getOffice2003Compatibility ()
	Get Office2003 compatibility. More...

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

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

	setIncludeCharts ($pValue=FALSE)
	Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PHPExcel 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=TRUE)
	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=FALSE, $pDirectory=NULL)
	Set use disk caching where possible? More...

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

	save ($pFilename=NULL)
	Save PHPExcel to file. More...

Protected Attributes
	$_preCalculateFormulas = FALSE

Protected Attributes inherited from PHPExcel_Writer_Abstract
	$_includeCharts = FALSE

	$_preCalculateFormulas = TRUE

	$_useDiskCaching = FALSE

	$_diskCachingDirectory = './'

Private Attributes
	$_office2003compatibility = false

	$_writerParts = array()

	$_spreadSheet

	$_stringTable = array()

	$_stylesConditionalHashTable

	$_styleHashTable

	$_fillHashTable

	$_fontHashTable

	$_bordersHashTable

	$_numFmtHashTable

	$_drawingHashTable

Detailed Description

Definition at line 36 of file Excel2007.php.

Constructor & Destructor Documentation

◆ __construct()

PHPExcel_Writer_Excel2007::__construct ( PHPExcel $pPHPExcel = null )

Create a new PHPExcel_Writer_Excel2007.

@param      PHPExcel        $pPHPExcel

Definition at line 131 of file Excel2007.php.

    {
        // Assign PHPExcel
                $this->setPHPExcel($pPHPExcel);
 
        $writerPartsArray = array(      'stringtable'   => 'PHPExcel_Writer_Excel2007_StringTable',
                                                                        'contenttypes'  => 'PHPExcel_Writer_Excel2007_ContentTypes',
                                                                        'docprops'              => 'PHPExcel_Writer_Excel2007_DocProps',
                                                                        'rels'                  => 'PHPExcel_Writer_Excel2007_Rels',
                                                                        'theme'                 => 'PHPExcel_Writer_Excel2007_Theme',
                                                                        'style'                 => 'PHPExcel_Writer_Excel2007_Style',
                                                                        'workbook'              => 'PHPExcel_Writer_Excel2007_Workbook',
                                                                        'worksheet'     => 'PHPExcel_Writer_Excel2007_Worksheet',
                                                                        'drawing'               => 'PHPExcel_Writer_Excel2007_Drawing',
                                                                        'comments'              => 'PHPExcel_Writer_Excel2007_Comments',
                                                                        'chart'                 => 'PHPExcel_Writer_Excel2007_Chart',
                                                                        'relsvba'               => 'PHPExcel_Writer_Excel2007_RelsVBA',
                                                                        'relsribbonobjects' => 'PHPExcel_Writer_Excel2007_RelsRibbon'
                                                                 );
 
        //      Initialise writer parts
                //              and Assign their parent IWriters
                foreach ($writerPartsArray as $writer => $class) {
                        $this->_writerParts[$writer] = new $class($this);
                }
 
        $hashTablesArray = array( '_stylesConditionalHashTable',        '_fillHashTable',               '_fontHashTable',
                                                                  '_bordersHashTable',                          '_numFmtHashTable',             '_drawingHashTable',
                                  '_styleHashTable'
                                                            );
 
                // Set HashTable variables
                foreach ($hashTablesArray as $tableName) {
                        $this->$tableName       = new PHPExcel_HashTable();
                }
    }

References setPHPExcel().

Here is the call graph for this function:

Member Function Documentation

◆ getBordersHashTable()

PHPExcel_Writer_Excel2007::getBordersHashTable ( )

Get PHPExcel_Style_Borders HashTable.

Returns: PHPExcel_HashTable

Definition at line 490 of file Excel2007.php.

                                          {
        return $this->_bordersHashTable;
    }

References $_bordersHashTable.

◆ getDrawingHashTable()

PHPExcel_Writer_Excel2007::getDrawingHashTable ( )

Get PHPExcel_Worksheet_BaseDrawing HashTable.

Returns: PHPExcel_HashTable

Definition at line 508 of file Excel2007.php.

                                          {
        return $this->_drawingHashTable;
    }

References $_drawingHashTable.

Referenced by save().

Here is the caller graph for this function:

◆ getFillHashTable()

PHPExcel_Writer_Excel2007::getFillHashTable ( )

Get PHPExcel_Style_Fill HashTable.

Returns: PHPExcel_HashTable

Definition at line 472 of file Excel2007.php.

                                       {
        return $this->_fillHashTable;
    }

References $_fillHashTable.

◆ getFontHashTable()

PHPExcel_Writer_Excel2007::getFontHashTable ( )

Get PHPExcel_Style_Font HashTable.

Returns: PHPExcel_HashTable

Definition at line 481 of file Excel2007.php.

                                       {
        return $this->_fontHashTable;
    }

References $_fontHashTable.

◆ getNumFmtHashTable()

PHPExcel_Writer_Excel2007::getNumFmtHashTable ( )

Get PHPExcel_Style_NumberFormat HashTable.

Returns: PHPExcel_HashTable

Definition at line 499 of file Excel2007.php.

                                         {
        return $this->_numFmtHashTable;
    }

References $_numFmtHashTable.

◆ getOffice2003Compatibility()

PHPExcel_Writer_Excel2007::getOffice2003Compatibility ( )

Get Office2003 compatibility.

Returns: boolean

Definition at line 517 of file Excel2007.php.

                                                 {
        return $this->_office2003compatibility;
    }

References $_office2003compatibility.

◆ getPHPExcel()

PHPExcel_Writer_Excel2007::getPHPExcel ( )

Get PHPExcel object.

Returns: PHPExcel

Exceptions

PHPExcel_Writer_Exception

Definition at line 420 of file Excel2007.php.

                                      {
                if ($this->_spreadSheet !== null) {
                        return $this->_spreadSheet;
                } else {
                        throw new PHPExcel_Writer_Exception("No PHPExcel assigned.");
                }
        }

References $_spreadSheet.

◆ getStringTable()

PHPExcel_Writer_Excel2007::getStringTable ( )

Get string table.

Returns: string[]

Definition at line 445 of file Excel2007.php.

                                     {
        return $this->_stringTable;
    }

References $_stringTable.

◆ getStyleHashTable()

PHPExcel_Writer_Excel2007::getStyleHashTable ( )

Get PHPExcel_Style HashTable.

Returns: PHPExcel_HashTable

Definition at line 454 of file Excel2007.php.

                                        {
        return $this->_styleHashTable;
    }

References $_styleHashTable.

◆ getStylesConditionalHashTable()

PHPExcel_Writer_Excel2007::getStylesConditionalHashTable ( )

Get PHPExcel_Style_Conditional HashTable.

Returns: PHPExcel_HashTable

Definition at line 463 of file Excel2007.php.

                                                    {
        return $this->_stylesConditionalHashTable;
    }

References $_stylesConditionalHashTable.

◆ getWriterPart()

PHPExcel_Writer_Excel2007::getWriterPart ( $pPartName = '' )

Get writer part.

Parameters

string $pPartName Writer part name

Returns: PHPExcel_Writer_Excel2007_WriterPart

Definition at line 174 of file Excel2007.php.

                                                       {
                if ($pPartName != '' && isset($this->_writerParts[strtolower($pPartName)])) {
                        return $this->_writerParts[strtolower($pPartName)];
                } else {
                        return null;
                }
        }

Referenced by save().

Here is the caller graph for this function:

◆ save()

PHPExcel_Writer_Excel2007::save ( $pFilename = null )

Save PHPExcel to file.

Parameters

string $pFilename

Exceptions

PHPExcel_Writer_Exception

Implements PHPExcel_Writer_IWriter.

Definition at line 188 of file Excel2007.php.

        {
                if ($this->_spreadSheet !== NULL) {
                        // garbage collect
                        $this->_spreadSheet->garbageCollect();
 
                        // If $pFilename is php://output or php://stdout, make it a temporary file...
                        $originalFilename = $pFilename;
                        if (strtolower($pFilename) == 'php://output' || strtolower($pFilename) == 'php://stdout') {
                                $pFilename = @tempnam(PHPExcel_Shared_File::sys_get_temp_dir(), 'phpxltmp');
                                if ($pFilename == '') {
                                        $pFilename = $originalFilename;
                                }
                        }
 
                        $saveDebugLog = PHPExcel_Calculation::getInstance($this->_spreadSheet)->getDebugLog()->getWriteDebugLog();
                        PHPExcel_Calculation::getInstance($this->_spreadSheet)->getDebugLog()->setWriteDebugLog(FALSE);
                        $saveDateReturnType = PHPExcel_Calculation_Functions::getReturnDateType();
                        PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
 
                        // Create string lookup table
                        $this->_stringTable = array();
                        for ($i = 0; $i < $this->_spreadSheet->getSheetCount(); ++$i) {
                                $this->_stringTable = $this->getWriterPart('StringTable')->createStringTable($this->_spreadSheet->getSheet($i), $this->_stringTable);
                        }
 
                        // Create styles dictionaries
                        $this->_styleHashTable->addFromSource(              $this->getWriterPart('Style')->allStyles($this->_spreadSheet)                       );
                        $this->_stylesConditionalHashTable->addFromSource(      $this->getWriterPart('Style')->allConditionalStyles($this->_spreadSheet)                        );
                        $this->_fillHashTable->addFromSource(                           $this->getWriterPart('Style')->allFills($this->_spreadSheet)                    );
                        $this->_fontHashTable->addFromSource(                           $this->getWriterPart('Style')->allFonts($this->_spreadSheet)                    );
                        $this->_bordersHashTable->addFromSource(                        $this->getWriterPart('Style')->allBorders($this->_spreadSheet)                  );
                        $this->_numFmtHashTable->addFromSource(                         $this->getWriterPart('Style')->allNumberFormats($this->_spreadSheet)    );
 
                        // Create drawing dictionary
                        $this->_drawingHashTable->addFromSource(                        $this->getWriterPart('Drawing')->allDrawings($this->_spreadSheet)               );
 
                        // Create new ZIP file and open it for writing
                        $zipClass = PHPExcel_Settings::getZipClass();
                        $objZip = new $zipClass();
 
                        //      Retrieve OVERWRITE and CREATE constants from the instantiated zip class
                        //      This method of accessing constant values from a dynamic class should work with all appropriate versions of PHP
                        $ro = new ReflectionObject($objZip);
                        $zipOverWrite = $ro->getConstant('OVERWRITE');
                        $zipCreate = $ro->getConstant('CREATE');
 
                        if (file_exists($pFilename)) {
                                unlink($pFilename);
                        }
                        // Try opening the ZIP file
                        if ($objZip->open($pFilename, $zipOverWrite) !== true) {
                                if ($objZip->open($pFilename, $zipCreate) !== true) {
                                        throw new PHPExcel_Writer_Exception("Could not open " . $pFilename . " for writing.");
                                }
                        }
 
                        // Add [Content_Types].xml to ZIP file
                        $objZip->addFromString('[Content_Types].xml',                   $this->getWriterPart('ContentTypes')->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(!is_null($macrosCode)){// we have the code ?
                                        $objZip->addFromString('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
                                                $objZip->addFromString('xl/vbaProjectSignature.bin', $this->_spreadSheet->getMacrosCertificate());
                                                $objZip->addFromString('xl/_rels/vbaProject.bin.rels',
                                                        $this->getWriterPart('RelsVBA')->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');
                                $objZip->addFromString($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){
                                                $objZip->addFromString($tmpRootPath.$aPath, $aContent);
                                        }
                                        //the rels for files
                                        $objZip->addFromString($tmpRootPath.'_rels/'.basename($tmpRibbonTarget).'.rels',
                                                $this->getWriterPart('RelsRibbonObjects')->writeRibbonRelationships($this->_spreadSheet));
                                }
                        }
                        
                        // Add relationships to ZIP file
                        $objZip->addFromString('_rels/.rels',                                   $this->getWriterPart('Rels')->writeRelationships($this->_spreadSheet));
                        $objZip->addFromString('xl/_rels/workbook.xml.rels',    $this->getWriterPart('Rels')->writeWorkbookRelationships($this->_spreadSheet));
 
                        // Add document properties to ZIP file
                        $objZip->addFromString('docProps/app.xml',                              $this->getWriterPart('DocProps')->writeDocPropsApp($this->_spreadSheet));
                        $objZip->addFromString('docProps/core.xml',                     $this->getWriterPart('DocProps')->writeDocPropsCore($this->_spreadSheet));
                        $customPropertiesPart = $this->getWriterPart('DocProps')->writeDocPropsCustom($this->_spreadSheet);
                        if ($customPropertiesPart !== NULL) {
                                $objZip->addFromString('docProps/custom.xml',           $customPropertiesPart);
                        }
 
                        // Add theme to ZIP file
                        $objZip->addFromString('xl/theme/theme1.xml',                   $this->getWriterPart('Theme')->writeTheme($this->_spreadSheet));
 
                        // Add string table to ZIP file
                        $objZip->addFromString('xl/sharedStrings.xml',                  $this->getWriterPart('StringTable')->writeStringTable($this->_stringTable));
 
                        // Add styles to ZIP file
                        $objZip->addFromString('xl/styles.xml',                                 $this->getWriterPart('Style')->writeStyles($this->_spreadSheet));
 
                        // Add workbook to ZIP file
                        $objZip->addFromString('xl/workbook.xml',                               $this->getWriterPart('Workbook')->writeWorkbook($this->_spreadSheet, $this->_preCalculateFormulas));
 
                        $chartCount = 0;
                        // Add worksheets
                        for ($i = 0; $i < $this->_spreadSheet->getSheetCount(); ++$i) {
                                $objZip->addFromString('xl/worksheets/sheet' . ($i + 1) . '.xml', $this->getWriterPart('Worksheet')->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) {
                                                        $objZip->addFromString('xl/charts/chart' . ($chartCount + 1) . '.xml', $this->getWriterPart('Chart')->writeChart($chart));
                                                        $chartCount++;
                                                }
                                        }
                                }
                        }
 
                        $chartRef1 = $chartRef2 = 0;
                        // Add worksheet relationships (drawings, ...)
                        for ($i = 0; $i < $this->_spreadSheet->getSheetCount(); ++$i) {
 
                                // Add relationships
                                $objZip->addFromString('xl/worksheets/_rels/sheet' . ($i + 1) . '.xml.rels',    $this->getWriterPart('Rels')->writeWorksheetRelationships($this->_spreadSheet->getSheet($i), ($i + 1), $this->_includeCharts));
 
                                $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
                                        $objZip->addFromString('xl/drawings/_rels/drawing' . ($i + 1) . '.xml.rels', $this->getWriterPart('Rels')->writeDrawingRelationships($this->_spreadSheet->getSheet($i),$chartRef1, $this->_includeCharts));
 
                                        // Drawings
                                        $objZip->addFromString('xl/drawings/drawing' . ($i + 1) . '.xml', $this->getWriterPart('Drawing')->writeDrawings($this->_spreadSheet->getSheet($i),$chartRef2,$this->_includeCharts));
                                }
 
                                // Add comment relationship parts
                                if (count($this->_spreadSheet->getSheet($i)->getComments()) > 0) {
                                        // VML Comments
                                        $objZip->addFromString('xl/drawings/vmlDrawing' . ($i + 1) . '.vml', $this->getWriterPart('Comments')->writeVMLComments($this->_spreadSheet->getSheet($i)));
 
                                        // Comments
                                        $objZip->addFromString('xl/comments' . ($i + 1) . '.xml', $this->getWriterPart('Comments')->writeComments($this->_spreadSheet->getSheet($i)));
                                }
 
                                // Add header/footer relationship parts
                                if (count($this->_spreadSheet->getSheet($i)->getHeaderFooter()->getImages()) > 0) {
                                        // VML Drawings
                                        $objZip->addFromString('xl/drawings/vmlDrawingHF' . ($i + 1) . '.vml', $this->getWriterPart('Drawing')->writeVMLHeaderFooterImages($this->_spreadSheet->getSheet($i)));
 
                                        // VML Drawing relationships
                                        $objZip->addFromString('xl/drawings/_rels/vmlDrawingHF' . ($i + 1) . '.vml.rels', $this->getWriterPart('Rels')->writeHeaderFooterDrawingRelationships($this->_spreadSheet->getSheet($i)));
 
                                        // Media
                                        foreach ($this->_spreadSheet->getSheet($i)->getHeaderFooter()->getImages() as $image) {
                                                $objZip->addFromString('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 PHPExcel_Worksheet_Drawing) {
                                        $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);
                                        }
 
                                        $objZip->addFromString('xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents);
                                } else if ($this->getDrawingHashTable()->getByIndex($i) instanceof PHPExcel_Worksheet_MemoryDrawing) {
                                        ob_start();
                                        call_user_func(
                                                $this->getDrawingHashTable()->getByIndex($i)->getRenderingFunction(),
                                                $this->getDrawingHashTable()->getByIndex($i)->getImageResource()
                                        );
                                        $imageContents = ob_get_contents();
                                        ob_end_clean();
 
                                        $objZip->addFromString('xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents);
                                }
                        }
 
                        PHPExcel_Calculation_Functions::setReturnDateType($saveDateReturnType);
                        PHPExcel_Calculation::getInstance($this->_spreadSheet)->getDebugLog()->setWriteDebugLog($saveDebugLog);
 
                        // Close file
                        if ($objZip->close() === false) {
                                throw new PHPExcel_Writer_Exception("Could not close zip file $pFilename.");
                        }
 
                        // If a temporary file was used, copy it to the correct file stream
                        if ($originalFilename != $pFilename) {
                                if (copy($pFilename, $originalFilename) === false) {
                                        throw new PHPExcel_Writer_Exception("Could not copy temporary zip file $pFilename to $originalFilename.");
                                }
                                @unlink($pFilename);
                        }
                } else {
                        throw new PHPExcel_Writer_Exception("PHPExcel object unassigned.");
                }
        }

References $chart, $i, getDrawingHashTable(), PHPExcel_Calculation\getInstance(), PHPExcel_Calculation_Functions\getReturnDateType(), getWriterPart(), PHPExcel_Settings\getZipClass(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\setReturnDateType(), and PHPExcel_Shared_File\sys_get_temp_dir().

Here is the call graph for this function:

◆ setOffice2003Compatibility()

PHPExcel_Writer_Excel2007::setOffice2003Compatibility ( $pValue = false )

Set Office2003 compatibility.

Parameters

boolean $pValue Office2003 compatibility?

Returns: PHPExcel_Writer_Excel2007

Definition at line 527 of file Excel2007.php.

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

◆ setPHPExcel()

PHPExcel_Writer_Excel2007::setPHPExcel ( PHPExcel $pPHPExcel = null )

Set PHPExcel object.

Parameters

PHPExcel $pPHPExcel PHPExcel object

Exceptions

PHPExcel_Writer_Exception

Returns: PHPExcel_Writer_Excel2007

Definition at line 435 of file Excel2007.php.

                                                                {
                $this->_spreadSheet = $pPHPExcel;
                return $this;
        }

Referenced by __construct().

Here is the caller graph for this function:

Field Documentation

◆ $_bordersHashTable

PHPExcel_Writer_Excel2007::$_bordersHashTable

private

Definition at line 110 of file Excel2007.php.

Referenced by getBordersHashTable().

◆ $_drawingHashTable

PHPExcel_Writer_Excel2007::$_drawingHashTable

private

Definition at line 124 of file Excel2007.php.

Referenced by getDrawingHashTable().

◆ $_fillHashTable

PHPExcel_Writer_Excel2007::$_fillHashTable

private

Definition at line 96 of file Excel2007.php.

Referenced by getFillHashTable().

◆ $_fontHashTable

PHPExcel_Writer_Excel2007::$_fontHashTable

private

Definition at line 103 of file Excel2007.php.

Referenced by getFontHashTable().

◆ $_numFmtHashTable

PHPExcel_Writer_Excel2007::$_numFmtHashTable

private

Definition at line 117 of file Excel2007.php.

Referenced by getNumFmtHashTable().

◆ $_office2003compatibility

PHPExcel_Writer_Excel2007::$_office2003compatibility = false

private

Definition at line 54 of file Excel2007.php.

Referenced by getOffice2003Compatibility().

◆ $_preCalculateFormulas

PHPExcel_Writer_Excel2007::$_preCalculateFormulas = FALSE

protected

Pre-calculate formulas
Forces PHPExcel to 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

Overrides the default TRUE for this specific writer for performance reasons

@var boolean

Definition at line 47 of file Excel2007.php.

◆ $_spreadSheet

PHPExcel_Writer_Excel2007::$_spreadSheet

private

Definition at line 68 of file Excel2007.php.

Referenced by getPHPExcel().

◆ $_stringTable

PHPExcel_Writer_Excel2007::$_stringTable = array()

private

Definition at line 75 of file Excel2007.php.

Referenced by getStringTable().

◆ $_styleHashTable

PHPExcel_Writer_Excel2007::$_styleHashTable

private

Definition at line 89 of file Excel2007.php.

Referenced by getStyleHashTable().

◆ $_stylesConditionalHashTable

PHPExcel_Writer_Excel2007::$_stylesConditionalHashTable

private

Definition at line 82 of file Excel2007.php.

Referenced by getStylesConditionalHashTable().

◆ $_writerParts

PHPExcel_Writer_Excel2007::$_writerParts = array()

private

Definition at line 61 of file Excel2007.php.

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

libs/composer/vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007.php

Public Member Functions

Protected Attributes

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ getBordersHashTable()

◆ getDrawingHashTable()

◆ getFillHashTable()

◆ getFontHashTable()

◆ getNumFmtHashTable()

◆ getOffice2003Compatibility()

◆ getPHPExcel()

◆ getStringTable()

◆ getStyleHashTable()

◆ getStylesConditionalHashTable()

◆ getWriterPart()

◆ save()

◆ setOffice2003Compatibility()

◆ setPHPExcel()

Field Documentation

◆ $_bordersHashTable

◆ $_drawingHashTable

◆ $_fillHashTable

◆ $_fontHashTable

◆ $_numFmtHashTable

◆ $_office2003compatibility

◆ $_preCalculateFormulas

◆ $_spreadSheet

◆ $_stringTable

◆ $_styleHashTable

◆ $_stylesConditionalHashTable

◆ $_writerParts