Skip to main content
A newer version of this page is available. .

XlValuesFilter Members

A filter by a list of cell values or date and time values.

Constructors

Name Description
XlValuesFilter() Initializes a new instance of the XlValuesFilter class with the default settings.

Properties

Name Description
CalendarType Gets or sets the calendar type for date groups used in filtering.
DateGroups Provides access to the collection of date and time values to filter by.
FilterByBlank Gets or sets a value indicating whether blank cells should be included in the filtering results.
FilterType Returns the XlFilterType.Values value that is the current filter’s type.
Values Provides access to the collection of cell values to filter by.

Methods

Name Description
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also