Class | Description | |
---|---|---|
AverageFilter | Represents a filter which can filter data based on whether the data is below or above the average of the entire data range. | |
CustomFilter | Represents a filter which can filter data based on one or two custom conditions. | |
CustomFilterCondition | A filter condition used in a CustomFilter. | |
DatePeriodFilter | Represents a filter which can filter dates in a specific period. | |
DateRangeFilter | Abstract base class for filters which filter dates based on whether they are within a specified range of dates or not. | |
DynamicValuesFilter | Abstract base class for all filter types which filter data based on a dynamic condition, such as the data present in the filtered data range, the date when the filter was applied, or the date when the filter is evaluated. | |
FillFilter | Represents a filter which will filter cells based on their background fills. | |
Filter | Abstract base class for all filters which filters cells in a worksheet. | |
FixedDateGroup | Represents a fixed range of dates. | |
FixedDateGroupCollection | A collection of fixed date groups. | |
FixedValuesFilter | Represents a filter which can filter cells based on specific, fixed values, which are allowed to display. | |
FontColorFilter | Represents a filter which will filter cells based on their font colors. | |
IconFilter | Represents a filter which can filter cells based on their conditional formatting icon. | |
RelativeDateRangeFilter | Represents a filter which can filter date cells based on dates relative to the when the filter was applied. | |
TopOrBottomFilter | Represents a filter which can filter in cells in the upper or lower portion of the sorted values. | |
WorksheetFilterSettings | Exposes methods to identify a region in the wroksheet and to apply filters and optionally sort criteria to that region. | |
YearToDateFilter | Represents a filter which can filter in date cells if the dates occur between the start of the current year and the time when the filter is evaluated. |
Enumeration | Description | |
---|---|---|
AverageFilterType | Represents the various types of the AverageFilter. | |
CalendarType | Represents the various calendar types available for the FixedValuesFilter | |
ConditionalOperator | Represents the various logical operators used to combine the conditions of the CustomFilter. | |
DatePeriodFilterType | Represents the various date range types which can be filtered by the DatePeriodFilter. | |
ExcelComparisonOperator | Represents the various comparisons which can be used in the CustomFilterCondition. | |
FixedDateGroupType | Represents the various types, or precisions, of a FixedDateGroup. | |
RelativeDateRangeDuration | Represents the various durations which can be filtered by the RelativeDateRangeFilter. | |
RelativeDateRangeOffset | Represents the various relative date offsets which can be filtered by the RelativeDateRangeFilter. | |
TopOrBottomFilterType | Represents the various filter types available for the TopOrBottomFilter. |