GrapeCity.Documents.Excel.IFilter.Criteria1

Criteria1 Property

Criteria1

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

This value corresponds to the first criterion applied to the filter for the column.

Declaration

object Criteria1 { get; }

ReadOnly Property Criteria1 As Object

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Region", "Value"},
    {"East", 100},
    {"West", 200},
    {"East", 300}
};
worksheet.Range["A1:B4"].AutoFilter(0, "East");
IFilter filter = worksheet.AutoFilter.Filters[0];
object criteria1 = filter.Criteria1;