How to clear filters in Excel using xlwings?

Question

My team are xlwings in Sypder (Python) to convert Excel tables into CSV format. When a table is filtered however, this alters the CSV output. Is there an xlwings command which can clear the filter from the active Excel sheet?

A similar command in VBA would be (from Excel 2013 VBA Clear All Filters macro):

Sub Macro1()
    Cells.AutoFilter
End Sub

Answer 1

wb.sheets[sheetname].api.AutoFilterMode = False Will remove the filter from the sheet, if you want to just clear the filter showing all the data without removing it you can use: wb.sheets[sheetname].api.AutoFilter.ShowAllData()