XlsPivotField
AddValueFilter Method
|
Add value filter for pivot field, only for row and column field.
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 AddValueFilter(
PivotValueFilterType type,
IPivotDataField dataField,
Object value1,
Object value2
)
Public Sub AddValueFilter (
type As PivotValueFilterType,
dataField As IPivotDataField,
value1 As Object,
value2 As Object
)
public:
virtual void AddValueFilter(
PivotValueFilterType type,
IPivotDataField^ dataField,
Object^ value1,
Object^ value2
) sealed
abstract AddValueFilter :
type : PivotValueFilterType *
dataField : IPivotDataField *
value1 : Object *
value2 : Object -> unit
override 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.
Implements
IPivotField
AddValueFilter(PivotValueFilterType, IPivotDataField, Object, Object)
See Also