DS.Documents.Excel Assembly

GrapeCity.Documents.Excel.IPivotFilters.Add

Add Method

Add(PivotFilterType, object, object, PivotFilterOptions)

Adds a new filter to the PivotFilters collection.

Declaration

IPivotFilter Add(PivotFilterType type, object value1 = null, object value2 = null, PivotFilterOptions options = null)

Function Add(type As PivotFilterType, Optional value1 As Object = Nothing, Optional value2 As Object = Nothing, Optional options As PivotFilterOptions = Nothing) As IPivotFilter

Parameters

Type	Name	Description
PivotFilterType	type	The type of filter.
object	value1	The first value for the filter (optional).
object	value2	The second value for the filter (optional).
PivotFilterOptions	options	Additional settings for the filter (optional).

Returns

Type	Description
IPivotFilter	The added pivot filter.