IExportCSVOptions

Type interface

Represents options for CSV export.

Inheritance

IExportCSVOptions does not extend any other symbol.

IExportCSVOptions is not extended by any other symbol.

Properties

addBOM
#

Type boolean

Default false

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

@since 4.10.21

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.

forceQuotes
#

Type boolean

Default 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 boolean

Default false

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

values in rows).

@since 4.6.8

reverse
#

Type boolean

Default false

Add rows in reverse order.

separator
#

Type string

Default ","

Separator string to separate columns with.

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.