Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

2.1.7.20.5 Worksheet Substream

Office

The Worksheet Substream specifies a worksheet.

Record sequence<8>ABNF:

WORKSHEETCONTENT = [Uncalced] Index GLOBALS PAGESETUP [HeaderFooter] [BACKGROUND] *BIGNAME [PROTECTION] COLUMNS [SCENARIOS] SORTANDFILTER Dimensions [CELLTABLE] OBJECTS *HFPicture *Note *PIVOTVIEW [DCON] 1*WINDOW *CUSTOMVIEW *2SORT [DxGCol] *MergeCells [LRng] *QUERYTABLE [PHONETICINFO] CONDFMTS *HLINK [DVAL] [CodeName] *WebPub *CellWatch [SheetExt] *FEAT *FEAT11 *RECORD12 EOF

WORKSHEET = BOF WORKSHEETCONTENT

SCENARIOS = ScenMan *(SCENARIO *Continue)

SORTANDFILTER = [Sort] [SORTDATA12] [FilterMode] [DropDownObjIds] [AUTOFILTER]

PIVOTVIEW = PIVOTCORE [PIVOTFRT]

PIVOTCORE = SxView *PIVOTVD *2PIVOTIVD [PIVOTPI] *SXDI *PIVOTLI PIVOTEX

PIVOTFRT = PIVOTFRT9 [PIVOTADDL]

PIVOTFRT9 = QsiSXTag [DBQUERYEXT] [PIVOTVIEWEX] SXViewEx9

PIVOTVD = Sxvd *SXVISXVDEx

PIVOTIVD = SxIvd *Continue

PIVOTPI = SXPI *Continue

PIVOTLI = SXLI *Continue

PIVOTEX = SXEx *PIVOTSELECT *PIVOTFORMAT

PIVOTSELECT = SxSelect PIVOTRULE

PIVOTFORMAT = SxFormat PIVOTRULE [SxDXF]

PIVOTVIEWEX = SXViewEx *PIVOTTH *SXPIEx *PIVOTVDTEX

PIVOTTH = SXTH *ContinueFrt

PIVOTVDTEX = SXVDTEx *ContinueFrt

QUERYTABLE = Qsi DBQUERY QsiSXTag DBQUERYEXT [SXADDLQSI] [QSIR] [SORTDATA12]

SXADDLQSI = SXAddl_SXCQsi_SXDId SXADDLDBQUERY *UNKNOWNFRT SXAddl_SXCQsi_SXDEnd

QSIR = Qsir *Qsif

DBQUERY = DbOrParamQry [1*SXString [DbOrParamQry *(SXString DbOrParamQry)]] *SXString

DBQUERYEXT = DBQueryExt [ExtString] *4[OleDbConn *ExtString] [TxtQry *ExtString]

CONDFMTS = *(CONDFMT / CONDFMT12) *(CFEx [CF12])

CONDFMT = CondFmt 1*3CF

CONDFMT12 = CondFmt12 1*CF12

HLINK = HLink [HLinkTooltip]

DVAL = DVal *65534Dv

PIVOTADDL = SXAddl_SXCView_SXDId *Continue_SxaddlSxString [SXAddl_SXCView_SXDVer10Info] [SXAddl_SXCView_SXDVer12Info] *SXADDLCALCMEMBER *SXADDLHIERARCHY *SXADDLFIELD *UNKNOWNFRT [SXAddl_SXCView_SXDTableStyleClient] [SXAddl_SXCView_SXDCompactRwHdr *Continue_SxaddlSxString] [SXAddl_SXCView_SXDCompactColHdr *Continue_SxaddlSxString] [SXAddl_SXCView_SXDVerUpdInv] [SXADDLCONDFMTS] [SXADDLSXFILTERS12] *SXAddl_SXCView_SXDVerUpdInv *SXAddl_SXCView_SXDSXPIIvmb [SXAddl_SXCView_SXDVerUpdInv] SXAddl_SXCView_SXDEnd

SXADDLCALCMEMBER = (SXAddl_SXCView_SXDCalcMember [SXAddl_SXCView_SXDCalcMemString *Continue_SxaddlSxString])

SXADDLCONDFMTS = SXAddl_SXCSXCondFmts_SXDId *SXADDLCONDFMT SXAddl_SXCSXCondFmts_SXDEnd

SXADDLCONDFMT = SXAddl_SXCSXCondFmt_SXDSXCondFmt *SXADDLSXRULE SXAddl_SXCSXCondFmt_SXDEnd

SXADDLAUTOSORT = SXAddl_SXCAutoSort_SXDId SXADDLSXRULE SXAddl_SXCAutoSort_SXDEnd

SXADDLSXRULE = SXAddl_SXCSXrule_SXDIdSXAddl_SXCSXrule_SXDSXrule *SXADDLSXFILT SXAddl_SXCSXrule_SXDEnd

SXADDLSXFILT = SXAddl_SXCSXfilt_SXDIdSXAddl_SXCSXfilt_SXDSXfilt [SXAddl_SXCSXfilt_SXDSXItm] SXAddl_SXCSXfilt_SXDEnd

SXADDLSXFILTERS12 = SXAddl_SXCSXFilters12_SXDId *SXADDLSXFILTER12 SXAddl_SXCSXFilters12_SXDEnd

SXADDLSXFILTER12 = SXAddl_SXCSXFilter12_SXDIdSXAddl_SXCSXFilter12_SXDSXFilter [SXAddl_SXCSXFilter12_SXDCaption *Continue_SxaddlSxString] [SXAddl_SXCSXFilter12_SXDSXFilterDesc *Continue_SxaddlSxString] [SXAddl_SXCSXFilter12_SXDSXFilterValue1 *Continue_SxaddlSxString] [SXAddl_SXCSXFilter12_SXDSXFilterValue2 *Continue_SxaddlSxString] SXAddl_SXCSXFilter12_SXDXlsFilter [SXAddl_SXCSXFilter12_SXDXlsFilterValue1 *Continue_SxaddlSxString] [SXAddl_SXCSXFilter12_SXDXlsFilterValue2 *Continue_SxaddlSxString] SXAddl_SXCSXFilter12_SXDEnd

SXADDLFIELD = [SXAddl_SXCField_SXDId *Continue_SxaddlSxString SXAddl_SXCField_SXDVer10InfoSXAddl_SXCField_SXDEnd] [SXADDLFIELD12]

SXADDLFIELD12 = SXAddl_SXCField12_SXDId *Continue_SxaddlSxString SXAddl_SXCField12_SXDVer12InfoSXAddl_SXCField12_SXDVerUpdInv [SXAddl_SXCField12_SXDMemberCaption *Continue_SxaddlSxString] [SXAddl_SXCField12_SXDAutoshow] [SXAddl_SXCField12_SXDISXTH] [SXADDLAUTOSORT] SXAddl_SXCField12_SXDVerUpdInv *UNKNOWNFRT SXAddl_SXCField12_SXDEnd

SXADDLHIERARCHY = SXAddl_SXCHierarchy_SXDId *Continue_SxaddlSxString *SXAddl_SXCHierarchy_SXDProperty *SXADDLGRPLEVEL [SXAddl_SXCHierarchy_SXDVerUpdInv] *SXAddl_SXCHierarchy_SXDFilterMember [SXAddl_SXCHierarchy_SXDVerUpdInv] [SXAddl_SXCHierarchy_SXDSXSetParentUnique *Continue_SxaddlSxString] [SXAddl_SXCHierarchy_SXDIconSet] [SXAddl_SXCHierarchy_SXDUserCaption *Continue_SxaddlSxString] *UNKNOWNFRT [SXAddl_SXCHierarchy_SXDVerUpdInv] *SXAddl_SXCHierarchy_SXDFilterMember12 [SXAddl_SXCHierarchy_SXDVerUpdInv] [SXAddl_SXCHierarchy_SXDInfo12] [SXAddl_SXCHierarchy_SXDDisplayFolder *Continue_SxaddlSxString] [SXAddl_SXCHierarchy_SXDMeasureGrp *Continue_SxaddlSxString] [SXAddl_SXCHierarchy_SXDParentKPI *Continue_SxaddlSxString] [SXAddl_SXCHierarchy_SXDKPIValue *Continue_SxaddlSxString] [SXAddl_SXCHierarchy_SXDKPIGoal *Continue_SxaddlSxString] [SXAddl_SXCHierarchy_SXDKPIStatus *Continue_SxaddlSxString] [SXAddl_SXCHierarchy_SXDKPITrend *Continue_SxaddlSxString] [SXAddl_SXCHierarchy_SXDKPIWeight *Continue_SxaddlSxString] [SXAddl_SXCHierarchy_SXDKPITime *Continue_SxaddlSxString] SXAddl_SXCHierarchy_SXDEnd

SXADDLGRPLEVEL = SXAddl_SXCGrpLevel_SXDId *Continue_SxaddlSxString SXAddl_SXCGrpLevel_SXDGrpLevelInfo *SXADDLGROUP *UNKNOWNFRT SXAddl_SXCGrpLevel_SXDEnd

SXADDLGROUP = SXAddl_SXCGroup_SXDId *Continue_SxaddlSxString SXAddl_SXCGroup_SXDGrpInfo *SXAddl_SXCGroup_SXDMember *UNKNOWNFRT SXAddl_SXCGroup_SXDEnd

For ABNF rules not listed here, see the Common Productions section.

Show:
© 2015 Microsoft