xxxxxxxxxx
#to refresh something in excel using python u need to install 'pywin32' in order to use
#'win32com' module and the 'win32com.client' library
#first u import the library
import win32com.client
#then open your excel
excel = win32com.client.Dispatch("Excel.Application")
workbook = excel.Workbooks.Open("C:\\path\\to\\spreadsheet.xlsx")
#then you can refresh it like this
workbook.RefreshAll()
#save it by doing this
workbook.Save()
#then close it by doing this
excel.Application.Quit()
#hope this helps