def __init__(self): dataDir = Settings.dataDir + 'WorkingWithWorksheets/DisplayHideTabs/' workbook = Workbook(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(dataDir + "output.xls") # Print message print "Tabs are now hidden, please check the output file."
def __init__(self): dataDir = Settings.dataDir + 'WorkingWithWorksheets/DisplayHideScrollBars/' workbook = Workbook(dataDir + "Book1.xls") #Hiding the vertical scroll bar of the Excel file workbook.getSettings().setVScrollBarVisible(False) #Hiding the horizontal scroll bar of the Excel file workbook.getSettings().setHScrollBarVisible(False) #Saving the modified Excel file in default (that is Excel 2003) format workbook.save(dataDir + "output.xls") # Print message print "Scroll bars are now hidden, please check the output document."