[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ST_SourceType (PivotCache Type)
This simple type defines the cache types for PivotTables.
This simple type's contents are a restriction of the XML Schema string datatype.
The following are possible enumeration values for this type:
|
Enumeration Value |
Description |
|
consolidation (Consolidation Ranges) |
Indicates that the cache contains data that consolidates ranges. |
|
external (External) |
Indicates that the cache contains data from an external data source. |
|
scenario (Scenario Summary Report) |
Indicates that the cache contains a scenario summary report |
|
worksheet (Worksheet) |
Indicates that the cache contains worksheet data. |
|
Referenced By |
|
cacheSource@type (§3.10.1.7) |
The following XML Schema fragment defines the contents of this simple type:
<simpleType name="ST_SourceType">
<restriction base="xsd:string">
<enumeration value="worksheet"/>
<enumeration value="external"/>
<enumeration value="consolidation"/>
<enumeration value="scenario"/>
</restriction>
</simpleType>