[python-win32] pywintypes.com_error: (-2147221164

[Mark Hammond]

On 15/12/2013 10:37 PM, WangMengNan(桌面事业部) wrote:
> Hi，All：
>
> Sorry to bother you.
>
> I have a python2.7 program,my pc's environment is win7,32bit.I want to
> use win32com,and I have installed
>
> win32com for python2.7. When I worte the code"xls =
> client.Dispatch("Excel.Application")",an error happened:
>
> Traceback (most recent call last):
>
> _File "D:\JackieCodeProject\python\newvenus\excel_yanxiaoqing.py", line
> 168, in <module>_
>
>      write_to_mysql(r'C:\V4.2.xlsx',"王梦楠",1294)
>
> _File "D:\JackieCodeProject\python\newvenus\excel_yanxiaoqing.py", line
> 76, in write_to_mysql_
>
>      case_list = getlist_from_excel(file_name)
>
> _File "D:\JackieCodeProject\python\newvenus\excel_yanxiaoqing.py", line
> 27, in getlist_from_excel_
>
>      xls = client.Dispatch("Excel.Application")
>
> _File "C:\Python27\lib\site-packages\win32com\client\__init__.py", line
> 95, in Dispatch_
>
>      dispatch, userName =
> dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
>
> _File "C:\Python27\lib\site-packages\win32com\client\dynamic.py", line
> 108, in _GetGoodDispatchAndUserName_
>
>      return (_GetGoodDispatch(IDispatch, clsctx), userName)
>
> _File "C:\Python27\lib\site-packages\win32com\client\dynamic.py", line
> 85, in _GetGoodDispatch_
>
>      IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx,
> pythoncom.IID_IDispatch)
>
> pywintypes.com_error: (-2147221164,
> '\xc3\xbb\xd3\xd0\xd7\xa2\xb2\xe1\xc0\xe0', None, None)

This is "Class not registered".  I suspected you have a 64bit version of 
Python, but only a 32bit version of Excel installed (or vice-versa), but 
you mention you are running a 32bit environment - are you completely 
sure about that?  Otherwise, it simply seems Excel wasn't correctly 
installed.

HTH,

Mark

>
> I need you help.
>
>
>
> _______________________________________________
> python-win32 mailing list
> python-win32 at python.org
> https://mail.python.org/mailman/listinfo/python-win32
>