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:

A Worksheet part is permitted to contain explicit relationships to the following parts specified in this document:

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

HLINKS = 1*([ACUID] BrtHLink)

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

FRTWORKSHEET = [CONDITIONALFORMATTINGS] [DVALS14] [SPARKLINEGROUPS] [SLICERSEX] [RANGEPROTECTION14] [IGNOREECS14] [WEBEXTENSIONS] [TABLESLICERSEX] [TIMELINESEX] *FRT

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.