IExportCSVOptions

Type interface

Represents options for CSV export.

Sources

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

Properties

#addBOM

Type booleanDefault falseSince 4.10.21

Add BOM character to output file, so that it can be used with UTF-8 characters properly in Excel.

#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.

#forceQuotes

Type booleanDefault false

CSV format does not require enclosing values in quotes, unless it contains strings.

This setting can be used to enforce enclosing of all values in CSV with quotes.

#pivot

Type booleanDefault falseSince 4.6.8

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

values in rows).

#reverse

Type booleanDefault false

Add rows in reverse order.

#separator

Type stringDefault ","

Separator string to separate columns with.

#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.