Spire.XLS API

XlsPivotField HideItemDetail Method (String, Boolean)

Sets whether the PivotItems in a pivot field is hidden detail.That is collapse/expand this field. 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 HideItemDetail(
	string itemValue,
	bool isHiddenDetail
)

Public Sub HideItemDetail ( 
	itemValue As String,
	isHiddenDetail As Boolean
)

public:
void HideItemDetail(
	String^ itemValue, 
	bool isHiddenDetail
)

member HideItemDetail : 
itemValue : string * 
isHiddenDetail : bool -> unit

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

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