title: How can i change filter in excel pivot table with python?
body: <p>Hi i recently created some Excel pivot table in python that has filter for column 'snacks'. How can i set filter to requsted value - 'peanuts'. I tried using pywin32 but i can't find appropraite function or method. Pivot table starts on cell A3 and filter is on A1:B1.</p>
  <pre><code>excel = win32.gencache.EnsureDispatch('Excel.Application')  # excel can be visible or not
      excel.Visible = True  # False
      wb = excel.Workbooks.Open(filename)
      ws = wb.Worksheets(&quot;pivot_table&quot;)
  </code></pre>