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)[source]
Bases:
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 {‘hidden’, ‘veryHidden’, ‘visible’}
- 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)[source]
Bases:
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 {‘commIndicator’, ‘commIndAndComment’, ‘commNone’}
- 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’>