Win32COM and Excel Charts

[cheeseballs at my-deja.com]

Hi, has anyone successfully created an embedded chart within an Excel
Worksheet using win32com.client?

I'm able to create a chart in it's own Sheet with the following:
>>> xlapp=win32com.client.Dispatch("excel.application")
>>> xlapp.Visible=1
>>> xlchart=xlapp.Charts.Add()

then I try to add a chart in the active worksheet...
>>> xlsheet=xlapp.Worksheets(1)
>>> xlchartobj = xlsheet.ChartObjects.Add(10,10,100,100)

but it doesn't look like Add is a method of the ChartObjects
collection...
Any ideas?
Thanks, Drew


Sent via Deja.com http://www.deja.com/
Before you buy.