Worksheet.FilterString

Worksheet.FilterString method

Sets the filter for the column.notice we shall call AddAutoFilter before calling of filterString The filter criteria string. notice we use comma->"," as split char,so the cell value you want to filter shall not contains with comma filterString(10,“123,456”) means column 10 shall contain 123 or 456, filterString(10,“123”) means column10 shall contain 123 value split with comma,eg. 123,456,789 or abc

public void FilterString(int column, string criteria)

See Also