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
)
Sub AddValueFilter (
type As PivotValueFilterType,
dataField As IPivotDataField,
value1 As Object,
value2 As Object
)
void AddValueFilter(
PivotValueFilterType type,
IPivotDataField^ dataField,
Object^ value1,
Object^ value2
)
abstract AddValueFilter :
type : PivotValueFilterType *
dataField : IPivotDataField *
value1 : Object *
value2 : Object -> unit
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