IExportExcelOptions

Type interface

Represents options for XLSX export.

Sources

IExportExcelOptions is an interface: it describes a shape of data and is not imported on its own.

Properties

#addColumnNames

Type booleanDefault 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 booleanSince 4.9.11

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

#emptyAs

Type anyDefault "" (empty string)

Replace missing values with this.

#pivot

Type booleanDefault falseSince 4.6.8

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

values in rows).

#useLocale

Type booleanDefault true

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

#useTimestamps

Type booleanDefault false

Use timestamps instead of formatted date/time values.