How to Clear Filter While Importing a Excel Sheet into WPF Spreadsheet?

This repository contains the sample which shows the how to clear the filter while importing sheet into WPF Spreadsheet (SfSpreadsheet).

Spreadsheet control loads the Excel workbook with filter’s if the filter applied before by user. You can clear the filter and load Excel workbook without filter by clearing the filter by setting worksheet.AutoFilters.FilterRange property to null in WorkbookLoaded event.

//To clear the filter
spreadsheet.WorkbookLoaded += Spreadsheet_WorkbookLoaded;
 
private void Spreadsheet_WorkbookLoaded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorkbookLoadedEventArgs args)
{
    foreach (var sheet in args.GridCollection)
    {
        if (sheet.Worksheet.AutoFilters.FilterRange != null)
        {
            sheet.Worksheet.AutoFilters.FilterRange = null;
        }
    }
}