DashboardExcelExportOptions Class

Contains options related to exporting a dashboard/dashboard item to the Excel format.

Declaration

declare class DashboardExcelExportOptions

Remarks

The ASPxClientDashboard.GetExcelExportOptions and ASPxClientDashboard.SetExcelExportOptions properties allow you to obtain and specify Excel-specific export options on the client side.

You can use the ASPxClientDashboard.ExportToExcel and ASPxClientDashboard.ExportDashboardItemToExcel methods to specify Excel options when exporting a dashboard/dashboard item.

Properties

CsvValueSeparator Property

Gets or sets a character used to separate values in a CSV document.

Declaration

CsvValueSeparator: string

Property Value

Type	Description
string	A string value that specifies the character used to separate values in a CSV document.

Remarks

Note that the CsvValueSeparator property is in effect when the DashboardExcelExportOptions.Format is set to DashboardExportExcelFormat.Csv.

DashboardStatePosition Property

Gets or sets the position of the dashboard state (such as master filter or current parameter values) in the exported document.

Declaration

DashboardStatePosition: string

Property Value

Type	Description
string	A DashboardStateExcelExportPosition object that specifies the position of the dashboard state in the exported document.

Remarks

To add a master state to the exported document, use the DashboardExcelExportOptions.ExportFilters property. To export current parameter values, enable the DashboardExcelExportOptions.ExportParameters flag.

ExportFilters Property

Gets or sets whether to add the state of master filter items to the exported document.

Declaration

ExportFilters: boolean

Property Value

Type	Description
boolean	true, to add the state of master filter items to the exported document; otherwise, false.

Remarks

To specify the position of the dashboard state (that includes the state of master filter items), use the DashboardExcelExportOptions.DashboardStatePosition property.

ExportParameters Property

Gets or sets whether to add current parameter values to the exported document.

Declaration

ExportParameters: boolean

Property Value

Type	Description
boolean	true, to add current parameter values to the exported document; otherwise, false.

Remarks

To specify the position of the dashboard state (that includes current parameter values), use the DashboardExcelExportOptions.DashboardStatePosition property.

Format Property

Gets or sets the Excel format in which the dashboard item is exported.

Declaration

Format: string

Property Value

Type	Description
string	A DashboardExportExcelFormat value that specifies the Excel format in which the dashboard item is exported.

IncludeHiddenParameters Property

Gets or sets whether to add current values of a hidden parameter to the exported document.

Declaration

IncludeHiddenParameters: boolean

Property Value

Type	Description
boolean	true, to add current values of a hidden parameter to the exported document; otherwise, false.

Remarks

Note that the IncludeHiddenParameters property requires enabling the DashboardExcelExportOptions.ExportParameters property.