XlsxExporterType
The XlsxExporterType represents an exporter that uses a PhpSpreadsheet XLSX writer.
Options
office_2003_compatibility
type: bool default: false
Because of a bug in the Office2003 compatibility pack, there can be some small issues when opening
Xlsx spreadsheets (mostly related to formula calculation). You can enable Office2003 compatibility by setting this option to true.
Office2003 compatibility option should only be used when needed because it disables several Office2007 file format options, resulting in a lower-featured Office2007 spreadsheet!
Inherited options
pre_calculate_formulas
type: bool default: true
By default, the PhpSpreadsheet writers pre-calculates all formulas in the spreadsheet. This can be slow on large spreadsheets, and maybe even unwanted. Value of this option determines whether the formula pre-calculation is enabled.
use_headers
type: bool default: true
If this value is true, the output will contain data table headers.
label
type: string default: []
Sets the label that will be used when rendering the exporter to the user. This is used in the export form, where user can select desired exporter (e.g. "CSV" or "XLSX").
label_translation_domain
type: false or string default: the default KreyuDataTable is used
Sets the translation domain used when translating the exporter label.
Setting the option to false disables translation.
tempnam_dir
type: string default: /tmp
Sets the directory, that the temporarily created export files will be saved to.
Internally, this value is passed as the first argument to the tempnam() function.
tempnam_prefix
type: string default: exporter_
Sets the prefix of the temporarily created export files.
Internally, this value is passed as the second argument to the tempnam() function.