Class DataGridExcelExportExtensions

Provides the extensions for exporting SfDataGrid into Excel.

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)

Exports the dataGrid to Excel by considering Grouping,Sorting,Filtering,Summaries,Paging,NestedGrid,CellTypes,Unbound rows, Merged cells and Stacked headers.

Declaration

public static ExcelEngine ExportToExcel(this SfDataGrid grid, ICollectionViewAdv gridCollectionView, DataGridExcelExportOptions excelExportOptions)

Parameters

Type	Name	Description
SfDataGrid	grid	Specifies the SfDataGrid.
ICollectionViewAdv	gridCollectionView	Specifies SfDataGrid view.
DataGridExcelExportOptions	excelExportOptions	Specifies the instance of class DataGridExcelExportOptions

Returns

Type	Description
ExcelEngine	Returns the ExcelEngine.

ExportToExcel(SfDataGrid, ICollectionViewAdv, DataGridExcelExportOptions, IWorksheet)

Exports the dataGrid to Excel.

Declaration

public static void ExportToExcel(this SfDataGrid grid, ICollectionViewAdv gridCollectionView, DataGridExcelExportOptions excelExportOptions, IWorksheet sheet)

Parameters

Type	Name	Description
SfDataGrid	grid	Specifies the SfDataGrid.
ICollectionViewAdv	gridCollectionView	Specifies the SfDataGrid view
DataGridExcelExportOptions	excelExportOptions	Specifies the instance of class DataGridExcelExportOptions
IWorksheet	sheet	Specifies the exported work sheet.

ExportToExcel(SfDataGrid, ObservableCollection<Object>, DataGridExcelExportOptions)

Export Selected items to Excel.

Declaration

public static ExcelEngine ExportToExcel(this SfDataGrid grid, ObservableCollection<object> selectedRows, DataGridExcelExportOptions excelExportOptions)

Parameters

Type	Name	Description
SfDataGrid	grid	Specifies the SfDataGrid.
System.Collections.ObjectModel.ObservableCollection<System.Object>	selectedRows	Specifies the Selected Items.
DataGridExcelExportOptions	excelExportOptions	Specifies the instance of class DataGridExcelExportOptions

Returns

Type	Description
ExcelEngine	Returns the instance of class ExcelEngine.

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

Export Selected items to Excel.

Declaration

public static void ExportToExcel(this SfDataGrid grid, ObservableCollection<object> selectedRows, DataGridExcelExportOptions excelExportOptions, IWorksheet sheet)

Parameters

Type	Name	Description
SfDataGrid	grid	Specifies the SfDataGrid.
System.Collections.ObjectModel.ObservableCollection<System.Object>	selectedRows	Specifies the Selected Items.
DataGridExcelExportOptions	excelExportOptions	Specifies the instance of class DataGridExcelExportOptions
IWorksheet	sheet	Specifies the Worksheet.