Display or Hide Tabs in Python

Aspose.Cells - Display/Hide Tabs

Hiding Tabs

To hide tabs using Aspose.Cells for Java, call the displayHideTabs module.

Python Code

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

# Hiding the tabs of the Excel file
workbook.getSettings().setShowTabs(False)

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

# Print message
print "Tabs are now hidden, please check the output file."

Making Tabs Visible

Make tabs visible with the Workbook class’s setSheetTabBarHidden(false) method.

Python Code

# Displaying the tabs of the Excel file
workbook.getSettings().setShowTabs(True)

Download Running Code

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

• GitHub