DashboardDesigner.ExportDashboardItemToExcel(String, String, DashboardExcelExportOptions) Method

Exports the dashboard item to the specified file in Excel format using specified export options.

Namespace: DevExpress.DashboardWin

Assembly: DevExpress.Dashboard.v18.2.Win.dll

Declaration

public void ExportDashboardItemToExcel(
    string dashboardItemName,
    string filePath,
    DashboardExcelExportOptions options
)
Public Sub ExportDashboardItemToExcel(
    dashboardItemName As String,
    filePath As String,
    options As DashboardExcelExportOptions
)

Parameters

Type Name Description
String dashboardItemName

A String that is the component name of the dashboard item to be exported.

String filePath

A String that specifies the path to the Excel file.

DashboardExcelExportOptions options

A DashboardExcelExportOptions object which specifies the Excel export options to be applied when the dashboard item is exported.

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
                }   
            );
See Also