# openpyxl.worksheet.scenario module

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

  Bases: `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)

  Bases: `Serialisable`

  comment

    Values must be of type <class ‘str’>

  property 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)

  Bases: `Serialisable`

  append(scenario)
  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'