[pywin32-bugs] [ pywin32-Bugs-841605 ] com->Excel: 'int' object has no attribute 'GetTypeInfo'

[SourceForge.net <no...@so...>]

Bugs item #841605, was opened at 2003-11-13 11:24
Message generated for change (Comment added) made by ramrom
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=551954&aid=841605&group_id=78018

Category: com
Group: None
Status: Open
Resolution: None
Priority: 9
Submitted By: bob gailer (ramrom)
Assigned to: Nobody/Anonymous (nobody)
>Summary: com->Excel: 'int' object has no attribute 'GetTypeInfo'

Initial Comment:
win32all Version 154 
------------ CODE ---------------
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)
------------ ERROR ---------------
  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'


----------------------------------------------------------------------

>Comment By: bob gailer (ramrom)
Date: 2004-04-19 13:27

Message:
Logged In: YES 
user_id=587593

I have researched this more. I have posted a new bug 938098
with the new research. I am posting a new bug because I have
gone as far as I can and really need help, as my clients are
waiting to use the program.

----------------------------------------------------------------------

Comment By: bob gailer (ramrom)
Date: 2003-11-21 13:54

Message:
Logged In: YES 
user_id=587593

I really need help with this one, as I cannot serve my
client's needs until it is fixed.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=551954&aid=841605&group_id=78018