DashboardExcelExportOptions Class
Contains options related to exporting a dashboard/dashboard item to 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.
Warning
A use of ASPx
API reduces flexibility when you configure the control. The DashboardASPx
object. The control provides access to all client settings and allows you to implement complex scenarios. We recommend that you use the Dashboard
API to configure the Web Dashboard on the client. More information: Client-Side Functionality.
#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 Dashboard |
#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 (including 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 Dashboard |
#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.