openpyxl.workbook.external_link.external module
- class openpyxl.workbook.external_link.external.ExternalBook(sheetNames=None, definedNames=(), sheetDataSet=None, id=None)[source]
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)[source]
Bases:
Serialisable- r
Values must be of type <class ‘str’>
- t
Value must be one of {‘n’, ‘e’, ‘str’, ‘d’, ‘s’, ‘inlineStr’, ‘b’}
- 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:
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)[source]
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'
- class openpyxl.workbook.external_link.external.ExternalRow(r=(), cell=None)[source]
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=())[source]
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)[source]
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=())[source]
Bases:
Serialisable- sheetName
A sequence of primitive types that are stored as a single attribute. “val” is the default attribute