Spire.XLS API

XlsPivotField HideItemDetail Method (Int32, Boolean)

Sets whether the specific PivotItem in a pivot field is hidden detail. 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(
	int index,
	bool isHiddenDetail
)

Public Sub HideItemDetail ( 
	index As Integer,
	isHiddenDetail As Boolean
)

public:
void HideItemDetail(
	int index, 
	bool isHiddenDetail
)

member HideItemDetail : 
index : int * 
isHiddenDetail : bool -> unit

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

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