RE: AttributeError: '' object has no attribute 'SeriesCollection'

2014-02-13 Thread Stefan Schukat
Hello, the "chartObj" is not a Chart object it is a shape see >> from win32com.client import Dispatch >>> Excel = Dispatch("Excel.Application") >>> WB = Excel.Workbooks.Add() >>> Shape = WB.Sheets[0].Shapes.AddChart() >>> Shape.Chart.SeriesCollection >> Regards Stefan Schukat -

Re: AttributeError: '' object has no attribute 'SeriesCollection'

2014-02-13 Thread Tim Golden
On 13/02/2014 11:58, Jaydeep Patil wrote: > Just consider that you have chart object & you need to add data series for > that chart. How you can add this? Jaydeep: you're writing to a general Python list. Few of the people here run on Windows; fewer still will use Python to automate Excel via COM

Re: AttributeError: '' object has no attribute 'SeriesCollection'

2014-02-13 Thread Jaydeep Patil
On Thursday, 13 February 2014 16:41:48 UTC+5:30, Ben Finney wrote: > Jaydeep Patil writes: > > > > > I have created chart object. But unable to add series into chart. > > > > Your code isn't self-contained (we are not able to run it as you > > presented it). > > > > Are you relying on s

Re: AttributeError: '' object has no attribute 'SeriesCollection'

2014-02-13 Thread Ben Finney
Jaydeep Patil writes: > I have created chart object. But unable to add series into chart. Your code isn't self-contained (we are not able to run it as you presented it). Are you relying on some specific third-party library? If so, you need to be explicit. You may also get better response if you