fastpyxl.packaging.workbook module

class fastpyxl.packaging.workbook.ChildSheet(name=None, sheetId=None, state='visible', id=None)

Bases: 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: str | None

name: str | None

sheetId: int | None

state: str | None

tagname = 'sheet'

class fastpyxl.packaging.workbook.FileRecoveryProperties(autoRecover=None, crashSave=None, dataExtractLoad=None, repairLoad=None)

Bases: Serialisable

autoRecover: bool | None

crashSave: bool | None

dataExtractLoad: bool | None

repairLoad: bool | None

tagname = 'fileRecoveryPr'

class fastpyxl.packaging.workbook.PivotCache(cacheId=None, id=None)

Bases: Serialisable

cacheId: int | None

id: str | None

tagname = 'pivotCache'

class fastpyxl.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)

Bases: Serialisable

Represent the workbook file in the archive

Ignorable: str | None

property active

bookViews: list[BookView]

calcPr: CalcProperties | None

conformance: str | None

customWorkbookViews: list[CustomWorkbookView]

definedNames: DefinedNameList | None

extLst: ExtensionList | None

externalReferences: list[ExternalReference]

fileRecoveryPr: FileRecoveryProperties | None

fileSharing: FileSharing | None

fileVersion: FileVersion | None

functionGroups: FunctionGroupList | None

oleSize: str | None

pivotCaches: list[PivotCache]

property properties

sheets: list[ChildSheet]

smartTagPr: SmartTagProperties | None

smartTagTypes: SmartTagList | None

tagname = 'workbook'

to_tree(tagname=None, idx=None, namespace=None)

webPublishObjects: WebPublishObjectList | None

webPublishing: WebPublishing | None

workbookPr: WorkbookProperties | None

workbookProtection: WorkbookProtection | None

xml_order = ('fileVersion', 'fileSharing', 'workbookPr', 'workbookProtection', 'bookViews', 'sheets', 'functionGroups', 'externalReferences', 'definedNames', 'calcPr', 'oleSize', 'customWorkbookViews', 'pivotCaches', 'smartTagPr', 'smartTagTypes', 'webPublishing', 'fileRecoveryPr', 'webPublishObjects')