Documentation

Ods extends BaseWriter
in package

Table of Contents

Properties

$fileHandle  : resource
$includeCharts  : bool
Write charts that are defined in the workbook? Identifies whether the Writer should write definitions for any charts that exist in the PhpSpreadsheet object.
$preCalculateFormulas  : bool
Pre-calculate formulas Forces PhpSpreadsheet 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.
$diskCachingDirectory  : string
Disk caching directory.
$shouldCloseFile  : bool
$spreadSheet  : Spreadsheet
Private PhpSpreadsheet.
$useDiskCaching  : bool
Use disk caching where possible?
$writerPartContent  : Content
$writerPartMeta  : Meta
$writerPartMetaInf  : MetaInf
$writerPartMimetype  : Mimetype
$writerPartSettings  : Settings
$writerPartStyles  : Styles
$writerPartThumbnails  : Thumbnails

Methods

__construct()  : mixed
Create a new Ods.
getDiskCachingDirectory()  : string
Get disk caching directory.
getIncludeCharts()  : bool
Write charts in workbook? If this is true, then the Writer will write definitions for any charts that exist in the PhpSpreadsheet object.
getPreCalculateFormulas()  : bool
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 PhpSpreadsheet, but slower when opening the resulting file in MS Excel, because Excel has to recalculate the formulae itself.
getSpreadsheet()  : Spreadsheet
Get Spreadsheet object.
getUseDiskCaching()  : bool
Get use disk caching where possible?
getWriterPartContent()  : Content
getWriterPartMeta()  : Meta
getWriterPartMetaInf()  : MetaInf
getWriterPartMimetype()  : Mimetype
getWriterPartSettings()  : Settings
getWriterPartStyles()  : Styles
getWriterPartThumbnails()  : Thumbnails
openFileHandle()  : void
Open file handle.
save()  : void
Save PhpSpreadsheet to file.
setIncludeCharts()  : $this
Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object.
setPreCalculateFormulas()  : $this
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.
setSpreadsheet()  : $this
Set Spreadsheet object.
setUseDiskCaching()  : $this
Set use disk caching where possible?
maybeCloseFileHandle()  : void
Close file handle only if we opened it ourselves.
processFlags()  : void
createZip()  : ZipStream
Create zip object.

Properties

$includeCharts

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

protected bool $includeCharts = false

$preCalculateFormulas

Pre-calculate formulas Forces PhpSpreadsheet 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.

protected bool $preCalculateFormulas = true

$diskCachingDirectory

Disk caching directory.

private string $diskCachingDirectory = './'

$useDiskCaching

Use disk caching where possible?

private bool $useDiskCaching = false

$writerPartMeta

private Meta $writerPartMeta

$writerPartStyles

private Styles $writerPartStyles

Methods

__construct()

Create a new Ods.

public __construct(Spreadsheet $spreadsheet) : mixed
Parameters
$spreadsheet : Spreadsheet

The spreadsheet that we want to save using this Writer

getDiskCachingDirectory()

Get disk caching directory.

public getDiskCachingDirectory() : string
Return values
string

getIncludeCharts()

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

public getIncludeCharts() : bool

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

Return values
bool

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

public getPreCalculateFormulas() : bool
Return values
bool

getUseDiskCaching()

Get use disk caching where possible?

public getUseDiskCaching() : bool
Return values
bool

getWriterPartMeta()

public getWriterPartMeta() : Meta
Return values
Meta

getWriterPartStyles()

public getWriterPartStyles() : Styles
Return values
Styles

openFileHandle()

Open file handle.

public openFileHandle(resource|string $filename) : void
Parameters
$filename : resource|string

save()

Save PhpSpreadsheet to file.

public save(resource|string $filename[, int $flags = 0 ]) : void
Parameters
$filename : resource|string
$flags : int = 0

Flags that can change the behaviour of the Writer: self::SAVE_WITH_CHARTS Save any charts that are defined (if the Writer supports Charts) self::DISABLE_PRECALCULATE_FORMULAE Don't Precalculate formulae before saving the file

setIncludeCharts()

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

public setIncludeCharts(bool $includeCharts) : $this

Set to false (the default) to ignore charts.

Parameters
$includeCharts : bool
Return values
$this

setPreCalculateFormulas()

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.

public setPreCalculateFormulas(bool $precalculateFormulas) : $this
Parameters
$precalculateFormulas : bool

Pre-Calculate Formulas?

Return values
$this

setSpreadsheet()

Set Spreadsheet object.

public setSpreadsheet(Spreadsheet $spreadsheet) : $this
Parameters
$spreadsheet : Spreadsheet

PhpSpreadsheet object

Return values
$this

setUseDiskCaching()

Set use disk caching where possible?

public setUseDiskCaching(bool $useDiskCache[, string|null $cacheDirectory = null ]) : $this
Parameters
$useDiskCache : bool
$cacheDirectory : string|null = null

Disk caching directory

Return values
$this

maybeCloseFileHandle()

Close file handle only if we opened it ourselves.

protected maybeCloseFileHandle() : void

processFlags()

protected processFlags(int $flags) : void
Parameters
$flags : int

createZip()

Create zip object.

private createZip() : ZipStream
Return values
ZipStream

        
On this page

Search results