How To Set Gridlines Using xlwings?

【Method】

Gridlines are represented by the **Gridlines** object. You can use its **Border** or **Format** properties to set the gridline color, line style, width, and other attributes. The **MajorGridlines** and **MinorGridlines** properties of the **Axis** object return **Gridlines** objects for the major and minor gridlines, respectively. Before setting these properties, the **HasMajorGridlines** and/or **HasMinorGridlines** properties of the **Axis** object must be set to `True`.

sht.api.Range(‘A1:B7’).Select()    #Data

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

axs=cht.Axes(1)    #Horizontal axis

axs2=cht.Axes(2)    #Vertical axis

axs.HasMajorGridlines=True    #Show major gridlines for horizontal axis

axs.MajorGridlines.Border.ColorIndex =3    #Red

axs.MajorGridlines.Border.LineStyle = xw.constants.LineStyle.xlDash    #Line style

axs2.HasMajorGridlines=True    #Show major gridlines for vertical axis

axs2.MajorGridlines.Border.ColorIndex = 3    #Red

axs2.MajorGridlines.Border.LineStyle = xw.constants.LineStyle.xlDash    #Line style

#Can also use the following code for setting

#axs.MajorGridlines.Format.Line.ForeColor.RGB=xw.utils.rgb_to_int((255,0,0))

#axs.MajorGridlines.Format.Line.DashStyle=4

#axs2.MajorGridlines.Format.Line.ForeColor.RGB=xw.utils.rgb_to_int((255,0,0))

#axs2.MajorGridlines.Format.Line.DashStyle=4

【Example】

【Code】

#Coordinate system - Gridlines

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
axs2=cht.Axes(2)    #Vertical axis
axs.HasMajorGridlines=True    #Show major gridlines for horizontal axis
axs.MajorGridlines.Border.ColorIndex =3    #Red
axs.MajorGridlines.Border.LineStyle = xw.constants.LineStyle.xlDash    #Line style
axs2.HasMajorGridlines=True    #Show major gridlines for vertical axis
axs2.MajorGridlines.Border.ColorIndex = 3    #Red
axs2.MajorGridlines.Border.LineStyle = xw.constants.LineStyle.xlDash    #Line style
#Can also use the following code for setting
#axs.MajorGridlines.Format.Line.ForeColor.RGB=xw.utils.rgb_to_int((255,0,0))
#axs.MajorGridlines.Format.Line.DashStyle=4
#axs2.MajorGridlines.Format.Line.ForeColor.RGB=xw.utils.rgb_to_int((255,0,0))
#axs2.MajorGridlines.Format.Line.DashStyle=4

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