ExcelAutoFilterFilterByCondition Method |
Shows only the rows whose cell in the specified column meets a condition, for example greater than 100.
The filter replaces the previous filter of the column; the filters of the other columns are kept.
Namespace: ExpertXls.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic void FilterByCondition(
int columnIndex,
ExcelAutoFilterOperator comparisonOperator,
Object value
)
Public Sub FilterByCondition (
columnIndex As Integer,
comparisonOperator As ExcelAutoFilterOperator,
value As Object
)
Parameters
- columnIndex Int32
- The one based index of the column in the filtered range.
- comparisonOperator ExcelAutoFilterOperator
- The comparison operator.
- value Object
- The value to compare with: a number (int, double, decimal ...) is compared with the
numbers of the column, any other value is compared as text, without regard to case.
See Also