openpyxl.worksheet.scenario module¶

class openpyxl.worksheet.scenario.InputCells(r=None, deleted=False, undone=False, val=None, numFmtId=None)[source]¶

Bases: openpyxl.descriptors.serialisable.Serialisable

deleted¶: Values must be of type <class ‘bool’>

numFmtId¶: Values must be of type <class ‘int’>

r¶: Values must be of type <class ‘str’>

tagname = 'inputCells'¶

undone¶: Values must be of type <class ‘bool’>

val¶: Values must be of type <class ‘str’>

class openpyxl.worksheet.scenario.Scenario(inputCells=(), name=None, locked=False, hidden=False, count=None, user=None, comment=None)[source]¶

Bases: openpyxl.descriptors.serialisable.Serialisable

comment¶: Values must be of type <class ‘str’>

count¶

hidden¶: Values must be of type <class ‘bool’>

inputCells¶: A sequence (list or tuple) that may only contain objects of the declared type

locked¶: Values must be of type <class ‘bool’>

name¶: Values must be of type <class ‘str’>

tagname = 'scenario'¶

user¶: Values must be of type <class ‘str’>

class openpyxl.worksheet.scenario.ScenarioList(scenario=(), current=None, show=None, sqref=None)[source]¶

Bases: openpyxl.descriptors.serialisable.Serialisable

append(scenario)[source]¶

current¶: Values must be of type <class ‘int’>

scenario¶: A sequence (list or tuple) that may only contain objects of the declared type

show¶: Values must be of type <class ‘int’>

sqref¶: Values must be of type <class ‘openpyxl.worksheet.cell_range.MultiCellRange’>

tagname = 'scenarios'¶