Properties

$_includeCharts

$_includeCharts : boolean

Write charts that are defined in the workbook? Identifies whether the Writer should write definitions for any charts that exist in the PHPExcel object;

Type

boolean

$_preCalculateFormulas

$_preCalculateFormulas : boolean

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

Type

boolean

$_useDiskCaching

$_useDiskCaching : boolean

Use disk caching where possible?

Type

boolean

$_diskCachingDirectory

$_diskCachingDirectory : string

Disk caching directory

Type

string

$_office2003compatibility

$_office2003compatibility : boolean

Office2003 compatibility

Type

boolean

$_spreadSheet

$_spreadSheet : \PHPExcel

Private PHPExcel

Type

\PHPExcel

$_stringTable

$_stringTable : array<mixed,string>

Private string table

Type

array<mixed,string>

$_stylesConditionalHashTable

$_stylesConditionalHashTable : \PHPExcel_HashTable

Private unique PHPExcel_Style_Conditional HashTable

Type

\PHPExcel_HashTable

$_styleHashTable

$_styleHashTable : \PHPExcel_HashTable

Private unique PHPExcel_Style HashTable

Type

\PHPExcel_HashTable

$_fillHashTable

$_fillHashTable : \PHPExcel_HashTable

Private unique PHPExcel_Style_Fill HashTable

Type

\PHPExcel_HashTable

$_fontHashTable

$_fontHashTable : \PHPExcel_HashTable

Private unique PHPExcel_Style_Font HashTable

Type

\PHPExcel_HashTable

$_bordersHashTable

$_bordersHashTable : \PHPExcel_HashTable

Private unique PHPExcel_Style_Borders HashTable

Type

\PHPExcel_HashTable

$_numFmtHashTable

$_numFmtHashTable : \PHPExcel_HashTable

Private unique PHPExcel_Style_NumberFormat HashTable

Type

\PHPExcel_HashTable

$_drawingHashTable

$_drawingHashTable : \PHPExcel_HashTable

Private unique PHPExcel_Worksheet_BaseDrawing HashTable

Type

\PHPExcel_HashTable

Methods

getIncludeCharts()

getIncludeCharts() : boolean

Write charts in workbook? If this is true, then the Writer will write definitions for any charts that exist in the PHPExcel object.

If false (the default) it will ignore any charts defined in the PHPExcel object.

Returns

boolean

setIncludeCharts()

setIncludeCharts(boolean  $pValue = FALSE) : \PHPExcel_Writer_IWriter

Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PHPExcel object.

Set to false (the default) to ignore charts.

Parameters

boolean $pValue

Returns

\PHPExcel_Writer_IWriter

getPreCalculateFormulas()

getPreCalculateFormulas() : boolean

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. This is faster for saving in PHPExcel, but slower when opening the resulting file in MS Excel, because Excel has to recalculate the formulae itself

Returns

boolean

setPreCalculateFormulas()

setPreCalculateFormulas(boolean  $pValue = TRUE) : \PHPExcel_Writer_IWriter

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.

Parameters

boolean $pValue

Pre-Calculate Formulas?

Returns

\PHPExcel_Writer_IWriter

getUseDiskCaching()

getUseDiskCaching() : boolean

Get use disk caching where possible?

Returns

boolean

setUseDiskCaching()

setUseDiskCaching(boolean  $pValue = FALSE, string  $pDirectory = NULL) : \PHPExcel_Writer_Excel2007

Set use disk caching where possible?

Parameters

boolean $pValue
string $pDirectory

Disk caching directory

Throws

\PHPExcel_Writer_Exception

when directory does not exist

Returns

\PHPExcel_Writer_Excel2007

getDiskCachingDirectory()

getDiskCachingDirectory() : string

Get disk caching directory

Returns

string

__construct()

__construct(\PHPExcel  $pPHPExcel = null) 

Create a new PHPExcel_Writer_Excel2007

Parameters

\PHPExcel $pPHPExcel

getWriterPart()

getWriterPart(string  $pPartName = '') : \PHPExcel_Writer_Excel2007_WriterPart

Get writer part

Parameters

string $pPartName

Writer part name

Returns

\PHPExcel_Writer_Excel2007_WriterPart

save()

save(string  $pFilename = null) 

Save PHPExcel to file

@param string $pFilename Name of the file to save

Parameters

string $pFilename

Throws

\PHPExcel_Writer_Exception

getPHPExcel()

getPHPExcel() : \PHPExcel

Get PHPExcel object

Throws

\PHPExcel_Writer_Exception

Returns

\PHPExcel

setPHPExcel()

setPHPExcel(\PHPExcel  $pPHPExcel = null) : \PHPExcel_Writer_Excel2007

Set PHPExcel object

Parameters

\PHPExcel $pPHPExcel

PHPExcel object

Throws

\PHPExcel_Writer_Exception

Returns

\PHPExcel_Writer_Excel2007

getStringTable()

getStringTable() : array<mixed,string>

Get string table

Returns

array<mixed,string>

getStyleHashTable()

getStyleHashTable() : \PHPExcel_HashTable

Get PHPExcel_Style HashTable

Returns

\PHPExcel_HashTable

getStylesConditionalHashTable()

getStylesConditionalHashTable() : \PHPExcel_HashTable

Get PHPExcel_Style_Conditional HashTable

Returns

\PHPExcel_HashTable

getFillHashTable()

getFillHashTable() : \PHPExcel_HashTable

Get PHPExcel_Style_Fill HashTable

Returns

\PHPExcel_HashTable

getFontHashTable()

getFontHashTable() : \PHPExcel_HashTable

Get PHPExcel_Style_Font HashTable

Returns

\PHPExcel_HashTable

getBordersHashTable()

getBordersHashTable() : \PHPExcel_HashTable

Get PHPExcel_Style_Borders HashTable

Returns

\PHPExcel_HashTable

getNumFmtHashTable()

getNumFmtHashTable() : \PHPExcel_HashTable

Get PHPExcel_Style_NumberFormat HashTable

Returns

\PHPExcel_HashTable

getDrawingHashTable()

getDrawingHashTable() : \PHPExcel_HashTable

Get PHPExcel_Worksheet_BaseDrawing HashTable

Returns

\PHPExcel_HashTable

getOffice2003Compatibility()

getOffice2003Compatibility() : boolean

Get Office2003 compatibility

Returns

boolean

setOffice2003Compatibility()

setOffice2003Compatibility(boolean  $pValue = false) : \PHPExcel_Writer_Excel2007

Set Office2003 compatibility

Parameters

boolean $pValue

Office2003 compatibility?

Returns

\PHPExcel_Writer_Excel2007