Display or Hide Tabs in Python

Aspose.Cells - Display Hide Tabs

Hiding Tabs

To hide tabs using Aspose.Cells Java for Ruby, call 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 default (that is 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' setSheetTabBarHidden(false) method.

Python Code

 # Displaying the tabs of the Excel file

workbook.getSettings().setSowTabs(true)

Download Running Code

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