Re: Dispatch(Excel.Application) failed
On Mar 13, 1:02 am, lialie [EMAIL PROTECTED] 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/python-win32 Mike -- http://mail.python.org/mailman/listinfo/python-list
Re: Dispatch(Excel.Application) failed
On Mar 13, 5:02 pm, lialie [EMAIL PROTECTED] 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? -- http://mail.python.org/mailman/listinfo/python-list
RE: Dispatch(Excel.Application) failed
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 -- http://mail.python.org/mailman/listinfo/python-list
RE: Dispatch(Excel.Application) failed
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 Thanks. I did try to google the question, but the answer wasn't properly. I am using Windows XP sp2 which language is Chinese simp. At first, I thought the hex string was coding in cp936 or utf8, then failed. second, try to run my script on the other computer, and it run well without any error! At last, I give up.After Windows Excel reinstalled, it work, but still confused.:( The net speed is horribly slow when connect to Pywin32 project at SF. Regards, Lialie -- http://mail.python.org/mailman/listinfo/python-list