# openpyxl.worksheet.views module

class openpyxl.worksheet.views.Pane(xSplit=None, ySplit=None, topLeftCell=None, activePane='topLeft', state='split')

  Bases: `Serialisable`

  activePane

    Value must be one of [‘bottomLeft’, ‘bottomRight’, ‘topLeft’, ‘topRight’]

  state

    Value must be one of [‘frozen’, ‘frozenSplit’, ‘split’]

  topLeftCell

    Values must be of type <class ‘str’>

  xSplit

    Values must be of type <class ‘float’>

  ySplit

    Values must be of type <class ‘float’>

class openpyxl.worksheet.views.Selection(pane=None, activeCell='A1', activeCellId=None, sqref='A1')

  Bases: `Serialisable`

  activeCell

    Values must be of type <class ‘str’>

  activeCellId

    Values must be of type <class ‘int’>

  pane

    Value must be one of [‘bottomLeft’, ‘bottomRight’, ‘topLeft’, ‘topRight’]

  sqref

    Values must be of type <class ‘str’>

class openpyxl.worksheet.views.SheetView(windowProtection=None, showFormulas=None, showGridLines=None, showRowColHeaders=None, showZeros=None, rightToLeft=None, tabSelected=None, showRuler=None, showOutlineSymbols=None, defaultGridColor=None, showWhiteSpace=None, view=None, topLeftCell=None, colorId=None, zoomScale=None, zoomScaleNormal=None, zoomScaleSheetLayoutView=None, zoomScalePageLayoutView=None, zoomToFit=None, workbookViewId=0, selection=None, pane=None)

  Bases: `Serialisable`

  Information about the visible portions of this sheet.

  colorId

    Values must be of type <class ‘int’>

  defaultGridColor

    Values must be of type <class ‘bool’>

  pane

    Values must be of type <class ‘openpyxl.worksheet.views.Pane’>

  rightToLeft

    Values must be of type <class ‘bool’>

  selection

    A sequence (list or tuple) that may only contain objects of the declared type

  showFormulas

    Values must be of type <class ‘bool’>

  showGridLines

    Values must be of type <class ‘bool’>

  showOutlineSymbols

    Values must be of type <class ‘bool’>

  showRowColHeaders

    Values must be of type <class ‘bool’>

  showRuler

    Values must be of type <class ‘bool’>

  showWhiteSpace

    Values must be of type <class ‘bool’>

  showZeros

    Values must be of type <class ‘bool’>

  tabSelected

    Values must be of type <class ‘bool’>

  tagname = 'sheetView'
  topLeftCell

    Values must be of type <class ‘str’>

  view

    Value must be one of [‘normal’, ‘pageBreakPreview’, ‘pageLayout’]

  windowProtection

    Values must be of type <class ‘bool’>

  workbookViewId

    Values must be of type <class ‘int’>

  zoomScale

    Values must be of type <class ‘int’>

  zoomScaleNormal

    Values must be of type <class ‘int’>

  zoomScalePageLayoutView

    Values must be of type <class ‘int’>

  zoomScaleSheetLayoutView

    Values must be of type <class ‘int’>

  zoomToFit

    Values must be of type <class ‘bool’>

class openpyxl.worksheet.views.SheetViewList(sheetView=None, extLst=None)

  Bases: `Serialisable`

  property active

    Returns the first sheet view which is assumed to be active

  extLst

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

  sheetView

    A sequence (list or tuple) that may only contain objects of the declared type

  tagname = 'sheetViews'