No subject

Tim Golden mail at timgolden.me.uk
Fri Apr 18 16:37:32 EDT 2008


SPJ wrote:
> I am writing a script which need's to convert an excel file to 
 > csv (text) format. For that I am using the following code:
> 
>     excel = win32com.client.Dispatch("Excel.Application","Quit")
>     workbook = excel.Workbooks.Open(xlsfile)
>     workbook.SaveAs(csvfile, FileFormat=24) # 24 represents xlCSVMSDOS
>     workbook.Close(False)
>     excel.Quit()
> 
> I did not have any problem running this script on a windows xp 
 > machine with python 2.5.2 and windows extensions.
> But I get the following error when I run the same script on a 
> windows 2003 server with the same python and windows extension installation:


> excel = win32com.client.Dispatch("Excel.Application","Quit")
>   File "D:\Python25\Lib\site-packages\win32com\client\__init__.py", line 95, in Dispatch
>     dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
>   File "D:\Python25\lib\site-packages\win32com\client\dynamic.py", line 98, in _GetGoodDispatchAndUserName
>     return (_GetGoodDispatch(IDispatch, clsctx), userName)
>   File "D:\Python25\lib\site-packages\win32com\client\dynamic.py", line 78, in _GetGoodDispatch
>     IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.IID_IDispatch)
> com_error: (-2147221005, 'Invalid class string', None, None)

What's that "Quit" doing as the second param to Dispatch?

TJG



More information about the Python-list mailing list