Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære Filters | Openpyxl
Excel Automation with Python (project)
course content

Kursusindhold

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.

Opgave

Swipe to start coding

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

Løsning

Mark tasks as Completed
Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 1. Kapitel 8

Spørg AI

expand
ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

course content

Kursusindhold

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.

Opgave

Swipe to start coding

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

Løsning

Mark tasks as Completed
Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 1. Kapitel 8
Vi beklager, at noget gik galt. Hvad skete der?
some-alt