2.1.7.62 Worksheet
An instance of the Worksheet part type specifies a worksheet.
Content type: application/vnd.ms-excel.worksheet
Source relationship: http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet
A Worksheet part MUST be the target of an explicit relationship from the workbook (section 2.1.7.61) part.
A Worksheet part is permitted to contain implicit relationships to the following parts specified in this document:
Comments (section 2.1.7.8)
PivotTable Definitions (section 2.1.7.40)
Query Table (section 2.1.7.42)
Single Cell Tables (section 2.1.7.46)
Worksheet Binary Index (section 2.1.7.63)
Sort Map (section 2.1.7.49)
A Worksheet part is permitted to contain explicit relationships to the following parts specified in this document:
ActiveX (section 2.1.7.1)
Custom Property (section 2.1.7.12)
Drawings (section 2.1.7.23)
OLE Object (section 2.1.7.36)
OLE Package (section 2.1.7.37)
Hyperlinks (section 2.1.9)
Images (section 2.1.7.30)
Printer Settings (section 2.1.7.41)
Slicers (section 2.1.7.48)
Table Definition (section 2.1.7.51)
VML Drawings (section 2.1.7.59)
Timelines (section 2.1.7.54)
A Worksheet part MUST NOT have implicit or explicit relationships to any other part specified in this document.
Record sequence ABNF:
WORKSHEET = BrtBeginSheet [BrtWsProp] [BrtWsDim] [WSVIEWS2] [WSFMTINFO] *COLINFOS CELLTABLE [BrtSheetCalcProp] [[BrtSheetProtectionIso] BrtSheetProtection] *([BrtRangeProtectionIso] BrtRangeProtection) [SCENMAN] [AUTOFILTER] [SORTSTATE] [DCON] [USERSHVIEWS] [MERGECELLS] [BrtPhoneticInfo] *CONDITIONALFORMATTING [DVALS] *([ACUID] BrtHLink) [BrtPrintOptions] [BrtMargins] [BrtPageSetup] [HEADERFOOTER] [RWBRK] [COLBRK] *BrtBigName [CELLWATCHES] [IGNOREECS] [SMARTTAGS] [BrtDrawing] [BrtLegacyDrawing] [BrtLegacyDrawingHF] [BrtBkHim] [OLEOBJECTS] [ACTIVEXCONTROLS] [WEBPUBITEMS] [LISTPARTS] FRTWORKSHEET [ACUID] BrtEndSheet
WSVIEWS2 = BrtBeginWsViews 1*WSVIEW2 *FRT BrtEndWsViews
WSVIEW2 = [ACUID] BrtBeginWsView [BrtPane] *4BrtSel *4SXSELECT *FRT BrtEndWsView
SXSELECT = BrtBeginSxSelect PIVOTRULE BrtEndSxSelect
SCENMAN = BrtBeginScenMan 1*32767SCT BrtEndScenMan
SCT = BrtBeginSct 1*32BrtSlc BrtEndSct
MERGECELLS = BrtBeginMergeCells 1*BrtMergeCell BrtEndMergeCells
DVALS = BrtBeginDVals 1*65534([ACUID] [ACDVALLIST] BrtDVal) BrtEndDVals
CELLWATCHES = BrtBeginCellWatches 1*BrtCellWatch BrtEndCellWatches
IGNOREECS = BrtBeginCellIgnoreECs 1*BrtCellIgnoreEC *FRT BrtEndCellIgnoreECs
SMARTTAGS = BrtBeginSmartTags 1*CELLSMARTTAGS BrtEndSmartTags
CELLSMARTTAGS = BrtBeginCellSmartTags 1*CELLSMARTTAG BrtEndCellSmartTags
CELLSMARTTAG = BrtBeginCellSmartTag *BrtCellSmartTagProperty BrtEndCellSmartTag
ACTIVEXCONTROLS = BrtBeginActiveXControls 1*BrtActiveX BrtEndActiveXControls
LISTPARTS = BrtBeginListParts *BrtListPart BrtEndListParts
CONDITIONALFORMATTINGS = BrtFRTBegin BrtBeginConditionalFormattings *2147483647CONDITIONALFORMATTING14 BrtEndConditionalFormattings BrtFRTEnd
DVALS14 = BrtFRTBegin BrtBeginDVals14 1*65534([ACDVALLIST] BrtDVal14) BrtEndDVals14 BrtFRTEnd
SPARKLINEGROUPS = BrtFRTBegin BrtBeginSparklineGroups 1*2147483647SPARKLINEGROUP BrtEndSparklineGroups BrtFRTEnd
SPARKLINEGROUP = BrtBeginSparklineGroup [ACUID] BrtBeginSparklines 1*2147483647BrtSparkline BrtEndSparklines BrtEndSparklineGroup
SLICERSEX = BrtFRTBegin BrtBeginSlicersEx SLICEREX BrtEndSlicersEx BrtFRTEnd
SLICEREX = BrtBeginSlicerEx BrtEndSlicerEx
TABLESLICERSEX = BrtFRTBegin BrtBeginSlicersEx TABLESLICEREX BrtEndSlicersEx BrtFRTEnd
TABLESLICEREX = BrtBeginSlicerEx BrtEndSlicerEx
RANGEPROTECTION14 = BrtFRTBegin 1*([BrtRangeProtectionIso14] BrtRangeProtection14) BrtFRTEnd
IGNOREECS14 = BrtFRTBegin BrtBeginCellIgnoreECs14 1*BrtCellIgnoreEC14 BrtEndCellIgnoreECs14 BrtFRTEnd
ACDVALLIST = BrtACBegin BrtDValList BrtACEnd
TIMELINESEX = BrtFRTBegin BrtBeginTimelinesEx TIMELINEEX BrtEndTimelinesEx BrtFRTEnd
TIMELINEEX = BrtBeginTimelineEx BrtEndTimelineEx
WEBEXTENSIONS = BrtFRTBegin BrtBeginWebExtensions 1*BrtWebExtension BrtEndWebExtensions BrtFRTEnd
For ABNF rules not listed here, see section 2.1.8.