在Python中显示或隐藏选项卡

Aspose.Cells - 显示隐藏选项卡

隐藏选项卡

要使用Aspose.Cells Java for Ruby隐藏标签页,请调用displayhidetabs模块。

Python 代码

 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."

使选项卡可见

通过将Workbook类的setSheetTabBarHidden(false)方法使标签页可见。

Python 代码

 # Displaying the tabs of the Excel file

workbook.getSettings().setSowTabs(true)

下载运行代码

从以下任何社交编码网站下载Hello World(Aspose.Cells)