openpyxl.worksheet.views模块¶
- 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 {'topRight', 'bottomRight', 'bottomLeft', 'topLeft'}
- state¶
Value must be one of {'split', 'frozenSplit', 'frozen'}
- topLeftCell¶
值的类型必须小于class'str'>
- xSplit¶
值的类型必须小于class“float”>
- ySplit¶
值的类型必须小于class“float”>
- class openpyxl.worksheet.views.Selection(pane=None, activeCell='A1', activeCellId=None, sqref='A1')[源代码]¶
基类:
openpyxl.descriptors.serialisable.Serialisable
- activeCell¶
值的类型必须小于class'str'>
- activeCellId¶
值的类型必须小于class“int”>
- pane¶
Value must be one of {'topRight', 'bottomRight', 'bottomLeft', 'topLeft'}
- sqref¶
值的类型必须小于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.Serialisable
有关此工作表可见部分的信息。
- colorId¶
值的类型必须小于class“int”>
- defaultGridColor¶
值的类型必须小于class'bool'>
- pane¶
值的类型必须小于class“openpyxl.worksheet.views.pane”>
- rightToLeft¶
值的类型必须小于class'bool'>
- selection¶
只能包含声明类型的对象的序列(列表或元组)
- showFormulas¶
值的类型必须小于class'bool'>
- showGridLines¶
值的类型必须小于class'bool'>
- showOutlineSymbols¶
值的类型必须小于class'bool'>
- showRowColHeaders¶
值的类型必须小于class'bool'>
- showRuler¶
值的类型必须小于class'bool'>
- showWhiteSpace¶
值的类型必须小于class'bool'>
- showZeros¶
值的类型必须小于class'bool'>
- tabSelected¶
值的类型必须小于class'bool'>
- tagname = 'sheetView'¶
- topLeftCell¶
值的类型必须小于class'str'>
- view¶
Value must be one of {'pageBreakPreview', 'pageLayout', 'normal'}
- windowProtection¶
值的类型必须小于class'bool'>
- workbookViewId¶
值的类型必须小于class“int”>
- zoomScale¶
值的类型必须小于class“int”>
- zoomScaleNormal¶
值的类型必须小于class“int”>
- zoomScalePageLayoutView¶
值的类型必须小于class“int”>
- zoomScaleSheetLayoutView¶
值的类型必须小于class“int”>
- zoomToFit¶
值的类型必须小于class'bool'>