PhpSpreadsheet XlsxExporterType
The XlsxExporterType
represents an exporter that uses an 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
.
Inherited options
use_headers
- type:
bool
- default:
true
Determines whether the exporter should add headers to the output file.
label
- type:
null
orstring
- default:
null
the label is "guessed" from the exporter name
Sets the label of the exporter, visible in the export action modal.
tempnam_dir
- type:
string
- default: the value returned by the
sys_get_temp_dir()
function
Sets the directory used to store temporary file during the export process.
tempnam_prefix
- type:
string
- default:
exporter_
Sets the prefix used to generate temporary file names during the export process.
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. The value of this option determines whether the formula pre-calculation is enabled.