通过xlwings操作excel

import xlwings as xw
import time

app = xw.App(visible=True, add_book=False)
# 1.打开原工作簿
# workbook = app.books.open(r"D:/code/3.17/123.xlsx")
workbook = app.books.open(r"E:/share/beijing/beijing.xlsm")
# 刷新
workbook.api.RefreshAll()
# 2.打开原有工作表
sht = workbook.sheets['sheet1']

time.sleep(10)


workbook.save()
workbook.close()
app.quit()