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:
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’, ‘veryHidden’, ‘hidden’}
-
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:
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 {‘all’, ‘placeholders’}
-
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’>
-