2.1.7.61 Workbook

An instance of the Workbook (section 2.1.7.61) part type specifies workbook data and references to all of its sheets.

Content type: application/vnd.ms-excel.main

Source relationship: http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument

A package MUST contain exactly one Workbook part, and that part MUST be the target of a relationship in the package relationship part, as specified in section 2.1.

A Workbook part is permitted to have implicit relationships to the following parts specified in this document:

A Workbook part is permitted to have explicit relationships to the following parts specified in this document:

A Workbook part MUST NOT have implicit or explicit relationships to any other part specified in this document.

Record sequence ABNF:

WORKBOOK = BrtBeginBook [BrtFileVersion] [[BrtFileSharingIso] BrtFileSharing] [BrtWbProp] [ACABSPATH] [ACREVISIONPTR] [[BrtBookProtectionIso] BrtBookProtection] [BOOKVIEWS] BUNDLESHS [FNGROUP] [EXTERNALS] *BrtName [BrtCalcProp] [BrtOleSize] *(BrtUserBookView *FRT) [PIVOTCACHEIDS] [BrtWbFactoid] [SMARTTAGTYPES] [BrtWebOpt] *BrtFileRecover [WEBPUBITEMS] [CRERRS] FRTWORKBOOK BrtEndBook

ACABSPATH = BrtACBegin BrtAbsPath15 BrtACEnd

BOOKVIEWS = BrtBeginBookViews 1*([ACUID] BrtBookView *FRT) BrtEndBookViews

BUNDLESHS = BrtBeginBundleShs 1*BrtBundleSh BrtEndBundleShs

FNGROUP = BrtBeginFnGroup *BrtFnGroup BrtEndFnGroup

EXTERNALS = BrtBeginExternals *SUP BrtExternSheet BrtEndExternals

SUP = BrtSupSelf / SUPSAME / SUPADDIN / BrtSupBookSrc

SUPSAME = BrtSupSame *BrtPlaceholderName

SUPADDIN = BrtSupAddin 1*BrtPlaceholderName

PIVOTCACHEIDS = BrtBeginPivotCacheIDs 1*PIVOTCACHEID BrtEndPivotCacheIDs

PIVOTCACHEID = BrtBeginPivotCacheID BrtEndPivotCacheID

SMARTTAGTYPES = BrtBeginSmartTagTypes 1*BrtSmartTagType BrtEndSmartTagTypes

CRERRS = BrtBeginCRErrs *BrtCrashRecErr BrtEndCRErrs

FRTWORKBOOK = [NAMEEXT] [SLICERCACHESPIVOTCACHEIDS] [SLICERCACHEIDS] [WORKBOOKPR14] [DECOUPLEDPIVOTCACHEIDS] [PIVOTTABLEREFS] [TIMELINECACHEPIVOTCACHEIDS] [TIMELINECACHEIDS] [TABLESLICERCACHEIDS] [WORKBOOKPR15] [DATAMODEL] [CALCFEATURES] [EXTERNALLINKSPR] [EXTERNALCODESERVICE] *FRT

NAMEEXT = BrtFRTBegin 1*BrtNameExt BrtFRTEnd

SLICERCACHESPIVOTCACHEIDS = BrtFRTBegin BrtBeginSlicerCachesPivotCacheIDs 1*SLICERCACHESPIVOTCACHEID BrtEndSlicerCachesPivotCacheIDs BrtFRTEnd

SLICERCACHESPIVOTCACHEID = BrtBeginSlicerCachesPivotCacheID BrtEndSlicerCachesPivotCacheID

SLICERCACHEIDS = BrtFRTBegin BrtBeginSlicerCacheIDs 1*SLICERCACHEID BrtEndSlicerCacheIDs BrtFRTEnd

SLICERCACHEID = BrtBeginSlicerCacheID BrtEndSlicerCacheID

WORKBOOKPR14 = BrtFRTBegin BrtWbProp14 BrtFRTEnd

DECOUPLEDPIVOTCACHEIDS = BrtFRTBegin BrtBeginDecoupledPivotCacheIDs 1*BrtDecoupledPivotCacheID BrtEndDecoupledPivotCacheIDs BrtFRTEnd

PIVOTTABLEREFS = BrtFRTBegin BrtBeginPivotTableRefs 1*BrtPivotTableRef BrtEndPivotTableRefs BrtFRTEnd

TIMELINECACHEPIVOTCACHEIDS = BrtFRTBegin BrtBeginTimelineCachePivotCacheIDs 1*TIMELINECACHEPIVOTCACHEID BrtEndTimelineCachePivotCacheIDs BrtFRTEnd

TIMELINECACHEPIVOTCACHEID = BrtTimelineCachePivotCacheID

TIMELINECACHEIDS = BrtFRTBegin BrtBeginTimelineCacheIDs 1*TIMELINECACHEID BrtEndTimelineCacheIDs BrtFRTEnd

TIMELINECACHEID = BrtBeginTimelineCacheID BrtEndTimelineCacheID

TABLESLICERCACHEIDS = BrtFRTBegin BrtTableSlicerCacheIDs 1*TABLESLICERCACHEID BrtFRTEnd

TABLESLICERCACHEID = BrtTableSlicerCacheID

WORKBOOKPR15 = BrtFRTBegin BrtWorkBookPr15 BrtFRTEnd

DATAMODEL = BrtBeginDataModel MODELTABLES MODELRELATIONSHIPS FRTDATAMODEL BrtEndDataModel

MODELTABLES = BrtBeginModelTables 1*BrtModelTable BrtEndModelTables

MODELRELATIONSHIPS = brtBeginModelRelationships 1*brtModelRelationship brtEndModelRelationships

FRTDATAMODEL = [MODELTIMEGROUPINGS] *FRT

MODELTIMEGROUPINGS = BrtFRTBegin brtBeginModelTimeGroupings 1*MODELTIMEGROUPING brtEndModelTimeGroupings BrtFRTEnd

MODELTIMEGROUPING = brtBeginModelTimeGrouping 1*brtModelTimeGroupingCalcCol brtEndModelTimeGrouping

ACREVISIONPTR = BrtACBegin BrtRevisionPtr BrtACEnd

CALCFEATURES = BrtFRTBegin BrtBeginCalcFeatures 1*BrtCalcFeature BrtEndCalcFeatures BrtFRTEnd

EXTERNALLINKSPR = BrtFRTBegin BrtExternalLinksPr BrtFRTEnd

EXTERNALCODESERVICE = BrtFRTBegin BrtExternalCodeService BrtFRTEnd

For ABNF rules not listed here, see Common Productions (section 2.1.8).