Documentation

IExportExcelOptions

Type interface

Represents options for XLSX export.

Inheritance

IExportExcelOptions does not extend any other symbol.

IExportExcelOptions is not extended by any other symbol.

Properties

addColumnNames #	Type `boolean` Default `true` Add column names in first row? Export will try to use user-friendly column names where possible, either from Export's `dataFields` or deduced from chart's series' names that are bound to specific data fields.
disabled #	Type `boolean` Set this option to `disabled` for a format to not show up in `ExportMenu`. @since 4.9.11
emptyAs #	Type `any` Default `"" (empty string)` Replace missing values with this.
pivot #	Type `boolean` Default `false` If set to `true` will export data as pivoted (column names in first column; values in rows). @since 4.6.8
useLocale #	Type `boolean` Default `true` Will try to format numbers and date/time according to user's locale settings.
useTimestamps #	Type `boolean` Default `false` Use timestamps instead of formatted date/time values.