DataTableBundle

Appearance

PhpSpreadsheet XlsExporterType ​

The XlsxExporterType represents an exporter that uses an PhpSpreadsheet XLS writer.

Options ​

This exporter type has no additional options.

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.