Partager via


PivotFilter.FilterType Property

Specifies the type of filter to be applied. Read-only.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
ReadOnly Property FilterType As XlPivotFilterType
    Get
'Usage
Dim instance As PivotFilter
Dim value As XlPivotFilterType

value = instance.FilterType
XlPivotFilterType FilterType { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.XlPivotFilterType
XlPivotFilterType

Remarks

The following table shows the filter types that can be added to a PivotField. Arguments that must be supplied to the Add method for that filter type are marked “Required”, and those that cannot be supplied are marked “Unavailable”.

TypexlPivotFilterType

Data FieldPivotField

DataField(OLAPCubeField

Value1

Value2

xlPivotFilterType

xlTopCount

xlBottomCount

xlTopPercent

xlBottomPercent

xlTopSum

xlBottomSum

xlCaptionEquals

xlCaptionDoesNotEqual

xlCaptionIsGreaterThan

xlCaptionIsGreaterThanOrEqualTo

xlCaptionIsLessThan

xlCaptionIsLessThanOrEqualTo

xlCaptionBeginsWith

xlCaptionDoesNotBeginWith

xlCaptionEndsWith

xlCaptionDoesNotEndWith

xlCaptionContains

xlCaptionDoesNotContain

xlCaptionIsBetween

xlCaptionIsNotBetween

xlValueEquals

xlValueDoesNotEqual

xlValueIsGreaterThan

xlValueIsGreaterThanOrEqualTo

xlValueIsLessThan

xlValueIsLessThanOrEqualTo

xlValueIsBetween

xlValueIsNotBetween

xlSpecificDate

xlNotSpecificDate

xlBefore

xlBeforeOrEqualTo

xlAfter

xlAfterOrEqualTo

xlBetween

xlNotBetween

xlFilterToday

xlFilterYesterday

xlFilterTomorrow

xlFilterThisWeek

xlFilterLastWeek

xlFilterNextWeek

xlFilterThisMonth

xlFilterLastMonth

xlFilterNextMonth

xlFilterThisQuarter

xlFilterLastQuarter

xlFilterNextQuarter

xlFilterThisYear

xlFilterLastYear

xlFilterNextYear

xlFilterYearToDate

xlFilterAllDatesInPeriodQuarter1

xlFilterAllDatesInPeriodQuarter2

xlFilterAllDatesInPeriodQuarter3

xlFilterAllDatesInPeriodQuarter4

xlFilterAllDatesInPeriodJanuary

xlFilterAllDatesInPeriodFebruary

xlFilterAllDatesInPeriodMarch

xlFilterAllDatesInPeriodApril

xlFilterAllDatesInPeriodMay

xlFilterAllDatesInPeriodJune

xlFilterAllDatesInPeriodJuly

xlFilterAllDatesInPeriodAugust

xlFilterAllDatesInPeriodSeptember

xlFilterAllDatesInPeriodOctober

xlFilterAllDatesInPeriodNovember

xlFilterAllDatesInPeriodDecember

See Also

Reference

PivotFilter Interface

PivotFilter Members

Microsoft.Office.Interop.Excel Namespace