openpyxl.worksheet.views.
Pane
(
xSplit=None
,
ySplit=None
,
topLeftCell=None
,
activePane='topLeft'
,
state='split'
)
[source]
¶
activePane
¶
Value must be one of {‘bottomLeft’, ‘topLeft’, ‘bottomRight’, ‘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’>
openpyxl.worksheet.views.
Selection
(
pane=None
,
activeCell='A1'
,
activeCellId=None
,
sqref='A1'
)
[source]
¶
activeCell
¶
Values must be of type <class ‘str’>
activeCellId
¶
Values must be of type <class ‘int’>
pane
¶
Value must be one of {‘bottomLeft’, ‘topLeft’, ‘bottomRight’, ‘topRight’}
sqref
¶
Values must be of type <class ‘str’>
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
)
[source]
¶
Bases:
openpyxl.descriptors.serialisable.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 {‘pageBreakPreview’, ‘pageLayout’, ‘normal’}
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’>
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'
¶