Click or drag to resize

XlsPivotField HideItem Method (Int32, Boolean)

Sets whether the specific PivotItem in a data field is hidden. Must call after pivottable CalculateData function.

Namespace: Spire.Xls.Core.Spreadsheet.PivotTables
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public void HideItem(
	int index,
	bool isHidden
)

Parameters

index
Type: System Int32
the index of the pivotItem in the pivotField.
isHidden
Type: System Boolean
whether the specific PivotItem is hidden
See Also