Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Oppiskele Filters | Excel Automation with Python (project)
Excel Automation with Python (project)

book
Filters

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 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.

Tehtävä

Swipe to start coding

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

Ratkaisu

sheet.auto_filter.ref = "A1:O100"

workbook.save(filename="hello_world_append.xlsx")

Mark tasks as Completed
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 1. Luku 8
AVAILABLE TO ULTIMATE ONLY
some-alt