37,720
社区成员
发帖
与我相关
我的任务
分享
from win32com.client import Dispatch
xlApp = Dispatch("Excel.Application")
xlBook = xlApp.Workbooks.Open("E:\test111.xls")
sht = xlBook.Worksheets("Sheet1")
print sht.Cells(1,1).Value
>>> sys.path.append("C:\Python27\Lib\site-packages\win32com")
>>> for i in sys.path:
print i
C:/Python27
C:\Python27\Lib\idlelib
C:\WINDOWS\system32\python27.zip
C:\Python27\DLLs
C:\Python27\lib
C:\Python27\lib\plat-win
C:\Python27\lib\lib-tk
C:\Python27
C:\Python27\lib\site-packages
C:\Python27\lib\site-packages\win32
C:\Python27\lib\site-packages\win32\lib
C:\Python27\lib\site-packages\Pythonwin
C:\Python27\Lib\site-packages\win32com
>>> ================================ RESTART ================================
>>>
Traceback (most recent call last):
File "C:/Python27/222.py", line 3, in <module>
xlBook = xlApp.Workbooks.Open("E:\test111.xls")
File "<COMObject <unknown>>", line 8, in Open
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, u'Microsoft Office Excel', u'\u627e\u4e0d\u5230\u201cE:\test111.xls\u201d\u3002\u8bf7\u68c0\u67e5\u6587\u4ef6\u540d\u7684\u62fc\u5199\uff0c\u5e76\u9a8c\u8bc1\u6587\u4ef6\u4f4d\u7f6e\u662f\u5426\u6b63\u786e\u3002\n\n\u5982\u679c\u60a8\u6b63\u8bd5\u56fe\u4ece\u6700\u8fd1\u4f7f\u7528\u7684\u6587\u4ef6\u5217\u8868\u4e2d\u6253\u5f00\u8be5\u6587\u4ef6\uff0c\u8bf7\u786e\u4fdd\u8be5\u6587\u4ef6\u672a\u88ab\u91cd\u547d\u540d\u3001\u79fb\u52a8\u6216\u5220\u9664\u3002', u'C:\\Program Files\\Microsoft Office\\Office12\\2052\\XLMAIN11.CHM', 0, -2146827284), None)
>>>
>>> print u'\u627e\u4e0d\u5230\u201cE:\test111.xls'
找不到“E: est111.xls
>>>
>>>
PBI
>>> print "E:\test111.xls"
E: est111.xls
>>> print r"E:\test111.xls"
E:\test111.xls
>>>