How to clear filter while importing a excel sheet into Spreadsheet?

1 min read

WPF 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;
        }
    }
}

Clear the filter in WPF spreadsheet

Sample: View sample in GitHub

Did you find this information helpful?

Yes

Comments (0)

How to clear filter while importing a excel sheet into Spreadsheet?

Access denied