Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
course content

Course Content

Excel: the Power of Openpyxl

FiltersFilters

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() method takes parameters specifying the starting and ending cells 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.

Task

  1. Define a filter from cell "A1" to "0100";
  2. Save the workbook.

Mark tasks as Completed

Everything was clear?

Section 1. Chapter 8
AVAILABLE TO ULTIMATE ONLY
some-alt