Namespace EasyXLS

Class ExcelFilter

System.Object
EasyXLS.ExcelFilter

public class ExcelFilter extends System.Object
This class stores the auto-filter and advanced filter information.
  • Method Summary

    Modifier and Type
    Method
    Description
    System.String
    Returns the range where the matching rows of the criteria will be copied.
    System.String
    Returns the criteria range.
    System.String
    Returns the list range.
    bool
    Returns true if the auto-filter is applied, false otherwise.
    void
    Removes the filter.
    void
    setAdvancedFilter​(System.String listRange, System.String criteriaRange, System.String copyTo)
    Sets the advanced filter.
    void
    setAutoFilter​(bool isAutoFilter)
    Set if the auto-filter is applied.
    void
    setAutoFilter​(System.String listRange)
    Sets the list range where the auto-filter is applied.
    This method is overridden as setAutoFilter_2 in COM+ version of EasyXLS.
    void
    setCopyTo​(System.String copyTo)
    Sets the range where the matching rows of the criteria will be copied.
    void
    setCriteriaRange​(System.String criteriaRange)
    Sets the criteria range.
    void
    setListRange​(System.String listRange)
    Sets the list range.

    Methods inherited from class System.Object

    equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait