PivotFilters Property

PivotFilters

Declaration

IPivotFilters PivotFilters { get; }

ReadOnly Property PivotFilters As IPivotFilters

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Product", "Amount"},
    {"Mi Phone", 100},
    {"Camera", 200},
    {"Mi Band", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
IPivotField productField = pivotTable.PivotFields["Product"];
productField.Orientation = PivotFieldOrientation.RowField;
IPivotFilters filters = productField.PivotFilters;
filters.Add(PivotFilterType.CaptionContains, "Mi");