ExcelAutoFilterColumn
OfficeIMO.Excel
One column of an ExcelAutoFilter. Each criterion replaces the column's previous criterion.
Inheritance
- object
- ExcelAutoFilterColumn
Usage
Explore 1 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 1
- Method ExcelAutoFilter.Column
Methods
public ExcelAutoFilter BeginsWith(string text) #Shows rows whose text begins with text.
Parameters
- text string
Returns
ExcelAutoFilterpublic ExcelAutoFilter Between(double minimumInclusive, double maximumInclusive) #Shows rows whose number lies between the inclusive bounds.
Parameters
- minimumInclusive double
- maximumInclusive double
Returns
ExcelAutoFilterpublic ExcelAutoFilter Blanks() #Shows only rows whose cell in this column is blank.
Returns
ExcelAutoFilterpublic ExcelAutoFilter Clear() #Removes this column's criterion; the filter stays.
Returns
ExcelAutoFilterpublic ExcelAutoFilter Contains(string text) #Shows rows whose text contains text.
Parameters
- text string
Returns
ExcelAutoFilterpublic ExcelAutoFilter DoesNotContain(string text) #Shows rows whose text does not contain text.
Parameters
- text string
Returns
ExcelAutoFilterpublic ExcelAutoFilter EndsWith(string text) #Shows rows whose text ends with text.
Parameters
- text string
Returns
ExcelAutoFilterpublic ExcelAutoFilter Equals(params string[] values) #Shows rows whose value equals one of values (case-insensitive, duplicates ignored).
Parameters
- values string[]
Returns
ExcelAutoFilterpublic ExcelAutoFilter Equals(IEnumerable<string> values) #Shows rows whose value equals one of values (case-insensitive, duplicates ignored).
Parameters
- values System.Collections.Generic.IEnumerable<string>
Returns
ExcelAutoFilterpublic ExcelAutoFilter GreaterThanOrEqual(double value) #Shows rows whose number is at least value.
Parameters
- value double
Returns
ExcelAutoFilterpublic ExcelAutoFilter LessThanOrEqual(double value) #Shows rows whose number is at most value.
Parameters
- value double
Returns
ExcelAutoFilterpublic ExcelAutoFilter NotBetween(double minimumExclusive, double maximumExclusive) #Shows rows whose number lies below minimumExclusive or above maximumExclusive.
Parameters
- minimumExclusive double
- maximumExclusive double
Returns
ExcelAutoFilterpublic ExcelAutoFilter NotEqual(double value) #Shows rows whose number differs from value.
Parameters
- value double
Returns
ExcelAutoFilterpublic ExcelAutoFilter TopBottom(ushort value, bool bottom = false, bool percent = false) #Shows the top or bottom value items, or percent with percent.
Parameters
- value ushort
- Item count (1-500) or percentage (1-100).
- bottom bool = false
- True for the lowest values; false for the highest.
- percent bool = false
- Whether value is a percentage.
Returns
ExcelAutoFilterInherited Methods
Properties
public uint Offset { get; } #Gets the zero-based column offset inside the filter range.