2.1.7.40 PivotTable

  • Article

An instance of the PivotTable part type specifies a PivotTable View (section 2.2.5.3).

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

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

A PivotTable part MUST be the target of an implicit relationship from a worksheet (section 2.1.7.62) part.

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

  • PivotCache Definition (section 2.1.7.38)

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

Record sequence ABNF:

PIVOTTABLE = [ACUID] BrtBeginSXView SXLOCATION [SXVDS] [ISXVDRWS] [SXLIRWS] [ISXVDCOLS] [SXLICOLS] [SXPIS] [SXDIS] [SXFORMATS] [SXCONDFMTS] [SXCRTFORMATS] [SXTHS] BrtTableStyleClient [SXFILTERS] [ISXTHRWS] [ISXTHCOLS] FRTSXVIEW BrtEndSXView

SXLOCATION = BrtBeginSXLocation BrtEndSXLocation

SXVDS = BrtBeginSXVDs 1*SXVD BrtEndSXVDs

ISXVDRWS = BrtBeginISXVDRws BrtEndISXVDRws

SXVD = BrtBeginSXVD [SXVIS] [AUTOSORTSCOPE] [FRTSXVD] BrtEndSXVD

AUTOSORTSCOPE = BrtBeginAutoSortScope PIVOTRULE BrtEndAutoSortScope

SXVIS = BrtBeginSXVIs 1*SXVI BrtEndSXVIs

SXVI = BrtBeginSXVI BrtEndSXVI

FRTSXVD = [BrtFRTBegin BrtSXVD14 BrtFRTEnd] [FRTSXVDIGNORABLE] *FRT

FRTSXVDIGNORABLE = BrtFRTBegin BrtPivotFieldIgnorableAfter BrtFRTEnd

SXLIRWS = BrtBeginSXLIRws 1*SXLI BrtEndSXLIRws

SXLI = BrtBeginSXLI [ISXVIS] BrtEndSXLI

ISXVIS = BrtBeginISXVIs BrtEndISXVIs

ISXVDCOLS = BrtBeginISXVDCols BrtEndISXVDCols

SXLICOLS = BrtBeginSXLICols 1*SXLI BrtEndSXLICols

SXPIS = BrtBeginSXPIs 1*256SXPI BrtEndSXPIs

SXPI = BrtBeginSXPI *FRT BrtEndSXPI

SXDIS = BrtBeginSXDIs 1*SXDI BrtEndSXDIs

SXDI = BrtBeginSXDI FRTSXDI BrtEndSXDI

FRTSXDI = [BrtFRTBegin BrtSXDI14 BrtFRTEnd] [BrtFRTBegin BrtSXDI15 BrtFRTEnd] [FRTDATAFIELDFUTUREINFO] *FRT

FRTDATAFIELDFUTUREINFO = BrtFRTBegin BrtPivotDataFieldFutureData BrtFRTEnd

SXFORMATS = BrtBeginSXFormats 1*SXFORMAT BrtEndSxFormats

SXFORMAT = BrtBeginSXFormat PIVOTRULE *FRT BrtEndSXFormat

SXCONDFMTS = BrtBeginSXCondFmts 1*SXCONDFMT BrtEndSXCondFmts

SXCONDFMT = BrtBeginSXCondFmt PIVOTRULES *FRT BrtEndSXCondFmt

SXCRTFORMATS = BrtBeginSXCrtFormats 1*SXCRTFORMAT BrtEndSXCrtFormats

SXCRTFORMAT = BrtBeginSXCrtFormat PIVOTRULE BrtEndSXCrtFormat

SXTHS = BrtBeginSXTHs 1*SXTH BrtEndSXTHs

SXTH = BrtBeginSXTH [SXTDMPS] *SXTHITEMS FRTSXTH BrtEndSXTH

FRTSXTH = [BrtFRTBegin BrtSXTH14 BrtFRTEnd] [FRTSXTHIGNORABLE] *FRT

FRTSXTHIGNORABLE = BrtFRTBegin BrtPivotHierarchyIgnorableAfter BrtFRTEnd

SXTHITEMS = BrtBeginSXTHItems 1*SXTHITEM BrtEndSXTHItems

SXTHITEM = BrtBeginSXTHItem BrtEndSXTHItem

SXTDMPS = BrtBeginSXTDMPS *SXTDMP BrtEndSXTDMPs

SXTDMP = (BrtSXTDMPOrder / BrtBeginSXTDMP) BrtEndSXTDMP

ISXTHRWS = BrtBeginISXTHRws BrtEndISXTHRws

ISXTHCOLS = BrtBeginISXTHCols BrtEndISXTHCols

SXFILTERS = BrtBeginSXFilters 1*SXFILTER BrtEndSXFilters

SXFILTER = BrtBeginSXFILTER AFILTER FRTSXFILTER BrtEndSXFilter

AFILTER = BrtBeginAFilter 1*PIVOTFILTERCOLUMN BrtEndAFilter

PIVOTFILTERCOLUMN = BrtBeginFilterColumn (BrtDynamicFilter / BrtTop10Filter / CUSTOMFILTERS / PIVOTFILTERS) *FRT

PIVOTFILTERS = BrtBeginFilters *BrtFilter BrtEndFilters

PIVOTRULES = BrtBeginSXRules PIVOTRULE BrtEndSxRules

FRTSXVIEW = [BrtFRTBegin SXVIEW14 BrtFRTEnd] [FRTSXVIEW15] [BrtFRTBegin SXVIEW16 BrtFRTEnd] [FRTSXVIEWVERSIONINGINFO] *FRT

SXVIEW14 = BrtBeginSXView14 [SXCHANGES] [SXEDITS] [SXCONDFMTS14] BrtEndSXView14

SXCHANGE = BrtBeginSXChange BrtSXTupleItems BrtEndSXChange

SXCHANGES = BrtBeginSXChanges 1*2147483647SXCHANGE BrtEndSXChanges

SXEDITS = BrtBeginSXEdits 1*2147483647SXEDIT BrtEndSXEdits

SXEDIT = BrtBeginSXEdit BrtSXTupleItems PIVOTRULE14 BrtEndSXEdit

SXCONDFMTS14 = BrtBeginSXCondFmts14 1*SXCONDFMT14 BrtEndSXCondFmts14

SXCONDFMT14 = BrtBeginSXCondFmt14 PIVOTRULES14 BrtEndSXCondFmt14

PIVOTRULES14 = BrtBeginSXRules14 PIVOTRULE14 BrtEndSXRules14

PIVOTRULE14 = BrtBeginPRule14 [PRFILTERS14] *FRT BrtEndPRule14

PRFILTERS14 = BrtBeginPRFilters14 1*2147483647PRFILTER14 BrtEndPRFilters14

PRFILTER14 = BrtBeginPRFilter14 1*2147483647PRFITEM14 BrtEndPRFilter14

PRFITEM14 = BrtBeginPRFItem14 BrtEndPRFItem14

FRTSXVIEW15 = [PIVOTVALUECELLS15] [PIVOTTABLEUISETTINGS]

PIVOTVALUECELLS15 = BrtFRTBegin BrtBeginSxvcells 1*PIVOTROWS15 BrtEndSxvcells BrtFRTEnd

PIVOTROWS15 = [BrtBeginSxRow 1*PIVOTVALUECELL15 BrtEndSxRow]

PIVOTVALUECELL15 = BrtSxvcellNum / BrtSxvcellStr / BrtSxvcellErr / BrtSxvcellBool / BrtSxvcellDate / BrtSxvcellNil

PIVOTTABLEUISETTINGS = BrtFRTBegin BrtBeginPivotTableUISettings *BrtFieldListActiveItem BrtEndPivotTableUISettings BrtFRTEnd

FRTSXFILTER = [BrtFRTBegin BrtSxFilter15 BrtFRTEnd] *FRT

SXVIEW16 = BrtBeginSXView16 BrtEndSXView16

FRTSXVIEWVERSIONINGINFO = BrtFRTBegin BrtBeginPivotVersionInfo 1*(BrtPivotRequiredFeature / BrtPivotLastUsedFeature) BrtEndPivotVersionInfo BrtFRTEnd

For ABNF rules not listed here, see section 2.1.8.