The following tables list the members exposed by WorksheetFilterSettings.
| Name | Description | |
|---|---|---|
 | Region | Returns the total region including the filter headers (read-only). |
| SortAndFilterAreaRegion | Returns the region that the filters and sort settings are applied to (read-only). |
| SortSettings | Gets the settings which determine how the data within the worksheet's filer region should be sorted. |
| Name | Description | |
|---|---|---|
 | ApplyAverageFilter | Applies an AverageFilter to the column. |
| ApplyCustomFilter | Overloaded. Applies a CustomFilter to the column. |
| ApplyDatePeriodFilter | Applies an DatePeriodFilter to the column. |
| ApplyFillFilter | Applies a FillFilter to the column. |
| ApplyFixedValuesFilter | Overloaded. Applies a FixedValuesFilter to the column. |
| ApplyFontColorFilter | Overloaded. Applies a FontColorFilter to the column. |
| ApplyIconFilter | Applies a IconFilter to the column. |
| ApplyRelativeDateRangeFilter | Applies a RelativeDateRangeFilter to the column. |
| ApplyTopOrBottomFilter | Overloaded. Applies a TopOrBottomFilter to the column which will filter in the top 10 values in the list of sorted values. |
| ApplyYearToDateFilter | Applies a YearToDateFilter to the column. |
| ClearFilter | Clears the filter that is applied to a specific column. |
| ClearFilters | Clears all previously applied filters |
| ClearRegion | Clears the region as well as any existing filters and sort criteria |
| GetFilter | Gets the filter that is applied to a specific column. |
| ReapplyFilters | Re-filters all data cells in the filter region based on the applied filters. |
| ReapplySortConditions | Re-sorts all data cells in the region based on the sort conditions. |
| SetRegion | Overloaded. Sets the region where the filter settings should be applied |
View on GitHub