# openpyxl.worksheet.properties module

Worksheet Properties

class openpyxl.worksheet.properties.Outline(applyStyles=None, summaryBelow=None, summaryRight=None, showOutlineSymbols=None)

  Bases: `Serialisable`

  applyStyles

    Values must be of type <class ‘bool’>

  showOutlineSymbols

    Values must be of type <class ‘bool’>

  summaryBelow

    Values must be of type <class ‘bool’>

  summaryRight

    Values must be of type <class ‘bool’>

  tagname = 'outlinePr'

class openpyxl.worksheet.properties.PageSetupProperties(autoPageBreaks=None, fitToPage=None)

  Bases: `Serialisable`

  autoPageBreaks

    Values must be of type <class ‘bool’>

  fitToPage

    Values must be of type <class ‘bool’>

  tagname = 'pageSetUpPr'

class openpyxl.worksheet.properties.WorksheetProperties(codeName=None, enableFormatConditionsCalculation=None, filterMode=None, published=None, syncHorizontal=None, syncRef=None, syncVertical=None, transitionEvaluation=None, transitionEntry=None, tabColor=None, outlinePr=None, pageSetUpPr=None)

  Bases: `Serialisable`

  codeName

    Values must be of type <class ‘str’>

  enableFormatConditionsCalculation

    Values must be of type <class ‘bool’>

  filterMode

    Values must be of type <class ‘bool’>

  outlinePr

    Values must be of type <class ‘openpyxl.worksheet.properties.Outline’>

  pageSetUpPr

    Values must be of type <class ‘openpyxl.worksheet.properties.PageSetupProperties’>

  published

    Values must be of type <class ‘bool’>

  syncHorizontal

    Values must be of type <class ‘bool’>

  syncRef

    Values must be of type <class ‘str’>

  syncVertical

    Values must be of type <class ‘bool’>

  tabColor

    Values must be of type <class ‘openpyxl.styles.colors.Color’>

  tagname = 'sheetPr'
  transitionEntry

    Elements

  transitionEvaluation

    Values must be of type <class ‘bool’>