在不打开excel的情况下用python执行excel

import win32com.client

import time

path = r'absolute dir' #比如填文件的绝对路径，比如d:/file/stock.xlsx

xl = win32com.client.DispatchEx("Excel.Application")

workbook = xl.Workbooks.Open(path)

xl.Visible = False

workbook.RefreshAll()

workbook.Save()

# time.sleep(3) #如果文件足够大，那么最好是在关闭excel之前保持几秒钟

workbook.Close(True)

xl.Quit()

from: https://blog.csdn.net/chang1976272446/article/details/80668034