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.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic void FilterByValues(
int columnIndex,
string[] values
)
Public Sub FilterByValues (
columnIndex As Integer,
values As String()
)
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