pythoncom.CoInitialize()
xl = win32com.client.Dispatch("Excel.Application")
xl.DisplayAlerts = False
xl.Visible = True
wb = xl.Workbooks.Open(file)
如果提示安全问题,用电脑上的excel打开文件重新保存一遍,再操作
参考
https://blog.csdn.net/qq_15557299/article/details/112645073