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. |