Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import win32com.client
- import shutil
- def updateSheet(Application, SourcePathName):
- Workbook = Application.Workbooks.open(SourcePathName)
- Workbook.RefreshAll()
- Workbook.Save()
- Application = win32com.client.Dispatch("Excel.Application")
- Application.Visible = 1
- sourcePaths = ["c:/A/1/xls1", "c:/B/1/xls2", "c:/Q/45/xls3"]
- for i in sourcePaths:
- updateSheet(Application, i)
- Application.Quit()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement