Working with Excel AutoFilter

Contents
[ ]

AutoFilter is the quickest way to display only the items you need from a worksheet. The AutoFilter feature lets users filter a list based on specified criteria—by text, numbers, or dates.

Different Types of Filters

Aspose.Cells Cloud provides multiple APIs to apply various filter types, such as Color Filter, Date Filter, Number Filter, Text Filter, Blank Filter, and Non‑Blank Filter.

  • Fill Color
    		•

    Aspose.Cells Cloud offers the Add Fill Color Filter API to filter data based on the fill‑color property of cells.
  • Date
    		•

    Various date filters can be applied, such as filtering rows with dates in January 2018. Use the Add Date Filter API to implement this functionality.
  • Dynamic Date
    		•

    Dynamic date filters allow you to filter cells that fall in a specific month regardless of the year (e.g., all January dates). See the Dynamic Filter API.
  • Number
    		•

    The Custom Filters API enables filtering cells whose numeric values fall within a given range.
  • Text
    		•

    If a column contains text, you can select cells containing a specific string using the Add Filter API.
  • Blanks
    		•

    To retrieve rows where a column is blank, use the Match All Blank Cells API.
  • Non‑Blanks
    		•

    To filter rows where a column contains any non‑blank value, use the Match All Non‑Blank Cells API.
  • Custom Filter
    		•

    Aspose.Cells Cloud provides Custom Filters API for advanced scenarios, such as filtering rows that contain a specific substring or that start/end with a particular string.

    AutoFilter Operations