当使用win32com在Python中打开并操作Excel文件后，发现正常方式无法完全关闭Excel进程。通过尝试不同的方法，包括调用`Quit()`和设置变量为`None`，问题仍未解决。最终，通过引入`win32process`、`win32gui`和`win32api`模块，使用强制关闭进程的技巧，实现了即使应用程序没有响应也能关闭Excel进程的功能。在代码中添加`del excel`语句可以将Excel实例从任务管理器中移除。
This is my code, and I found many answers for VBA, .NET framework and is pretty strange. When I execute this, Excel closes.
from win32com.client import DispatchEx
excel = DispatchEx('Excel.Application')
wbs = excel.Workbooks
wbs.Close()
excel.Quit()
wbs = None
excel = None #
But when I do the following, it does not close.
excel = DispatchEx('Excel.Application')
wbs = excel.Workbooks
wb = wbs.Open('D:\\Xaguar\\A1.xlsm')
wb.Close(False)
wbs.Close()
excel.Quit()
wb = None
wbs = None
excel = None #
I found some possible answer in Stack Overflow question
Even it does not bother me if I can just get the PID and kill it.
May be not the proper way, but a workround is:
最低0.47元/天 解锁文章
1989
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
