Spire.XLS API

XlsPivotField HideItem Method (String, 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

public void HideItem(
	string itemValue,
	bool isHidden
)

Public Sub HideItem ( 
	itemValue As String,
	isHidden As Boolean
)

public:
void HideItem(
	String^ itemValue, 
	bool isHidden
)

member HideItem : 
itemValue : string * 
isHidden : bool -> unit

itemValue: Type: System String
the value of the pivotItem in the pivotField.
isHidden: Type: System Boolean
whether the specific PivotItem is hidden

XlsPivotField AddLanguageSpecificTextSet("LSTBC37E135_0?cpp=::|nu=."); HideItem Method (String, Boolean)