Namespace EasyXLS

Class 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 getCopyTo()
      Returns the range where the matching rows of the criteria will be copied.
      System.String getCriteriaRange()
      Returns the criteria range.
      System.String getListRange()
      Returns the list range.
      bool IsAutoFilter()
      Returns true if the auto-filter is applied, false otherwise.
      void removeFilter()
      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.
      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.