Click or drag to resize

IPivotField AddValueFilter Method

Add value filter for pivot field, only for row and column field.

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
void AddValueFilter(
	PivotValueFilterType type,
	IPivotDataField dataField,
	Object value1,
	Object value2
)

Parameters

type
Type: Spire.Xls PivotValueFilterType
Filter type.
dataField
Type: Spire.Xls.Core IPivotDataField
Filter data field.
value1
Type: System Object
First filter value.
value2
Type: System Object
Second filter value, only for Between and NotBetween type.
See Also