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 set([‘topLeft’, ‘bottomLeft’, ‘topRight’, ‘bottomRight’])

state¶: Value must be one of set([‘frozen’, ‘split’, ‘frozenSplit’])

topLeftCell¶: Values must be of type <type ‘basestring’>

xSplit¶: Values must be of type <type ‘float’>

ySplit¶: Values must be of type <type ‘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 <type ‘basestring’>

activeCellId¶: Values must be of type <type ‘long’>

pane¶: Value must be one of set([‘topLeft’, ‘bottomLeft’, ‘topRight’, ‘bottomRight’])

sqref¶: Values must be of type <type ‘basestring’>

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 <type ‘long’>

defaultGridColor¶: Values must be of type <type ‘bool’>

pane¶: Values must be of type <class ‘openpyxl.worksheet.views.Pane’>

rightToLeft¶: Values must be of type <type ‘bool’>

selection¶: A sequence (list or tuple) that may only contain objects of the declared type

showFormulas¶: Values must be of type <type ‘bool’>

showGridLines¶: Values must be of type <type ‘bool’>

showOutlineSymbols¶: Values must be of type <type ‘bool’>

showRowColHeaders¶: Values must be of type <type ‘bool’>

showRuler¶: Values must be of type <type ‘bool’>

showWhiteSpace¶: Values must be of type <type ‘bool’>

showZeros¶: Values must be of type <type ‘bool’>

tabSelected¶: Values must be of type <type ‘bool’>

tagname = 'sheetView'¶

topLeftCell¶: Values must be of type <type ‘basestring’>

view¶: Value must be one of set([‘pageLayout’, ‘pageBreakPreview’, ‘normal’])

windowProtection¶: Values must be of type <type ‘bool’>

workbookViewId¶: Values must be of type <type ‘long’>

zoomScale¶: Values must be of type <type ‘long’>

zoomScaleNormal¶: Values must be of type <type ‘long’>

zoomScalePageLayoutView¶: Values must be of type <type ‘long’>

zoomScaleSheetLayoutView¶: Values must be of type <type ‘long’>

zoomToFit¶: Values must be of type <type ‘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'¶