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

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.

@default true

disabled
#

Type boolean

Set this option to disabled for a format to not show up in ExportMenu.

@since 4.9.11

emptyAs
#

Type any

Replace missing values with this.

@default "" (empty string)

pivot
#

Type boolean

If set to true will export data as pivoted (column names in first column;

values in rows).

@default false
@since 4.6.8

useLocale
#

Type boolean

Will try to format numbers and date/time according to user's locale settings.

@default true

useTimestamps
#

Type boolean

Use timestamps instead of formatted date/time values.

@default false