openpyxl.worksheet.properties module
Worksheet Properties
- class openpyxl.worksheet.properties.Outline(applyStyles=None, summaryBelow=None, summaryRight=None, showOutlineSymbols=None)[source]
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)[source]
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)[source]
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’>