# openpyxl.drawing.spreadsheet_drawing module

class openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor(pos=None, ext=None, **kw)

  Bases: `_AnchorBase`

  clientData

    Values must be of type <class ‘openpyxl.drawing.spreadsheet_drawing.AnchorClientData’>

  contentPart

    Values must be of type <class ‘str’>

  cxnSp

    Values must be of type <class ‘openpyxl.drawing.connector.Shape’>

  ext

    Values must be of type <class ‘openpyxl.drawing.xdr.XDRPositiveSize2D’>

  graphicFrame

    Values must be of type <class ‘openpyxl.drawing.graphic.GraphicFrame’>

  grpSp

    Values must be of type <class ‘openpyxl.drawing.graphic.GroupShape’>

  pic

    Values must be of type <class ‘openpyxl.drawing.picture.PictureFrame’>

  pos

    Values must be of type <class ‘openpyxl.drawing.xdr.XDRPoint2D’>

  sp

    Values must be of type <class ‘openpyxl.drawing.connector.Shape’>

  tagname = 'absoluteAnchor'

class openpyxl.drawing.spreadsheet_drawing.AnchorClientData(fLocksWithSheet=None, fPrintsWithSheet=None)

  Bases: `Serialisable`

  fLocksWithSheet

    Values must be of type <class ‘bool’>

  fPrintsWithSheet

    Values must be of type <class ‘bool’>

class openpyxl.drawing.spreadsheet_drawing.AnchorMarker(col=0, colOff=0, row=0, rowOff=0)

  Bases: `Serialisable`

  col

    Values must be of type <class ‘int’>

  colOff

    Values must be of type <class ‘int’>

  row

    Values must be of type <class ‘int’>

  rowOff

    Values must be of type <class ‘int’>

  tagname = 'marker'

class openpyxl.drawing.spreadsheet_drawing.OneCellAnchor(_from=None, ext=None, **kw)

  Bases: `_AnchorBase`

  clientData

    Values must be of type <class ‘openpyxl.drawing.spreadsheet_drawing.AnchorClientData’>

  contentPart

    Values must be of type <class ‘str’>

  cxnSp

    Values must be of type <class ‘openpyxl.drawing.connector.Shape’>

  ext

    Values must be of type <class ‘openpyxl.drawing.xdr.XDRPositiveSize2D’>

  graphicFrame

    Values must be of type <class ‘openpyxl.drawing.graphic.GraphicFrame’>

  grpSp

    Values must be of type <class ‘openpyxl.drawing.graphic.GroupShape’>

  pic

    Values must be of type <class ‘openpyxl.drawing.picture.PictureFrame’>

  sp

    Values must be of type <class ‘openpyxl.drawing.connector.Shape’>

  tagname = 'oneCellAnchor'

class openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing(twoCellAnchor=(), oneCellAnchor=(), absoluteAnchor=())

  Bases: `Serialisable`

  PartName = '/xl/drawings/drawing{0}.xml'
  absoluteAnchor

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

  mime_type = 'application/vnd.openxmlformats-officedocument.drawing+xml'
  oneCellAnchor

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

  property path
  tagname = 'wsDr'
  twoCellAnchor

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

class openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor(editAs=None, _from=None, to=None, **kw)

  Bases: `_AnchorBase`

  clientData

    Values must be of type <class ‘openpyxl.drawing.spreadsheet_drawing.AnchorClientData’>

  contentPart

    Values must be of type <class ‘str’>

  cxnSp

    Values must be of type <class ‘openpyxl.drawing.connector.Shape’>

  editAs

    Value must be one of [‘absolute’, ‘oneCell’, ‘twoCell’]

  graphicFrame

    Values must be of type <class ‘openpyxl.drawing.graphic.GraphicFrame’>

  grpSp

    Values must be of type <class ‘openpyxl.drawing.graphic.GroupShape’>

  pic

    Values must be of type <class ‘openpyxl.drawing.picture.PictureFrame’>

  sp

    Values must be of type <class ‘openpyxl.drawing.connector.Shape’>

  tagname = 'twoCellAnchor'
  to

    Values must be of type <class ‘openpyxl.drawing.spreadsheet_drawing.AnchorMarker’>