openpyxl.workbook.parser module¶
-
class
openpyxl.workbook.parser.
ChildSheet
(name=None, sheetId=None, state='visible', id=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
Represents a reference to a worksheet or chartsheet in workbook.xml
It contains the title, order and state but only an indirect reference to the objects themselves.
-
id
¶ Values must be of type <class ‘str’>
-
name
¶ Values must be of type <class ‘str’>
-
sheetId
¶ Values must be of type <class ‘int’>
-
state
¶ Value must be one of {‘hidden’, ‘visible’, ‘veryHidden’}
-
tagname
= 'sheet'¶
-
-
class
openpyxl.workbook.parser.
FileRecoveryProperties
(autoRecover=None, crashSave=None, dataExtractLoad=None, repairLoad=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
autoRecover
¶ Values must be of type <class ‘bool’>
-
crashSave
¶ Values must be of type <class ‘bool’>
-
dataExtractLoad
¶ Values must be of type <class ‘bool’>
-
repairLoad
¶ Values must be of type <class ‘bool’>
-
tagname
= 'fileRecoveryPr'¶
-
-
class
openpyxl.workbook.parser.
PivotCache
(cacheId=None, id=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
cacheId
¶ Values must be of type <class ‘int’>
-
id
¶ Values must be of type <class ‘str’>
-
tagname
= 'pivotCache'¶
-
-
class
openpyxl.workbook.parser.
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)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
Represent the workbook file in the archive
-
Ignorable
¶ Values must be of type <class ‘str’>
-
active
¶
-
bookViews
¶ Wrap a sequence in an containing object
-
calcPr
¶ Values must be of type <class ‘openpyxl.workbook.properties.CalcProperties’>
-
conformance
¶ Value must be one of {‘strict’, ‘transitional’}
-
customWorkbookViews
¶ Wrap a sequence in an containing object
-
definedNames
¶ Values must be of type <class ‘openpyxl.workbook.defined_name.DefinedNameList’>
-
extLst
¶ Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
-
externalReferences
¶ Wrap a sequence in an containing object
-
fileRecoveryPr
¶ Values must be of type <class ‘openpyxl.workbook.parser.FileRecoveryProperties’>
-
fileSharing
¶ Values must be of type <class ‘openpyxl.workbook.protection.FileSharing’>
-
fileVersion
¶ Values must be of type <class ‘openpyxl.workbook.properties.FileVersion’>
-
functionGroups
¶ Values must be of type <class ‘openpyxl.workbook.function_group.FunctionGroupList’>
-
oleSize
¶ Values must be of type <class ‘str’>
-
pivotCaches
¶ Wrap a sequence in an containing object
-
properties
¶ Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve name is desired (eg. “underline” for “u”)
-
sheets
¶ Wrap a sequence in an containing object
-
smartTagPr
¶ Values must be of type <class ‘openpyxl.workbook.smart_tags.SmartTagProperties’>
-
smartTagTypes
¶ Values must be of type <class ‘openpyxl.workbook.smart_tags.SmartTagList’>
-
tagname
= 'workbook'¶
-
webPublishObjects
¶ Values must be of type <class ‘openpyxl.workbook.web.WebPublishObjectList’>
-
webPublishing
¶ Values must be of type <class ‘openpyxl.workbook.web.WebPublishing’>
-
workbookPr
¶ Values must be of type <class ‘openpyxl.workbook.properties.WorkbookProperties’>
-
workbookProtection
¶ Values must be of type <class ‘openpyxl.workbook.protection.WorkbookProtection’>
-