IPivotFilters.Add Method
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Add ( _
Type As XlPivotFilterType, _
DataField As Object, _
Value1 As Object, _
Value2 As Object, _
Order As Object, _
Name As Object, _
Description As Object, _
MemberPropertyField As Object _
) As PivotFilter
'Usage
Dim instance As IPivotFilters
Dim Type As XlPivotFilterType
Dim DataField As Object
Dim Value1 As Object
Dim Value2 As Object
Dim Order As Object
Dim Name As Object
Dim Description As Object
Dim MemberPropertyField As Object
Dim returnValue As PivotFilter
returnValue = instance.Add(Type, DataField, _
Value1, Value2, Order, Name, Description, _
MemberPropertyField)
PivotFilter Add(
XlPivotFilterType Type,
Object DataField,
Object Value1,
Object Value2,
Object Order,
Object Name,
Object Description,
Object MemberPropertyField
)
Parameters
- DataField
Type: System.Object
- Value1
Type: System.Object
- Value2
Type: System.Object
- Order
Type: System.Object
- Name
Type: System.Object
- Description
Type: System.Object
- MemberPropertyField
Type: System.Object
Return Value
Type: Microsoft.Office.Interop.Excel.PivotFilter