Documentation

IExportingXLSXOptions

Type interface

Inheritance

IExportingXLSXOptions extends IExportingDataOptions.

IExportingXLSXOptions is not extended by any other symbol.

Properties

addColumnNames #	Type `undefined` \| `false` \| `true` Inherited from `IExportingDataOptions` Will add a line with column names in CSV/HTML/PDF tables.
disabled #	Type `undefined` \| `false` \| `true` Inherited from `IExportingFormatOptions` If set to `true`, this format will not appear in `ExportMenu`.
emptyAs #	Type `undefined` \| `string` Inherited from `IExportingDataOptions` Replace empty values with this string.
escapeFormulas #	Type `undefined` \| `false` \| `true` Default `true` If set to `false`, disables protection against spreadsheet formula injection (a.k.a. "CSV injection"). When enabled (default), string cell values that begin with a character that spreadsheet applications could interpret as the start of a formula (`=`, `+`, `-`, `@`, tab, or carriage return) are prefixed with a single quote so they are imported as plain text. @since 5.19.0
pivot #	Type `undefined` \| `false` \| `true` Inherited from `IExportingDataOptions` If set to `true` will pivot the table so that columns are horizontal.
useLocale #	Type `undefined` \| `false` \| `true` Default `false` Inherited from `IExportingDataOptions` Use client's locale when formatting dates.
useTimestamps #	Type `undefined` \| `false` \| `true` Default `false` Inherited from `IExportingDataOptions` Use timestamps instead of formatted dates.
There are 6 inherited items currently hidden from this list.