[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