How To Hide and Show Worksheets Using xlwings?

Method

Normal hide

#xlwings API

bk.api.Sheets(‘Sheet1’).Visible = False

#bk.api.Sheets(‘Sheet1’).Visible = xw.constants.SheetVisibility.xlSheetHidden

#bk.api.Sheets(‘Sheet1’).Visible = 0

Deep hide

#xlwings API

#bk.api.Sheets(‘Sheet1’).Visible=xw.constants.SheetVisibility.xlSheetVeryHidden

#bk.api.Sheets(‘Sheet1’).Visible=2

Unhide

#xlwings

#bk.sheets(‘Sheet1’).visible = True

#bk.sheets(‘Sheet1’).visible = 1

#xlwings API

#bk.api.Sheets(‘Sheet1’).Visible = True

#bk.api.Sheets(‘Sheet1’).Visible = xw.constants.SheetVisibility.xlSheetVisible

#bk.api.Sheets(‘Sheet1’).Visible = 1

#bk.api.Sheets(‘Sheet1’).Visible = -1

Sample Code

#Hiding and Showing Worksheets

import xlwings as xw    #Import the xlwings package

app=xw.App()
bk=app.books.active    #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet
sht2=bk.sheets.add()

#Normal hide
#xlwings API
#bk.api.Sheets('Sheet1').Visible = False 
#bk.api.Sheets('Sheet1').Visible = xw.constants.SheetVisibility.xlSheetHidden
#bk.api.Sheets('Sheet1').Visible = 0

#Deep hide
#xlwings API
bk.api.Sheets('Sheet1').Visible=xw.constants.SheetVisibility.xlSheetVeryHidden
#bk.api.Sheets('Sheet1').Visible=2

#Unhide
#xlwings
bk.sheets('Sheet1').visible = True
#bk.sheets('Sheet1').visible = 1

#xlwings API
#bk.api.Sheets('Sheet1').Visible = True
#bk.api.Sheets('Sheet1').Visible = xw.constants.SheetVisibility.xlSheetVisible
#bk.api.Sheets('Sheet1').Visible = 1
#bk.api.Sheets('Sheet1').Visible = -1

#bk.close()
#app.kill()