AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection'

Tim Golden mail at timgolden.me.uk
Thu Feb 13 13:13:00 CET 2014


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; a
tiny number (possibly zero) will have experience of generating Charts in
Excel.


It's not that people are unwilling to help, but you have to meet us
halfway: write a few lines of code which take us to the point you're at
that we can run with *just* Python and the pywin32 libraries. Don't call
a function you've defined somewhere else because we can't see the function.

Something like this:

import win32com.client

xl = win32com.client.gencache.EnsureDispatch("Excel.Application")
wb = xl.Workbooks.Add()

#
# Something here to create a chart so we can help you out
#


TJG



More information about the Python-list mailing list