編輯

共用方式為


XlDynamicFilterCriteria Enum

Definition

Specifies the filter criterion.

public enum class XlDynamicFilterCriteria
public enum XlDynamicFilterCriteria
Public Enum XlDynamicFilterCriteria
Inheritance
XlDynamicFilterCriteria

Fields

Name Value Description
xlFilterToday 1

Filter all values related to the current date.

xlFilterYesterday 2

Filter all values related to yesterday.

xlFilterTomorrow 3

Filter all values related to tomorrow.

xlFilterThisWeek 4

Filter all values related to the current week.

xlFilterLastWeek 5

Filter all values related to last week.

xlFilterNextWeek 6

Filter all values related to next week.

xlFilterThisMonth 7

Filter all values related to the current month.

xlFilterLastMonth 8

Filter all values related to last month.

xlFilterNextMonth 9

Filter all values related to next month.

xlFilterThisQuarter 10

Filter all values related to the current quarter.

xlFilterLastQuarter 11

Filter all values related to last quarter.

xlFilterNextQuarter 12

Filter all values related to next quarter.

xlFilterThisYear 13

Filter all values related to the current year.

xlFilterLastYear 14

Filter all values related to last year.

xlFilterNextYear 15

Filter all values related to next year.

xlFilterYearToDate 16

Filter all values from today until a year ago.

xlFilterAllDatesInPeriodQuarter1 17

Filter all dates in Quarter1.

xlFilterAllDatesInPeriodQuarter2 18

Filter all dates in Quarter2.

xlFilterAllDatesInPeriodQuarter3 19

Filter all dates in Quarter3.

xlFilterAllDatesInPeriodQuarter4 20

Filter all dates in Quarter4.

xlFilterAllDatesInPeriodJanuary 21

Filter all dates in January.

xlFilterAllDatesInPeriodFebruray 22

Filter all dates in February.

xlFilterAllDatesInPeriodMarch 23

Filter all dates in March.

xlFilterAllDatesInPeriodApril 24

Filter all dates in April.

xlFilterAllDatesInPeriodMay 25

Filter all dates in May.

xlFilterAllDatesInPeriodJune 26

Filter all dates in June.

xlFilterAllDatesInPeriodJuly 27

Filter all dates in July.

xlFilterAllDatesInPeriodAugust 28

Filter all dates in August.

xlFilterAllDatesInPeriodSeptember 29

Filter all dates in September.

xlFilterAllDatesInPeriodOctober 30

Filter all dates in October.

xlFilterAllDatesInPeriodNovember 31

Filter all dates in November.

xlFilterAllDatesInPeriodDecember 32

Filter all dates in December.

xlFilterAboveAverage 33

Filter all above-average values.

xlFilterBelowAverage 34

Filter all below-average values.

Applies to