Class
ExcelAutoFilter
OfficeIMO.Excel
An AutoFilter attached to a worksheet range or its table.
Inheritance
- object
- ExcelAutoFilter
Remarks
Get it from ExcelRange.AutoFilter; set criteria per column with ExcelAutoFilter.Column.
Usage
Explore 15 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 15
- Method ExcelAutoFilterColumn.BeginsWith
- Method ExcelAutoFilterColumn.Between
- Method ExcelAutoFilterColumn.Blanks
- Method ExcelAutoFilterColumn.Clear
- Method ExcelAutoFilterColumn.Contains
- Method ExcelAutoFilterColumn.DoesNotContain
- Method ExcelAutoFilterColumn.EndsWith
- Method ExcelAutoFilterColumn.Equals
- Method ExcelAutoFilterColumn.GreaterThanOrEqual
- Method ExcelAutoFilterColumn.LessThanOrEqual
- Method ExcelAutoFilterColumn.NotBetween
- Method ExcelAutoFilterColumn.NotEqual
- Method ExcelAutoFilterColumn.TopBottom
- Property ExcelAutoFilterColumn.Filter
- Method ExcelRange.AutoFilter
Methods
public bool Clear() #Removes the AutoFilter, including its criteria. Returns false when no filter covers the range.
Returns
boolColumn 2 overloads
public ExcelAutoFilterColumn Column(string header) #Selects the column whose header, in the first row of the filter range, matches header.
Parameters
- header string
Returns
ExcelAutoFilterColumnExceptions
ArgumentException– No header in the first row of the range matches.
public ExcelAutoFilterColumn Column(uint columnOffset) #Selects a column by its zero-based offset inside the filter range.
Parameters
- columnOffset uint
Returns
ExcelAutoFilterColumnExceptions
ArgumentOutOfRangeException– The offset is outside the filter range.
public ExcelAutoFilterInfo? Inspect() #Reads current criteria and table ownership; returns null after the range's filter is removed.
Returns
ExcelAutoFilterInfo?