DataTableBundle

Appearance

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 or string
  • 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.