WinUI

Code Examples Upgrade Guide User Guide Demos Support Forums Download
  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class DataGridExcelExportExtensions

    Show / Hide Table of Contents

    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.

    Back to top Generated by DocFX
    Copyright © 2001 - 2023 Syncfusion Inc. All Rights Reserved