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