# openpyxl.workbook.external_link.external module

class openpyxl.workbook.external_link.external.ExternalBook(sheetNames=None, definedNames=(), sheetDataSet=None, id=None)

  Bases: `Serialisable`

  definedNames

    Wrap a sequence in an containing object

  id

    Values must be of type <class ‘str’>

  sheetDataSet

    Values must be of type <class ‘openpyxl.workbook.external_link.external.ExternalSheetDataSet’>

  sheetNames

    Values must be of type <class ‘openpyxl.workbook.external_link.external.ExternalSheetNames’>

  tagname = 'externalBook'

class openpyxl.workbook.external_link.external.ExternalCell(r=None, t=None, vm=None, v=None)

  Bases: `Serialisable`

  r

    Values must be of type <class ‘str’>

  t

    Value must be one of [‘b’, ‘d’, ‘e’, ‘inlineStr’, ‘n’, ‘s’, ‘str’]

  v

    Values must be of type <class ‘str’>

  vm

    Values must be of type <class ‘int’>

class openpyxl.workbook.external_link.external.ExternalDefinedName(name=None, refersTo=None, sheetId=None)

  Bases: `Serialisable`

  name

    Values must be of type <class ‘str’>

  refersTo

    Values must be of type <class ‘str’>

  sheetId

    Values must be of type <class ‘int’>

  tagname = 'definedName'

class openpyxl.workbook.external_link.external.ExternalLink(externalBook=None, ddeLink=None, oleLink=None, extLst=None)

  Bases: `Serialisable`

  externalBook

    Values must be of type <class ‘openpyxl.workbook.external_link.external.ExternalBook’>

  file_link

    Values must be of type <class ‘openpyxl.packaging.relationship.Relationship’>

  mime_type = 'application/vnd.openxmlformats-officedocument.spreadsheetml.externalLink+xml'
  property path
  tagname = 'externalLink'
  to_tree()

class openpyxl.workbook.external_link.external.ExternalRow(r=(), cell=None)

  Bases: `Serialisable`

  cell

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

  r

    Values must be of type <class ‘int’>

class openpyxl.workbook.external_link.external.ExternalSheetData(sheetId=None, refreshError=None, row=())

  Bases: `Serialisable`

  refreshError

    Values must be of type <class ‘bool’>

  row

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

  sheetId

    Values must be of type <class ‘int’>

class openpyxl.workbook.external_link.external.ExternalSheetDataSet(sheetData=None)

  Bases: `Serialisable`

  sheetData

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

class openpyxl.workbook.external_link.external.ExternalSheetNames(sheetName=())

  Bases: `Serialisable`

  sheetName

    A sequence of primitive types that are stored as a single attribute. “val” is the default attribute

openpyxl.workbook.external_link.external.read_external_link(archive, book_path)