Click or drag to resize

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.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public void FilterByCondition(
	int columnIndex,
	ExcelAutoFilterOperator comparisonOperator,
	Object value
)

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