我的一个项目需要通过python以只读方式打开各种Microsoft Office文档。虽然 win32com 的 Excel 和 Word 功能从未遇到过包含空格的文档的问题,但 win32com PowerPoint 不允许这样做。
from win32com.client import Dispatch
Application = Dispatch("PowerPoint.Application")
Application.Visible = True
Test = Application.Presentations.Open("C:/Users/MYUSERNAME/Desktop/The Test.pptx", ReadOnly=True)
产生错误:
com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2147024894), None)
我目前的解决方案是重命名文件,用下划线替换空格,然后在文件打开后将其重命名。但是,这需要打开无标题的文档。
from win32com.client import Dispatch
import os
Application = Dispatch("PowerPoint.Application")
Application.Visible = True
Filename = 'The Test.pptx'
os.rename("C:/Users/MYUSERNAME/Desktop/" + Filename, "C:/Users/MYUSERNAME/Desktop/" + Filename.replace(" ","_"))
Test = Application.Presentations.Open("C:/Users/MYUSERNAME/Desktop/" + Filename.replace(" ","_"), ReadOnly=True, Untitled=True)
os.rename("C:/Users/MYUSERNAME/Desktop/" + Filename.replace(" ","_"), "C:/Users/MYUSERNAME/Desktop/" + Filename)
有更好的方法吗?
请您参考如下方法:
使用反斜杠应该可行:
from win32com.client import Dispatch
def openfile():
Application = Dispatch("PowerPoint.Application")
Application.Visible = True
Test = Application.Presentations.Open(r"C:\transfer\hello world.pptx", ReadOnly=True)
if __name__ == "__main__":
openfile()
