Documentation

IExportingXLSXOptions

Type interface

Inheritance

IExportingXLSXOptions extends IExportingDataOptions.

IExportingXLSXOptions is not extended by any other symbol.

Properties

addColumnNames #	Type `undefined` \| `false` \| `true` Default `true` Inherited from `IExportingDataOptions` Adds the column names as the first row (or column, with `pivot`) in CSV, HTML, XLSX and PDF tables.
disabled #	Type `undefined` \| `false` \| `true` Inherited from `IExportingFormatOptions` Leaves this format out of the `ExportingMenu`.
emptyAs #	Type `undefined` \| `string` Inherited from `IExportingDataOptions` Text for empty values: `"-"` in HTML by default, an empty string in the other formats.
escapeFormulas #	Type `undefined` \| `false` \| `true` Default `true` Protects against spreadsheet formula injection: text values that start with `=`, `+`, `-`, `@`, a tab or a carriage return get a single quote in front, so they are read as plain text. @since 5.19.0
pivot #	Type `undefined` \| `false` \| `true` Inherited from `IExportingDataOptions` Swaps rows and columns, so that each field is a row.
useLocale #	Type `undefined` \| `false` \| `true` Default `false` Inherited from `IExportingDataOptions` Formats dates in the browser's locale instead of with `dateFormat`.
useTimestamps #	Type `undefined` \| `false` \| `true` Default `false` Inherited from `IExportingDataOptions` Exports dates as timestamps instead of formatted dates.
There are 6 inherited items currently hidden from this list.