PivotField.ClearLabelFilters 方法
定义
重要
一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。 对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。
此方法删除 集合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 |