Display or Hide Gridlines in Python

Aspose.Cells - How to Display or Hide Gridlines

How to Hide Gridlines

To hide gridlines in a worksheet using Aspose.Cells for Python via Java, call the displayHideGridlines module.

Python Code

workbook = self.Workbook(self.dataDir + "Book1.xls")

# Accessing the first worksheet in the Excel file
worksheets = workbook.getWorksheets()
worksheet = worksheets.get(0)

# Hiding the grid lines of the first worksheet of the Excel file
worksheet.setGridlinesVisible(False)

# Saving the modified Excel file in the default (that is Excel 2000) format
workbook.save(self.dataDir + "output.xls")

# Print message
print "Grid lines are now hidden on sheet 1, please check the output document."

How to Display Gridlines

To make gridlines visible, use the Worksheet class’s setGridlinesVisible(true) method.

Python Code

# Displaying the gridlines of the worksheet
worksheet.setGridlinesVisible(True)

Download Running Code

Download DisplayHideGridlines (Aspose.Cells) from any of the below‑mentioned social coding sites:

• GitHub