# openpyxl.worksheet.controls module

class openpyxl.worksheet.controls.Control(controlPr=None, shapeId=None, name=None)

  Bases: `Serialisable`

  controlPr

    Values must be of type <class ‘openpyxl.worksheet.controls.ControlProperty’>

  name

    Values must be of type <class ‘str’>

  shapeId

    Values must be of type <class ‘int’>

  tagname = 'control'

class openpyxl.worksheet.controls.ControlProperty(anchor=None, locked=True, defaultSize=True, _print=True, disabled=False, recalcAlways=False, uiObject=False, autoFill=True, autoLine=True, autoPict=True, macro=None, altText=None, linkedCell=None, listFillRange=None, cf='pict', id=None)

  Bases: `Serialisable`

  altText

    Values must be of type <class ‘str’>

  anchor

    Values must be of type <class ‘openpyxl.worksheet.ole.ObjectAnchor’>

  autoFill

    Values must be of type <class ‘bool’>

  autoLine

    Values must be of type <class ‘bool’>

  autoPict

    Values must be of type <class ‘bool’>

  cf

    Values must be of type <class ‘str’>

  defaultSize

    Values must be of type <class ‘bool’>

  disabled

    Values must be of type <class ‘bool’>

  id

    Values must be of type <class ‘str’>

  linkedCell

    Values must be of type <class ‘str’>

  listFillRange

    Values must be of type <class ‘str’>

  locked

    Values must be of type <class ‘bool’>

  macro

    Values must be of type <class ‘str’>

  recalcAlways

    Values must be of type <class ‘bool’>

  tagname = 'controlPr'
  uiObject

    Values must be of type <class ‘bool’>

class openpyxl.worksheet.controls.Controls(control=())

  Bases: `Serialisable`

  control

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

  tagname = 'controls'