openpyxl.packaging.workbook模块¶
- class openpyxl.packaging.workbook.ChildSheet(name=None, sheetId=None, state='visible', id=None)[源代码]¶
基类:
openpyxl.descriptors.serialisable.Serialisable
表示对workbook.xml中的工作表或图表表的引用
它包含标题、顺序和状态,但仅间接引用对象本身。
- id¶
值的类型必须小于class'str'>
- name¶
值的类型必须小于class'str'>
- sheetId¶
值的类型必须小于class“int”>
- state¶
Value must be one of {'hidden', 'visible', 'veryHidden'}
- tagname = 'sheet'¶
- class openpyxl.packaging.workbook.FileRecoveryProperties(autoRecover=None, crashSave=None, dataExtractLoad=None, repairLoad=None)[源代码]¶
基类:
openpyxl.descriptors.serialisable.Serialisable
- autoRecover¶
值的类型必须小于class'bool'>
- crashSave¶
值的类型必须小于class'bool'>
- dataExtractLoad¶
值的类型必须小于class'bool'>
- repairLoad¶
值的类型必须小于class'bool'>
- tagname = 'fileRecoveryPr'¶
- class openpyxl.packaging.workbook.PivotCache(cacheId=None, id=None)[源代码]¶
基类:
openpyxl.descriptors.serialisable.Serialisable
- cacheId¶
值的类型必须小于class“int”>
- id¶
值的类型必须小于class'str'>
- tagname = 'pivotCache'¶
- class openpyxl.packaging.workbook.WorkbookPackage(conformance=None, fileVersion=None, fileSharing=None, workbookPr=None, workbookProtection=None, bookViews=(), sheets=(), functionGroups=None, externalReferences=(), definedNames=None, calcPr=None, oleSize=None, customWorkbookViews=(), pivotCaches=(), smartTagPr=None, smartTagTypes=None, webPublishing=None, fileRecoveryPr=None, webPublishObjects=None, extLst=None, Ignorable=None)[源代码]¶
基类:
openpyxl.descriptors.serialisable.Serialisable
表示存档中的工作簿文件
- Ignorable¶
值的类型必须小于class'str'>
- property active¶
- bookViews¶
在包含对象中包装序列
- calcPr¶
值的类型必须小于class“openpyxl.workbook.properties.calcproperties”>
- conformance¶
Value must be one of {'transitional', 'strict'}
- customWorkbookViews¶
在包含对象中包装序列
- definedNames¶
值的类型必须为<class'openpyxl.workbook.defined撏name.definedNameList'>
- extLst¶
值的类型必须为<class'openpyxl.descriptors.excel.extensionList'>
- externalReferences¶
在包含对象中包装序列
- fileRecoveryPr¶
值的类型必须小于class“openpyxl.packaging.workbook.filerecoveryproperties”>
- fileSharing¶
值的类型必须为<class'openpyxl.workbook.protection.filesharing'>
- fileVersion¶
值的类型必须小于class“openpyxl.workbook.properties.fileversion”>
- functionGroups¶
值的类型必须是<class'openpyxl.workbook.function_group.functiongrouplist'>
- oleSize¶
值的类型必须小于class'str'>
- pivotCaches¶
在包含对象中包装序列
- property pivot_caches¶
获取PivotCache对象
- properties¶
在python中不允许或混淆所需的属性名(例如“type”)或需要更具描述性的名称(例如“u”的“underline”)时,可以使用别名。
- sheets¶
在包含对象中包装序列
- smartTagPr¶
值的类型必须是<class'openpyxl.workbook.smart_tags.smarttagproperties'>
- smartTagTypes¶
值的类型必须是<class'openpyxl.workbook.smart_tags.smarttaglist'>
- tagname = 'workbook'¶
- webPublishObjects¶
值的类型必须小于class“openpyxl.workbook.web.webPublishObjectList”>
- webPublishing¶
值的类型必须小于class“openpyxl.workbook.web.webpublishing”>
- workbookPr¶
值的类型必须小于class“openpyxl.workbook.properties.workbook properties”>
- workbookProtection¶
值的类型必须小于class“openpyxl.workbook.protection.workbook protection”>