TimePeriodType Enumeration |
Used in a FormatConditionType.TimePeriod conditional formatting rule.
These are dynamic time periods, which change based on
the date the conditional formatting is refreshed / applied.
Namespace: Spire.Xls.Core.Spreadsheet.ConditionalFormatting
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Members
| Member name | Value | Description | |
|---|---|---|---|
| Today | 0 | Today's date. | |
| Yesterday | 1 | Yesterday's date. | |
| Tomorrow | 2 | Tomorrow's date. | |
| Last7Days | 3 | A date in the last seven days. | |
| ThisMonth | 4 | A date occuring in this calendar month. | |
| LastMonth | 5 | A date occuring in the last calendar month. | |
| NextMonth | 6 | A date occuring in the next calendar month. | |
| ThisWeek | 7 | A date occuring this week. | |
| LastWeek | 8 | A date occuring last week. | |
| NextWeek | 9 | A date occuring next week. |
See Also
