PivotField.ClearLabelFilters 方法

  • 参考

定义

命名空间:
Microsoft.Office.Interop.Excel
程序集:
Microsoft.Office.Interop.Excel.dll

此方法删除 集合PivotField中的所有PivotFilters标签筛选器或所有日期筛选器。

public:
 void ClearLabelFilters();
public void ClearLabelFilters ();
Public Sub ClearLabelFilters ()

注解

下表列出了此方法将删除的各种标签筛选类型。

xlCaptionEquals
xlCaptionDoesNotEqual
xlCaptionIsGreaterThan
xlCaptionIsGreaterThanOrEqualTo
xlCaptionIsLessThan
xlCaptionIsLessThanOrEqualTo
xlCaptionBeginsWith
xlCaptionDoesNotBeginWith
xlCaptionEndsWith
xlCaptionDoesNotEndWith
xlCaptionContains
xlCaptionDoesNotContain
xlCaptionIsBetween
xlCaptionIsNotBetween

下表列出了此方法将删除的各种日期筛选类型。

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

适用于