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

Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!newsfeed.xs4all.nl!newsfeed4a.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<prvs=11452c52e=sschukat@dspace.de>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.012
X-Spam-Evidence	'H': 0.98; 'S': 0.00; 'attribute': 0.07; 'skip:" 60': 0.07; 'subject:instance': 0.09; 'from:addr:dspace.de': 0.16; 'patil': 0.16; 'received:80.66': 0.16; 'received:80.66.6': 0.16; 'received:80.66.6.100': 0.16; 'received:dspace.de': 0.16; 'skip:[ 50': 0.16; 'subject: \n ': 0.16; 'subject:Object': 0.16; 'subject:object': 0.16; 'thursday,': 0.16; 'message-----': 0.19; 'pfxlen:0': 0.19; 'shape': 0.19; 'stefan': 0.19; '>>>': 0.22; 'import': 0.22; 'cc:addr:gmail.com': 0.22; 'to:name:python- list@python.org': 0.22; 'print': 0.22; 'cc:2**0': 0.24; 'code:': 0.26; 'excel': 0.26; 'header:In-Reply-To:1': 0.27; 'raise': 0.29; 'url:mailman': 0.30; "skip:' 10": 0.31; '"",': 0.31; '13,': 0.31; 'object.': 0.31; 'file': 0.32; 'skip:c 30': 0.32; 'url:python': 0.33; '(most': 0.33; 'skip:d 20': 0.34; 'created': 0.35; 'but': 0.35; 'add': 0.35; 'url:listinfo': 0.36; 'charset:us-ascii': 0.36; 'url:org': 0.36; 'email addr:python.org': 0.37; 'received:10': 0.37; 'to:addr:python-list': 0.38; 'skip:- 10': 0.38; 'recent': 0.39; 'subject:': 0.39; 'to:addr:python.org': 0.39; 'unable': 0.39; 'url:mail': 0.40; 'received:unknown': 0.61; 'received:10.1': 0.61; 'skip:a 30': 0.61; 'email name:python-list': 0.65; 'series': 0.66; 'skip:w 30': 0.69; 'subject:skip:A 10': 0.78; 'subject:skip:S 10': 0.84; 'subject:skip:w 20': 0.91
X-IronPort-AV	E=Sophos;i="4.95,838,1384297200"; d="scan'208";a="641325"
From	Stefan Schukat <SSchukat@dspace.de>
To	"python-list@python.org" <python-list@python.org>
Subject	RE: AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection'
Thread-Topic	AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection'
Thread-Index	AQHPKKvOnt99Uj+EvU+IsoP6hM9j3pqzRp8w
Date	Thu, 13 Feb 2014 15:08:05 +0000
References	<942ed7d6-aec9-4bb5-9b88-60ce62b3ff2e@googlegroups.com>
In-Reply-To	<942ed7d6-aec9-4bb5-9b88-60ce62b3ff2e@googlegroups.com>
Accept-Language	de-DE, en-US
Content-Language	de-DE
X-MS-Has-Attach
X-MS-TNEF-Correlator
x-originating-ip	[10.1.100.133]
x-tm-as-product-ver	SMEX-10.2.0.1135-7.500.1017-20498.002
x-tm-as-result	No--42.505800-8.000000-31
x-tm-as-user-approved-sender	No
x-tm-as-user-blocked-sender	No
Content-Type	text/plain; charset="us-ascii"
Content-Transfer-Encoding	quoted-printable
MIME-Version	1.0
X-TBoneOriginalFrom	Stefan Schukat <SSchukat@dspace.de>
X-TBoneOriginalTo	"python-list@python.org" <python-list@python.org>
X-TBoneOriginalCC	Jaydeep Patil <patil.jay2009@gmail.com>
X-TBoneDomainSigned	false
Cc	Jaydeep Patil <patil.jay2009@gmail.com>
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.6842.1392304156.18130.python-list@python.org> (permalink)
Lines	57
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1392304156 news.xs4all.nl 2952 [2001:888:2000:d::a6]:58498
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:66182

Show key headers only | View raw

Hello, 

the "chartObj" is not a Chart object it is a shape see <win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape ...
Hence this object has no SeriesCollection try the Chart Attribute of the shape object.

>>> from win32com.client import Dispatch
>>> Excel = Dispatch("Excel.Application")
>>> WB = Excel.Workbooks.Add()
>>> Shape = WB.Sheets[0].Shapes.AddChart()
>>> Shape.Chart.SeriesCollection
<bound method CDispatch.SeriesCollection of <COMObject <unknown>>>
 

Regards

	Stefan Schukat


-----Original Message-----
From: Python-list [mailto:python-list-bounces+sschukat=dspace.de@python.org] On Behalf Of Jaydeep Patil
Sent: Thursday, February 13, 2014 12:05 PM
To: python-list@python.org
Subject: AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection'

I have created chart object. But unable to add series into chart. 
Look at below collection

Code: 

chartObj = addNewChart(newws,-4169,350,600)
>>> print chartObj;
<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>
>>> chartObj.SeriesCollection().NewSeries()

Traceback (most recent call last):
  File "<pyshell#16>", line 1, in <module>
    chartObj.SeriesCollection().NewSeries()
  File "C:\Python27\lib\site-packages\win32com\client\__init__.py", line 465, in __getattr__
    raise AttributeError("'%s' object has no attribute '%s'" % (repr(self), attr))
AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection'
>>> se = chartObj.SeriesCollection().NewSeries()



Regards
Jaydeep Patil
-- 
https://mail.python.org/mailman/listinfo/python-list

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection' Jaydeep Patil <patil.jay2009@gmail.com> - 2014-02-13 03:04 -0800
  Re: AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection' Ben Finney <ben+python@benfinney.id.au> - 2014-02-13 22:11 +1100
    Re: AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection' Jaydeep Patil <patil.jay2009@gmail.com> - 2014-02-13 03:58 -0800
      Re: AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection' Tim Golden <mail@timgolden.me.uk> - 2014-02-13 12:13 +0000
  RE: AttributeError: '<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70837752>' object has no attribute 'SeriesCollection' Stefan Schukat <SSchukat@dspace.de> - 2014-02-13 15:08 +0000

csiph-web