openpyxl.workbook.views module

class openpyxl.workbook.views.BookView(visibility=None, minimized=None, showHorizontalScroll=None, showVerticalScroll=None, showSheetTabs=None, xWindow=None, yWindow=None, windowWidth=None, windowHeight=None, tabRatio=None, firstSheet=None, activeTab=None, autoFilterDateGrouping=None, extLst=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

activeTab

Values must be of type <type ‘long’>

autoFilterDateGrouping

Values must be of type <type ‘bool’>

extLst

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

firstSheet

Values must be of type <type ‘long’>

minimized

Values must be of type <type ‘bool’>

showHorizontalScroll

Values must be of type <type ‘bool’>

showSheetTabs

Values must be of type <type ‘bool’>

showVerticalScroll

Values must be of type <type ‘bool’>

tabRatio

Values must be of type <type ‘long’>

tagname = 'workbookView'

visibility

Value must be one of set([‘visible’, ‘hidden’, ‘veryHidden’])

windowHeight

Values must be of type <type ‘long’>

windowWidth

Values must be of type <type ‘long’>

xWindow

Values must be of type <type ‘long’>

yWindow

Values must be of type <type ‘long’>

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)

Bases: openpyxl.descriptors.serialisable.Serialisable

activeSheetId

Values must be of type <type ‘long’>

autoUpdate

Values must be of type <type ‘bool’>

changesSavedWin

Values must be of type <type ‘bool’>

extLst

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

guid

includeHiddenRowCol

Values must be of type <type ‘bool’>

includePrintSettings

Values must be of type <type ‘bool’>

maximized

Values must be of type <type ‘bool’>

mergeInterval

Values must be of type <type ‘long’>

minimized

Values must be of type <type ‘bool’>

name

Values must be of type <type ‘basestring’>

onlySync

Values must be of type <type ‘bool’>

personalView

Values must be of type <type ‘bool’>

showComments

Value must be one of set([‘commIndAndComment’, ‘commIndicator’, ‘commNone’])

showFormulaBar

Values must be of type <type ‘bool’>

showHorizontalScroll

Values must be of type <type ‘bool’>

showObjects

Value must be one of set([‘all’, ‘placeholders’])

showSheetTabs

Values must be of type <type ‘bool’>

showStatusbar

Values must be of type <type ‘bool’>

showVerticalScroll

Values must be of type <type ‘bool’>

tabRatio

Values must be of type <type ‘long’>

tagname = 'customWorkbookView'

windowHeight

Values must be of type <type ‘long’>

windowWidth

Values must be of type <type ‘long’>

xWindow

Values must be of type <type ‘long’>

yWindow

Values must be of type <type ‘long’>