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'
to_tree()[源代码]
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”>