[python-win32] Original Problem

[Bob Gailer]

In my previous e-mail I mentioned a problem communication with excel. Here 
is the code (note that graph_base.xls has a blank chart on it):

----------------i:\samis\python\super_out.py------------------------------------
import win32com.client
ex = win32com.client.Dispatch("excel.application");ex.Visible = 1
wb = ex.Workbooks.Open('i:\\samis\\data\\graph_base.xls')
sheets = ex.Worksheets.Count
ex.Worksheets(1).Copy(None, ex.Worksheets(1))
wk2 = ex.Worksheets(sheets + 1)
co = wk2.ChartObjects(1)
ch = co.Chart
ch.ChartType = 4 # xlLine
series_range = ex.Range("C25:D27")
ch.SeriesCollection().Add(series_range, 2)
------------------------------------------------------------

and here is the error (on my client's machine, under win32all 150
------------------------------------------------------------
   File "i:\samis\python\super_out.py", line 11
     ch.SeriesCollection().Add(series_range, 2)
   File "<COMObject SeriesCollection>", line 3, in Add
   File "C:\Python22\lib\site-packages\win32com\client\__init__.py", line 
93, in Dispatch
     return __WrapDispatch(dispatch, userName, resultCLSID, typeinfo, 
UnicodeToString, clsctx)
   File "C:\Python22\lib\site-packages\win32com\client\__init__.py", line 
41, in __WrapDispatch
     return dynamic.Dispatch(dispatch, userName, WrapperClass, typeinfo, 
UnicodeToString=UnicodeToString,clsctx=clsctx)
   File "C:\Python22\lib\site-packages\win32com\client\dynamic.py", line 
90, in Dispatch
     typeinfo = IDispatch.GetTypeInfo()
AttributeError: 'int' object has no attribute 'GetTypeInfo'
------------------------------------------------------------

This error does not happen on my machine (under win32all 154)

Bob Gailer
bgailer at alum.rpi.edu
303 442 2625
-------------- next part --------------

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 11/10/2003