Document Solutions for Excel, .NET Edition | Document Solutions
GrapeCity.Documents.Excel Namespace / IRange Interface / AutoFilter Method
Optional Object. The integer offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field zero).
Optional 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").
Optional AutoFilterOperator
Optional Object. The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.
Optional 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.
In This Topic
    AutoFilter Method
    In This Topic
    Filters a list using the AutoFilter.
    Syntax
    void AutoFilter( 
       System.int field,
       System.object criteria1,
       AutoFilterOperator op,
       System.object criteria2,
       System.bool visibleDropDown
    )

    Parameters

    field
    Optional Object. The integer offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field zero).
    criteria1
    Optional 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").
    op
    Optional AutoFilterOperator
    criteria2
    Optional Object. The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.
    visibleDropDown
    Optional 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.
    See Also