openpyxl.worksheet.views module¶
- class openpyxl.worksheet.views.Pane(xSplit=None, ySplit=None, topLeftCell=None, activePane='topLeft', state='split')[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- activePane¶
Value must be one of {‘bottomRight’, ‘topLeft’, ‘topRight’, ‘bottomLeft’}
- state¶
Value must be one of {‘frozen’, ‘split’, ‘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')[源代码]¶
基类：
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 {‘bottomRight’, ‘topLeft’, ‘topRight’, ‘bottomLeft’}
- 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)[源代码]¶
基类：
openpyxl.descriptors.serialisable.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 {‘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)[源代码]¶
基类：
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'¶
