openpyxl.workbook.external_link.external module

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

Bases: openpyxl.descriptors.serialisable.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: openpyxl.descriptors.serialisable.Serialisable

r

Values must be of type <class ‘str’>

t

Value must be one of {‘d’, ‘b’, ‘n’, ‘s’, ‘inlineStr’, ‘str’, ‘e’}

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: openpyxl.descriptors.serialisable.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: openpyxl.descriptors.serialisable.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'

path

tagname = 'externalLink'

to_tree()

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

Bases: openpyxl.descriptors.serialisable.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: openpyxl.descriptors.serialisable.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: openpyxl.descriptors.serialisable.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: openpyxl.descriptors.serialisable.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)