openpyxl.workbook.views module¶
- class openpyxl.workbook.views.BookView(visibility='visible', minimized=False, showHorizontalScroll=True, showVerticalScroll=True, showSheetTabs=True, xWindow=None, yWindow=None, windowWidth=None, windowHeight=None, tabRatio=600, firstSheet=0, activeTab=0, autoFilterDateGrouping=True, extLst=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- activeTab¶
Values must be of type <class ‘int’>
- autoFilterDateGrouping¶
Values must be of type <class ‘bool’>
- extLst¶
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- firstSheet¶
Values must be of type <class ‘int’>
- minimized¶
Values must be of type <class ‘bool’>
- showHorizontalScroll¶
Values must be of type <class ‘bool’>
- showSheetTabs¶
Values must be of type <class ‘bool’>
- showVerticalScroll¶
Values must be of type <class ‘bool’>
- tabRatio¶
Values must be of type <class ‘int’>
- tagname = 'workbookView'¶
- visibility¶
Value must be one of {‘visible’, ‘hidden’, ‘veryHidden’}
- windowHeight¶
Values must be of type <class ‘int’>
- windowWidth¶
Values must be of type <class ‘int’>
- xWindow¶
Values must be of type <class ‘int’>
- yWindow¶
Values must be of type <class ‘int’>
- class openpyxl.workbook.views.CustomWorkbookView(name=None, guid=None, autoUpdate=None, mergeInterval=None, changesSavedWin=None, onlySync=None, personalView=None, includePrintSettings=None, includeHiddenRowCol=None, maximized=None, minimized=None, showHorizontalScroll=None, showVerticalScroll=None, showSheetTabs=None, xWindow=None, yWindow=None, windowWidth=None, windowHeight=None, tabRatio=None, activeSheetId=None, showFormulaBar=None, showStatusbar=None, showComments='commIndicator', showObjects='all', extLst=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- activeSheetId¶
Values must be of type <class ‘int’>
- autoUpdate¶
Values must be of type <class ‘bool’>
- changesSavedWin¶
Values must be of type <class ‘bool’>
- extLst¶
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- guid¶
- includeHiddenRowCol¶
Values must be of type <class ‘bool’>
- includePrintSettings¶
Values must be of type <class ‘bool’>
- maximized¶
Values must be of type <class ‘bool’>
- mergeInterval¶
Values must be of type <class ‘int’>
- minimized¶
Values must be of type <class ‘bool’>
- name¶
Values must be of type <class ‘str’>
- onlySync¶
Values must be of type <class ‘bool’>
- personalView¶
Values must be of type <class ‘bool’>
- showComments¶
Value must be one of {‘commIndAndComment’, ‘commNone’, ‘commIndicator’}
- showFormulaBar¶
Values must be of type <class ‘bool’>
- showHorizontalScroll¶
Values must be of type <class ‘bool’>
- showObjects¶
Value must be one of {‘placeholders’, ‘all’}
- showSheetTabs¶
Values must be of type <class ‘bool’>
- showStatusbar¶
Values must be of type <class ‘bool’>
- showVerticalScroll¶
Values must be of type <class ‘bool’>
- tabRatio¶
Values must be of type <class ‘int’>
- tagname = 'customWorkbookView'¶
- windowHeight¶
Values must be of type <class ‘int’>
- windowWidth¶
Values must be of type <class ‘int’>
- xWindow¶
Values must be of type <class ‘int’>
- yWindow¶
Values must be of type <class ‘int’>
