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
--
http://mail.python.org/mailman/listinfo/python-list
