Advertisement
Guest User

Untitled

a guest
Aug 17th, 2021
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.42 KB | None | 0 0
  1. import win32com.client
  2. import shutil
  3.  
  4. def updateSheet(Application, SourcePathName):
  5.     Workbook = Application.Workbooks.open(SourcePathName)
  6.     Workbook.RefreshAll()
  7.     Workbook.Save()
  8.  
  9.  
  10. Application = win32com.client.Dispatch("Excel.Application")
  11. Application.Visible = 1
  12.  
  13. sourcePaths = ["c:/A/1/xls1", "c:/B/1/xls2", "c:/Q/45/xls3"]
  14.  
  15. for i in sourcePaths:
  16.     updateSheet(Application, i)
  17.    
  18. Application.Quit()
  19.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement