openpyxl.workbook.externalu link.external模块

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

基类:openpyxl.descriptors.serialisable.Serialisable

definedNames

在包含对象中包装序列

id

值的类型必须小于class'str'>

sheetDataSet

值的类型必须为<class'openpyxl.workbook.external_link.external.externalSheetDataSet'>

sheetNames

值的类型必须是<class'openpyxl.workbook.external_link.external.externalSheetNames'>

tagname = 'externalBook'
class openpyxl.workbook.external_link.external.ExternalCell(r=None, t=None, vm=None, v=None)[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

r

值的类型必须小于class'str'>

t

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

v

值的类型必须小于class'str'>

vm

值的类型必须小于class“int”>

class openpyxl.workbook.external_link.external.ExternalDefinedName(name=None, refersTo=None, sheetId=None)[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

name

值的类型必须小于class'str'>

refersTo

值的类型必须小于class'str'>

sheetId

值的类型必须小于class“int”>

tagname = 'definedName'

基类:openpyxl.descriptors.serialisable.Serialisable

externalBook

值的类型必须是<class'openpyxl.workbook.external_link.external.externalbook'>

值的类型必须小于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)[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

cell

只能包含声明类型的对象的序列(列表或元组)

r

值的类型必须小于class“int”>

class openpyxl.workbook.external_link.external.ExternalSheetData(sheetId=None, refreshError=None, row=())[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

refreshError

值的类型必须小于class'bool'>

row

只能包含声明类型的对象的序列(列表或元组)

sheetId

值的类型必须小于class“int”>

class openpyxl.workbook.external_link.external.ExternalSheetDataSet(sheetData=None)[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

sheetData

只能包含声明类型的对象的序列(列表或元组)

class openpyxl.workbook.external_link.external.ExternalSheetNames(sheetName=())[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

sheetName

作为单个属性存储的基元类型序列。”“val”是默认属性