openpyxl.worksheet.views module
- class openpyxl.worksheet.views.Pane(xSplit=None, ySplit=None, topLeftCell=None, activePane='topLeft', state='split')[source]
Bases:
Serialisable- activePane
Value must be one of {‘topLeft’, ‘bottomLeft’, ‘bottomRight’, ‘topRight’}
- state
Value must be one of {‘split’, ‘frozenSplit’, ‘frozen’}
- 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:
Serialisable- activeCell
Values must be of type <class ‘str’>
- activeCellId
Values must be of type <class ‘int’>
- pane
Value must be one of {‘topLeft’, ‘bottomLeft’, ‘bottomRight’, ‘topRight’}
- 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:
SerialisableInformation 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 {‘normal’, ‘pageBreakPreview’, ‘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:
Serialisable- property active
Returns the first sheet view which is assumed to be active
- 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'