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'¶
- class openpyxl.workbook.external_link.external.ExternalLink(externalBook=None, ddeLink=None, oleLink=None, extLst=None)[源代码]¶
基类:
openpyxl.descriptors.serialisable.Serialisable
- externalBook¶
值的类型必须是<class'openpyxl.workbook.external_link.external.externalbook'>
- file_link¶
值的类型必须小于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)[源代码]¶
基类:
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”是默认属性