openpyxl.workbook.external_link.external module

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

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)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

r

Values must be of type <class ‘str’>

t

Value must be one of {‘inlineStr’, ‘b’, ‘d’, ‘n’, ‘str’, ‘s’, ‘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)[source]

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'

Bases: openpyxl.descriptors.serialisable.Serialisable

externalBook

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

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

mime_type = 'application/vnd.openxmlformats-officedocument.spreadsheetml.externalLink+xml'
path
tagname = 'externalLink'
to_tree()[source]
class openpyxl.workbook.external_link.external.ExternalRow(r=(), cell=None)[source]

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=())[source]

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)[source]

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=())[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

sheetName

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