Click or drag to resize

ExcelAutoFilterFilterByValues Method

Shows only the rows whose cell in the specified column displays one of the specified values, compared without regard to case. A number or a date is compared by its displayed text, for example "1,250.00". The filter replaces the previous filter of the column; the filters of the other columns are kept. In the Excel 97-2003 format a column can be filtered by at most two values.

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public void FilterByValues(
	int columnIndex,
	string[] values
)

Parameters

columnIndex  Int32
The one based index of the column in the filtered range.
values  String
The values to show. The values cannot be null or empty.
See Also