Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.11.x will end 14 Nov 2022 (12 months plus 6 months extension).
  • Bug fixes for security issues in 3.11.x will end 13 Nov 2023 (18 months plus 12 months extension).
  • PHP version: minimum PHP 7.3.0 Note: minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is supported too.

Differences Between: [Versions 310 and 311] [Versions 311 and 400] [Versions 311 and 401] [Versions 311 and 402] [Versions 311 and 403] [Versions 39 and 311]

(no description)

File Size: 87 lines (3 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class


Interface: IWriter  - X-Ref

__construct(Spreadsheet $spreadsheet)   X-Ref
IWriter constructor.


getIncludeCharts()   X-Ref
Write charts in workbook?
If this is true, then the Writer will write definitions for any charts that exist in the PhpSpreadsheet object.
If false (the default) it will ignore any charts defined in the PhpSpreadsheet object.

return: bool

setIncludeCharts($pValue)   X-Ref
Set write charts in workbook
Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object.
Set to false (the default) to ignore charts.

param: bool $pValue
return: IWriter

getPreCalculateFormulas()   X-Ref
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.

return: bool

setPreCalculateFormulas($pValue)   X-Ref
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.

param: bool $pValue Pre-Calculate Formulas?
return: IWriter

save($pFilename)   X-Ref
Save PhpSpreadsheet to file.

param: resource|string $pFilename Name of the file to save

getUseDiskCaching()   X-Ref
Get use disk caching where possible?

return: bool

setUseDiskCaching($pValue, $pDirectory = null)   X-Ref
Set use disk caching where possible?

param: bool $pValue
param: string $pDirectory Disk caching directory
return: IWriter

getDiskCachingDirectory()   X-Ref
Get disk caching directory.

return: string