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:
© 2014 Microsoft