Contains options related to exporting a dashboard/dashboard item to the Excel format.
Namespace: DevExpress.DashboardCommon
Assembly: DevExpress.Dashboard.v18.2.Core.dll
public class DashboardExcelExportOptions :
IDashboardExportOptionsPublic Class DashboardExcelExportOptions
Implements IDashboardExportOptionsThe following properties allow you to access default Excel-specific export options for different controls.
Moreover, you can specify Excel options when exporting a dashboard/dashboard item using the following methods.
To export a dashboard/dashboard item on the web using an API, use ExportToExcel / ExportDashboardItemToExcel methods exposed by the ASPxClientDashboard class.
The following code snippet shows how to export data visualized within the Chart dashboard item using the DashboardDesigner.ExportDashboardItemToExcel method in the XLSX format.
using DevExpress.DashboardCommon;
// ...
dashboardDesigner1.ExportDashboardItemToExcel("chartDashboardItem1", @"c:\temp\ExportedWorkbook.xlsx", new DashboardExcelExportOptions() {
Format = ExcelFormat.Xlsx
}
);
Imports DevExpress.DashboardCommon
' ...
dashboardDesigner1.ExportDashboardItemToExcel("chartDashboardItem1", "c:\temp\ExportedWorkbook.xlsx", New DashboardExcelExportOptions() With { _
Key .Format = ExcelFormat.Xlsx _
})