XmlMappedRange.AutoFilter Method
Filters a list using the AutoFilter.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Function AutoFilter ( _
Field As Object, _
Criteria1 As Object, _
Operator As XlAutoFilterOperator, _
Criteria2 As Object, _
VisibleDropDown As Object _
) As Object
Object AutoFilter(
Object Field,
Object Criteria1,
XlAutoFilterOperator Operator,
Object Criteria2,
Object VisibleDropDown
)
Parameters
- Field
Type: System.Object
The offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field 1 (one)).
- Criteria1
Type: System.Object
The criteria (a string; for example, "101"). Use "=" to find blank fields, or use "<>" to find nonblank fields. If this argument is omitted, the criteria is All. If Operator is xlTop10Items, Criteria1 specifies the number of items (for example, "10").
- Operator
Type: Microsoft.Office.Interop.Excel.XlAutoFilterOperator
Can be one of the following XlAutoFilterOperator constants:
xlAnd
xlBottom10Items
xlBottom10Percent
xlOr
xlTop10Items
xlTop10Percent
Use xlAnd and xlOr with Criteria1 and Criteria2 to construct compound criteria.
- Criteria2
Type: System.Object
The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.
- VisibleDropDown
Type: System.Object
true to display the AutoFilter drop-down arrow for the filtered field; false to hide the AutoFilter drop-down arrow for the filtered field. true by default.
Return Value
Type: System.Object
Remarks
If you omit all the arguments, this method simply toggles the display of the AutoFilter drop-down arrows in the XmlMappedRange control.
Optional Parameters
For information on optional parameters, see Optional Parameters in Office Solutions.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.