AutoFiltersCollection AddFilter Method (Int32, String)

public void AddFilter(
	int columnIndex,
	string criteria
)

Public Sub AddFilter ( 
	columnIndex As Integer,
	criteria As String
)

public:
void AddFilter(
	int columnIndex, 
	String^ criteria
)

member AddFilter : 
columnIndex : int * 
criteria : string -> unit 

Parameters

columnIndex

Type: System Int32
The column field on which you want to base the filter . for exapmle: sheet.AutoFilters[0]

criteria

Type: System String
The specified criteria (a string; for example, "hello"). It only can be null or be one of the cells' value in this column.

Reference