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>
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

Hello,=20

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

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

Regards

	Stefan Schukat


-----Original Message-----
From: Python-list [mailto:python-list-bounces+sschukat=3Ddspace.de@python.o=
rg] 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 Libr=
ary.Shape instance at 0x70837752>' object has no attribute 'SeriesCollectio=
n'

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

Code:=20

chartObj =3D addNewChart(newws,-4169,350,600)
>>> print chartObj;
<win32com.gen_py.Microsoft Excel 14.0 Object Library.Shape instance at 0x70=
837752>
>>> 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 46=
5, 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 =3D chartObj.SeriesCollection().NewSeries()



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