GrapeCity.Documents.Excel.IPivotFilter.Value2

Value2 Property

Value2

Gets the second filter value.

This value is used by pivot filters that require two criteria, such as between filters.

Declaration

object Value2 { get; }

ReadOnly Property Value2 As Object

Examples

worksheet.Range["A1:F5"].Value = new object[,] {
    {"Order ID", "Product", "Category", "Amount", "Date", "Country"},
    {1, "Apple", "Fruit", 100, 1, "US"},
    {2, "Banana", "Fruit", 200, 2, "US"},
    {3, "Carrot", "Vegetable", 300, 3, "US"},
    {4, "Date", "Fruit", 400, 4, "US"}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:F5"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["H1"]);
IPivotFilter filter = pivotTable.PivotFields["Product"].PivotFilters
    .Add(PivotFilterType.CaptionBetween, "Apple", "Carrot");
object value2 = filter.Value2;