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 }