Share via


PivotField.ClearLabelFilters Method

This method deletes all label filters or all date filters in the PivotFilters collection of the PivotField.

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

Syntax

'Declaration
Sub ClearLabelFilters
'Usage
Dim instance As PivotField

instance.ClearLabelFilters()
void ClearLabelFilters()

Remarks

The following table lists the different label filter types that will be deleted by this method.

xlCaptionEquals

xlCaptionDoesNotEqual

xlCaptionIsGreaterThan

xlCaptionIsGreaterThanOrEqualTo

xlCaptionIsLessThan

xlCaptionIsLessThanOrEqualTo

xlCaptionBeginsWith

xlCaptionDoesNotBeginWith

xlCaptionEndsWith

xlCaptionDoesNotEndWith

xlCaptionContains

xlCaptionDoesNotContain

xlCaptionIsBetween

xlCaptionIsNotBetween

The following table lists the different date filter types that will be deleted by this method.

xlSpecificDate

xlNotSpecificDate

xlBefore

xlBeforeOrEqualTo

xlAfter

xlAfterOrEqualTo

xlDateBetween

xlDateNotBetween

xlDateToday

xlDateYesterday

xlDateTomorrow

xlDateThisWeek

xlDateLastWeek

xlDateNextWeek

xlDateThisMonth

xlDateLastMonth

xlDateNextMonth

xlDateThisQuarter

xlDateLastQuarter

xlDateNextQuarter

xlDateThisYear

xlDateLastYear

xlDateNextYear

xlYearToDate

xlAllDatesInPeriodQuarter1

xlAllDatesInPeriodQuarter2

xlAllDatesInPeriodQuarter3

xlAllDatesInPeriodQuarter4

xlAllDatesInPeriodJanuary

xlAllDatesInPeriodFebruary

xlAllDatesInPeriodMarch

xlAllDatesInPeriodApril

xlAllDatesInPeriodMay

xlAllDatesInPeriodJune

xlAllDatesInPeriodJuly

xlAllDatesInPeriodAugust

xlAllDatesInPeriodSeptember

xlAllDatesInPeriodOctober

xlAllDatesInPeriodNovember

xlAllDatesInPeriodDecember

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace