V
18.2
18.2
18.1
17.2
All docs
General Information
.NET Subscription
Desktop
Enterprise and Analytic Tools
Code / Debug / Refactor
Frameworks and Libraries
IOS, Android & Xamarin
All docs
V18.2
General Information
.NET Subscription
Desktop
Enterprise and Analytic Tools
Code / Debug / Refactor
Frameworks and Libraries
IOS, Android & Xamarin
18.2
18.1
17.2
DashboardExcelExportOptions Class
Contains options related to exporting a dashboard/dashboard item to the Excel format.
Namespace: DevExpress.DashboardCommon
Assembly: DevExpress.Dashboard.v18.2.Core.dll
Declaration
public class DashboardExcelExportOptions :
IDashboardExportOptionsPublic Class DashboardExcelExportOptions
Implements IDashboardExportOptionsThe following properties allow you to access default Excel-specific export options for different controls.
- ASPxDashboard.ExcelExportOptions / DashboardExtensionSettings.ExcelExportOptions
- DashboardDesigner.ExcelExportOptions
- DashboardViewer.ExcelExportOptions
- DashboardControl.ExcelExportOptions
Moreover, you can specify Excel options when exporting a dashboard/dashboard item using the following methods.
- WebDashboardExporter.ExportToExcel / WebDashboardExporter.ExportDashboardItemToExcel
- DashboardDesigner.ExportToExcel / DashboardDesigner.ExportDashboardItemToExcel
- DashboardViewer.ExportToExcel / DashboardViewer.ExportDashboardItemToExcel
- DashboardControl.ExportToExcel / DashboardControl.ExportDashboardItemToExcel
Note
To export a dashboard/dashboard item on the web using an API, use ExportToExcel / ExportDashboardItemToExcel methods exposed by the ASPxClientDashboard class.
Examples
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 _
})
Inheritance
Object
DashboardExcelExportOptions
See Also
We are updating the DevExpress product documentation website and this page is part of our new experience. During this transition period, product documentation remains available in our previous format at documentation.devexpress.com. Learn More...
give feedback
Was this topic helpful?
Did it help answer your question?
Did it help answer your question?