Class DataGridExcelExportExtensions

Represents a class that provides the extensions for exporting SfDataGrid into an Excel file.

Inheritance

System.Object

DataGridExcelExportExtensions

Namespace: Syncfusion.UI.Xaml.DataGrid.Export

Assembly: Syncfusion.GridExport.WinUI.dll

Syntax

public static class DataGridExcelExportExtensions : Object

Methods

ExportToExcel(SfDataGrid, ICollectionViewAdv, DataGridExcelExportOptions)

Declaration

public static ExcelEngine ExportToExcel(this SfDataGrid dataGrid, ICollectionViewAdv view, DataGridExcelExportOptions excelExportOptions)

Parameters

Type	Name	Description
SfDataGrid	dataGrid
ICollectionViewAdv	view
DataGridExcelExportOptions	excelExportOptions

Returns

Type
ExcelEngine

ExportToExcel(SfDataGrid, ICollectionViewAdv, DataGridExcelExportOptions, IWorksheet)

Exports the data in the SfDataGrid to a specified worksheet in an Excel document.

Declaration

public static void ExportToExcel(this SfDataGrid dataGrid, ICollectionViewAdv view, DataGridExcelExportOptions excelExportOptions, IWorksheet worksheet)

Parameters

Type	Name	Description
SfDataGrid	dataGrid	The SfDataGrid whose data will be exported.
ICollectionViewAdv	view	The view of the SfDataGrid.
DataGridExcelExportOptions	excelExportOptions	An instance of the DataGridExcelExportOptions class, used to customize the Excel export process.
IWorksheet	worksheet	The worksheet to which the data will be exported.

ExportToExcel(SfDataGrid, ObservableCollection<Object>, DataGridExcelExportOptions)

Declaration

public static ExcelEngine ExportToExcel(this SfDataGrid dataGrid, ObservableCollection<object> rows, DataGridExcelExportOptions excelExportOptions)

Parameters

Type	Name	Description
SfDataGrid	dataGrid
System.Collections.ObjectModel.ObservableCollection<System.Object>	rows
DataGridExcelExportOptions	excelExportOptions

Returns

Type
ExcelEngine

ExportToExcel(SfDataGrid, ObservableCollection<Object>, DataGridExcelExportOptions, IWorksheet)

Declaration

public static void ExportToExcel(this SfDataGrid dataGrid, ObservableCollection<object> rows, DataGridExcelExportOptions excelExportOptions, IWorksheet worksheet)

Parameters

Type	Name	Description
SfDataGrid	dataGrid
System.Collections.ObjectModel.ObservableCollection<System.Object>	rows
DataGridExcelExportOptions	excelExportOptions
IWorksheet	worksheet