Free Support Forum - aspose.com

Removing all filters from worksheet

Is there a way to detect and remove all filters from a worksheet?

This code produces the error: “Range of AutoFilter is not set.”

If Not sheet.AutoFilter.Range = “” Then
sheet.AutoFilter.Range = “”
End If

Hi,

We will soon provide the feature for removing autofilters in the designer excel file.

Thank you.

Hi,

Please try this fix.

Is this fix for 1.0 or 2.0?

Hi,

The fix is compiled on .Net 1.x and will also work on .Net 2.0, .Net 3.x etc.

Thank you.