可以在工作表中添加過濾器添寺。
注意
過濾器和排序只能由openpyxl配置席吴，但需要在Excel等應(yīng)用程序中應(yīng)用。這是因?yàn)樗鼈儗?shí)際上會對范圍內(nèi)的單元格或行進(jìn)行重排或格式化吃环。
要添加篩選器，需要先定義范圍洋幻，然后添加列和排序條件：
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
data = [
["Fruit", "Quantity"],
["Kiwi", 3],
["Grape", 15],
["Apple", 3],
["Peach", 3],
["Pomegranate", 3],
["Pear", 3],
["Tangerine", 3],
["Blueberry", 3],
["Mango", 3],
["Watermelon", 3],
["Blackberry", 3],
["Orange", 3],
["Raspberry", 3],
["Banana", 3]
]
for r in data:
ws.append(r)
ws.auto_filter.ref = "A1:B15"
ws.auto_filter.add_filter_column(0, ["Kiwi", "Apple", "Mango"])
ws.auto_filter.add_sort_condition("B2:B15")
wb.save("filtered.xlsx")
這會將相關(guān)指令添加到文件中郁轻，但不會實(shí)際過濾或排序。
