Question: You programmatically apply a filter using openpyxl, but when you save and open the workbook, the filter has not taken effect. Why?

Instruction: Choose the option that best answers the question.

You need to use Pandas rather than openpyxl to apply the filter

Filters will only work within Excel, not in Python

The filter data API is currently somewhat buggy, and you need to hit the "Reapply" button in Excel

Filters will only work within Python, not in Excel