Python: Refresh Pivottables In Worksheet
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('Ex
Solution 1:
I found my problem. I had a protection on the worksheet. Here is the solution:
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]
ws.Unprotect() # IF protected
pivotCount = ws.PivotTables().Count
for j in range(1, pivotCount+1):
ws.PivotTables(j).PivotCache().Refresh()
# Put protection back on
ws.Protect(DrawingObjects=True, Contents=True, Scenarios=True, AllowUsingPivotTables=True)
ws.PrintOut()
print "Worksheet: %s - has been sent to the printer" % (ws.Name)
Post a Comment for "Python: Refresh Pivottables In Worksheet"