add_filter method

add_filter

Adds a filter for a filter column.

def add_filter(self, field_index, criteria):
    ...

Parameter	Type	Description
field_index	int	The integer offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field 0).
criteria	str	The specified criteria (a string; for example, “101”). It only can be null or be one of the cells’ value in this column.

MS Excel 2007 supports multiple selection in a filter column.