Summary  
This chapter covers how to apply filters to a range of cells using the openpyxl library, specifically using the auto_filter() and auto_filter.ref() methods to define the cell range and filter criteria.

General domain of usage  
Spreadsheet automation and data analysis

`auto_filter()` is a method provided by the **openpyxl** library in Python that allows you to create a filter on a range of cells in a worksheet. The `auto_filter.ref()` method takes parameters specifying the <u>starting and ending cells</u> of the range and the criteria for the filter, such as a range of values or a text string.

Now, you know how to specifie the area where the filter should be applied.

In this project, we will study how to create, modify, and extract data from Excel spreadsheets using Python code.

Excel Automation with Python (project)

Filters

Рішення