How to disable autofilter in openpyxl tables?

Question

When I create a table using openpyxl, it adds an auto filter by default on all columns. The behavior is reproducible using the example provided in the documentation. I would like to display the tables without the auto filter.

This behavior is controlled by the autoFilter parameter in the class openpyxl.worksheet.table.Table. I have tried setting it to None, as well as different values for the filterColumn parameter in the class openpyxl.worksheet.filters.AutoFilter however, nothing seems to work.

Has anyone been able to disable the auto filter?

user_9344053 · Answer

This did the trick for me:

ws2.auto_filter.add_sort_condition(None)

ws2 is the name of of my worksheet, I hope this helps.

user_16925580 · Answer

refer. https://stackoverflow.com/a/66377091

workbook.save('table.xlsx')  # 1st time

table.autoFilter = None    

workbook.save('table.xlsx')  # 2nd time

How to disable autofilter in openpyxl tables?

2 Answers