Dispatch("Excel .Application") failed

[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\Li b\site-packages\win32c om\client\__ini t__.py", line
95, in
Dispatch
dispatch, userName = dynamic._GetGoo dDispatchAndUse rName(dispatch, userName,c
lsctx)
File "C:\Python24\Li b\site-packages\win32c om\client\dynam ic.py", line
98, in _
GetGoodDispatch AndUserName
return (_GetGoodDispat ch(IDispatch, clsctx), userName)
File "C:\Python24\Li b\site-packages\win32c om\client\dynam ic.py", line
78, in _
GetGoodDispatch
IDispatch = pythoncom.CoCre ateInstance(IDi spatch, None, clsctx, pythoncom.II
D_IDispatch)
pywintypes.com_ error: (-2147221005,
'\xce\xde\xd0\x a7\xb5\xc4\xc0\ xe0\xb1\xf0\xd7 \xd6\xb7\xfb\xb 4\xae',
None, None)

[Mike Driscoll]

On Mar 13, 1:02 am, lialie <lia...@gmail.c omwrote:

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\Li b\site-packages\win32c om\client\__ini t__.py", line
95, in
Dispatch
dispatch, userName = dynamic._GetGoo dDispatchAndUse rName(dispatch, userName,c
lsctx)
File "C:\Python24\Li b\site-packages\win32c om\client\dynam ic.py", line
98, in _
GetGoodDispatch AndUserName
return (_GetGoodDispat ch(IDispatch, clsctx), userName)
File "C:\Python24\Li b\site-packages\win32c om\client\dynam ic.py", line
78, in _
GetGoodDispatch
IDispatch = pythoncom.CoCre ateInstance(IDi spatch, None, clsctx, pythoncom.II
D_IDispatch)
pywintypes.com_ error: (-2147221005,
'\xce\xde\xd0\x a7\xb5\xc4\xc0\ xe0\xb1\xf0\xd7 \xd6\xb7\xfb\xb 4\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

[John Machin]

On Mar 13, 5:02 pm, lialie <lia...@gmail.c omwrote:

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\x a7\xb5\xc4\xc0\ xe0\xb1\xf0\xd7 \xd6\xb7\xfb\xb 4\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.enco ding

what do you see?