static void SetItemVisibilityFilter(IWorkbook workbook)
{
#region #Item Visibility
Worksheet worksheet = workbook.Worksheets["Report4"];
workbook.Worksheets.ActiveWorksheet = worksheet;
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
PivotItemCollection pivotFieldItems = pivotTable.Fields[1].Items;
pivotFieldItems[0].Visible = false;
#endregion #Item Visibility
}
static void SetItemVisibilityFilter(IWorkbook workbook)
{
#region #ItemVisibility
Worksheet worksheet = workbook.Worksheets["Report4"];
workbook.Worksheets.ActiveWorksheet = worksheet;
// Access the pivot table by its name in the collection.
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
// Access items of the "Product" field.
PivotItemCollection pivotFieldItems = pivotTable.Fields[1].Items;
// Hide the first item in the "Product" field.
pivotFieldItems[0].Visible = false;
#endregion #ItemVisibility
}
