GrapeCity.Documents.Excel.IFilter.Criteria2

Criteria2 Property

Criteria2

Gets the second filter criterion for the specified column in a filtered range.

This value represents the second criterion in a compound filter and is used together with Criteria1 and Operator.

Declaration

object Criteria2 { get; }

ReadOnly Property Criteria2 As Object

Examples

IRange range = worksheet.Range["A1:B5"];
range.Value = new object[,] {
    {"Score", "Name"},
    {60, "A"},
    {75, "B"},
    {90, "C"},
    {95, "D"}
};
range.AutoFilter(0, ">=70", AutoFilterOperator.And, "<=90");
object criteria2 = worksheet.AutoFilter.Filters[0].Criteria2;