Dispatch("Excel.Application") failed


L

lialie

Hi,
Maybe it 's quite simple, but I can't fix it. Do I make some mistakes in
my env setting? My excel version is 2003.
any suggestion? Thanks.

Traceback (most recent call last):
File "testexcel.py", line 3, in ?
excel = Dispatch("Excel.Application")
File "C:\Python24\Lib\site-packages\win32com\client\__init__.py", line
95, in
Dispatch
dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,c
lsctx)
File "C:\Python24\Lib\site-packages\win32com\client\dynamic.py", line
98, in _
GetGoodDispatchAndUserName
return (_GetGoodDispatch(IDispatch, clsctx), userName)
File "C:\Python24\Lib\site-packages\win32com\client\dynamic.py", line
78, in _
GetGoodDispatch
IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.II
D_IDispatch)
pywintypes.com_error: (-2147221005,
'\xce\xde\xd0\xa7\xb5\xc4\xc0\xe0\xb1\xf0\xd7\xd6\xb7\xfb\xb4\xae',
None, None)
 
Ad

Advertisements

M

Mike Driscoll

Hi,
Maybe it 's quite simple, but I can't fix it. Do I make some mistakes in
my env setting? My excel version is 2003.
any suggestion? Thanks.

Traceback (most recent call last):
File "testexcel.py", line 3, in ?
excel = Dispatch("Excel.Application")
File "C:\Python24\Lib\site-packages\win32com\client\__init__.py", line
95, in
Dispatch
dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,c
lsctx)
File "C:\Python24\Lib\site-packages\win32com\client\dynamic.py", line
98, in _
GetGoodDispatchAndUserName
return (_GetGoodDispatch(IDispatch, clsctx), userName)
File "C:\Python24\Lib\site-packages\win32com\client\dynamic.py", line
78, in _
GetGoodDispatch
IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.II
D_IDispatch)
pywintypes.com_error: (-2147221005,
'\xce\xde\xd0\xa7\xb5\xc4\xc0\xe0\xb1\xf0\xd7\xd6\xb7\xfb\xb4\xae',
None, None)

I'm not seeing anything obviously wrong. What version of Windows are
you using? Are you logged in as an admin?

You also might try the PyWin32 user's mailing list:
http://mail.python.org/mailman/listinfo/python-win32

Mike
 
J

John Machin

Hi,
Maybe it 's quite simple, but I can't fix it. Do I make some mistakes in
my env setting? My excel version is 2003.
any suggestion? Thanks.

Traceback (most recent call last):
File "testexcel.py", line 3, in ?
excel = Dispatch("Excel.Application") [snip]
pywintypes.com_error: (-2147221005,
'\xce\xde\xd0\xa7\xb5\xc4\xc0\xe0\xb1\xf0\xd7\xd6\xb7\xfb\xb4\xae',
None, None)

Googling for 2147221005 gives some clues.

That string of hex stuff appears where an error message is expected --
it's not utf8, and makes no sense when I attempt to decode it with
cp1250 to cp1258 inclusive. If you start IDLE and type:

import sys; sys.stdout.encoding

what do you see?
 
Ad

Advertisements

R

Ryan Ginstrom

On Behalf Of John Machin
Googling for 2147221005 gives some clues.

That string of hex stuff appears where an error message is
expected -- it's not utf8, and makes no sense when I attempt
to decode it with cp1250 to cp1258 inclusive. If you start
IDLE and type:

The hex stuff is Chinese. It appears to be a standard Windows error message.
ÎÞЧµÄÀà±ð×Ö·û´® (Which I believe meaans "invalid class string")

I wrote in another post (that doesn't appear to have made it to the list)
that the call to Dispatch on Excel will fail if the formula bar edit box is
active. Just another idea.

Regards,
Ryan Ginstrom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top