python实现excel数据透视表_Python：在工作表中刷新数据透视表

I'm building a python script that will allow me to open a Excel 2010 worksheet and print it out.

I got most of the way

import win32com.client

office = win32com.client.Dispatch("Excel.Application")

wb = office.Workbooks.Open(r"path\to\excel\file\to\print.xlsm")

count = wb.Sheets.Count

for i in range(count):

ws = wb.Worksheets[i]

pivotCount = ws.PivotTables().Count

for j in range(1, pivotCount+1):

#TODO code to refresh each pivot table

ws.PrintOut()

print "Worksheet: %s - has been sent to the printer" % (ws.Name)

As you can see I'm still missing the refreshing of the pivot tables in the worksheet.

The VBA code for refreshing is:

ActiveSheet.PivotTables(1).PivotCache.Refresh

I can't see