[python-win32] makepy.py excel-libs
Wolf, Matthias ALRT/ELD
Matthias.Wolf at al-lighting.com
Thu Jul 20 09:43:52 CEST 2006
Hello
I've made a 'Microsoft Excel 11.0 Object Library' from the
'EXCEL.EXE'-File and can now create excel-diagrams with python.
But if want to use some special variables e.g. 'MajorGridlines':
####### VBA-Marco-Example
ActiveChart.Axes(xlValue).MajorGridlines.Select
With Selection.Border
.ColorIndex = 57
.Weight = xlHairline
.LineStyle = xlDot
End With
End Sub
#######
####### Python-Example
c = excel.ActiveChart
c.Axes(excelcom.constants.xlValue).MajorGridlines.Weight =
excelcom.constants.xlHairline
#######
I get the following error: AttributeError: '<win32com.gen_py.Microsoft
Excel 11.0 Object Library.Gridlines instance at 0x21599600>' object has
no attribute 'Weight'
Why can I not manipulate this 'MajorGridlines'? Is there anything
missing in my Library. If yes, which library i have to use?
Thanks in advanced!
Kind regards, Wolf
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/python-win32/attachments/20060720/cd24e40f/attachment.html
More information about the Python-win32
mailing list