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
- Define a filter from cell
"A1"
to"0100"
; - Save the
workbook
.
Ratkaisu
sheet.auto_filter.ref = "A1:O100"
workbook.save(filename="hello_world_append.xlsx")
Mark tasks as Completed
Oliko kaikki selvää?
Kiitos palautteestasi!
Osio 1. Luku 8
AVAILABLE TO ULTIMATE ONLY