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