[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.python

Dispatch("Excel.Application") failed

lialie

3/13/2008 6:03:00 AM

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)
3 Answers

Mike Driscoll

3/13/2008 1:04:00 PM

0

On Mar 13, 1:02 am, lialie <lia...@gmail.com> wrote:
> 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/py...

Mike

John Machin

3/13/2008 9:57:00 PM

0

On Mar 13, 5:02 pm, lialie <lia...@gmail.com> wrote:
> 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?

Ryan Ginstrom

3/13/2008 11:22:00 PM

0

> On Behalf Of John Machin
> > '\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:

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