(win32com 读写 excel时候,open函数不能打开相对路径文档)
问题如下(请问各位大神如何解决相对路径下打开文档):
打开同.py相同路径下的a.xlsx文档,报错
from win32com import clientxlApp = client.Dispatch("Excel.Application")xlApp.Visible = Truebooks = xlApp.Workbooks.Open("a.xlsx")'books = xlApp.Open("a.xlsx")File "E:\pycharmtest\venv\lib\site-packages\win32com\client\__init__.py", line 473, in __getattr__raise AttributeError("'%s' object has no attribute '%s'" % (repr(self), attr))AttributeError: '<win32com.gen_py.Microsoft Excel 16.0 Object Library._Application instance at 0x2428465361136>' object has no attribute 'Open';
打开同.py相同路径下的a.xlsx文档,将路径写为 F:\ipython\a.xlsx 则没有问题
from win32com import clientxlApp = client.Dispatch("Excel.Application")xlApp.Visible = Truebooks = xlApp.Workbooks.Open("F:\\ipython\\a.xlsx")'