How To Set Axis Using xlwings?

【Method】

The Border property returns the axis’s border properties.

– ColorIndex property

– Weight property

– DashStyle property

sht.api.Range(“A1:B7”).Select()    #Data

cht=sht.api.Shapes.AddChart().Chart    #Add chart

axs=cht.Axes(1)    #Horizontal axis

axs.Border.ColorIndex=3    #Red

axs.Border.Weight=3    #Line width

axs.HasMinorGridlines=True    #Show minor gridlines

axs2=cht.Axes(2)    #Vertical axis

axs2.Border.Color=xw.utils.rgb_to_int((0,0,255))    #Blue

axs2.Border.Weight=3    #Line width

axs2.HasMinorGridlines=True    #Show minor gridlines

【Example】

【Code】

#Axis Settings

import xlwings as xw
import os

root = os.getcwd()
app = xw.App(visible=True, add_book=False)
wb=app.books.open(root+r"/P1P2.xlsx",read_only=False)
sht=wb.sheets(1)

sht.api.Range("A1:B7").Select()    #Data
cht=sht.api.Shapes.AddChart().Chart    #Add chart
axs=cht.Axes(1)    #Horizontal axis
axs.Border.ColorIndex=3    #Red
axs.Border.Weight=3    #Line width
axs.HasMinorGridlines=True    #Show minor gridlines
axs2=cht.Axes(2)    #Vertical axis
axs2.Border.Color=xw.utils.rgb_to_int((0,0,255))    #Blue
axs2.Border.Weight=3    #Line width
axs2.HasMinorGridlines=True    #Show minor gridlines

#wb.save()
#wb.close()
#app.kill()