Class DataGridExcelExportExtensions
Provides the extensions for exporting SfDataGrid into Excel.
Inheritance
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. |