# openpyxl.workbook.views module

class openpyxl.workbook.views.BookView(visibility='visible', minimized=False, showHorizontalScroll=True, showVerticalScroll=True, showSheetTabs=True, xWindow=None, yWindow=None, windowWidth=None, windowHeight=None, tabRatio=600, firstSheet=0, activeTab=0, autoFilterDateGrouping=True, extLst=None)

  Bases: `Serialisable`

  activeTab

    Values must be of type <class ‘int’>

  autoFilterDateGrouping

    Values must be of type <class ‘bool’>

  extLst

    Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

  firstSheet

    Values must be of type <class ‘int’>

  minimized

    Values must be of type <class ‘bool’>

  showHorizontalScroll

    Values must be of type <class ‘bool’>

  showSheetTabs

    Values must be of type <class ‘bool’>

  showVerticalScroll

    Values must be of type <class ‘bool’>

  tabRatio

    Values must be of type <class ‘int’>

  tagname = 'workbookView'
  visibility

    Value must be one of [‘hidden’, ‘veryHidden’, ‘visible’]

  windowHeight

    Values must be of type <class ‘int’>

  windowWidth

    Values must be of type <class ‘int’>

  xWindow

    Values must be of type <class ‘int’>

  yWindow

    Values must be of type <class ‘int’>

class openpyxl.workbook.views.CustomWorkbookView(name=None, guid=None, autoUpdate=None, mergeInterval=None, changesSavedWin=None, onlySync=None, personalView=None, includePrintSettings=None, includeHiddenRowCol=None, maximized=None, minimized=None, showHorizontalScroll=None, showVerticalScroll=None, showSheetTabs=None, xWindow=None, yWindow=None, windowWidth=None, windowHeight=None, tabRatio=None, activeSheetId=None, showFormulaBar=None, showStatusbar=None, showComments='commIndicator', showObjects='all', extLst=None)

  Bases: `Serialisable`

  activeSheetId

    Values must be of type <class ‘int’>

  autoUpdate

    Values must be of type <class ‘bool’>

  changesSavedWin

    Values must be of type <class ‘bool’>

  extLst

    Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

  guid
  includeHiddenRowCol

    Values must be of type <class ‘bool’>

  includePrintSettings

    Values must be of type <class ‘bool’>

  maximized

    Values must be of type <class ‘bool’>

  mergeInterval

    Values must be of type <class ‘int’>

  minimized

    Values must be of type <class ‘bool’>

  name

    Values must be of type <class ‘str’>

  onlySync

    Values must be of type <class ‘bool’>

  personalView

    Values must be of type <class ‘bool’>

  showComments

    Value must be one of [‘commIndAndComment’, ‘commIndicator’, ‘commNone’]

  showFormulaBar

    Values must be of type <class ‘bool’>

  showHorizontalScroll

    Values must be of type <class ‘bool’>

  showObjects

    Value must be one of [‘all’, ‘placeholders’]

  showSheetTabs

    Values must be of type <class ‘bool’>

  showStatusbar

    Values must be of type <class ‘bool’>

  showVerticalScroll

    Values must be of type <class ‘bool’>

  tabRatio

    Values must be of type <class ‘int’>

  tagname = 'customWorkbookView'
  windowHeight

    Values must be of type <class ‘int’>

  windowWidth

    Values must be of type <class ‘int’>

  xWindow

    Values must be of type <class ‘int’>

  yWindow

    Values must be of type <class ‘int’>