Office Open XML
L Annex L. (informative) Primer
L.2 Introduction to SpreadsheetML
L.2.2 Sheets
L.2.8.3.2.3 Metadata Strings

L.2.8.3.2.3 Metadata Strings

This collection is a set of string resources for the metadata part. Most follow the format of an MDX expression. Connection names (to OLAP cubes) are also expressed here.

<metadataStrings count="12">
  <s v="xlextdat9 Adventure Works"/>
  <s v="[Measures].[Internet Sales Amount]"/>
  <s v="[Date].[Calendar].[Calendar Year].&amp;[2003]"/>
  <s v="[Date].[Calendar].[Calendar Year].&amp;[2004]"/>
  <s v="[Product].[Product Categories].[All Products]"/>
  <s v="[Customer].[Customer Geography].[All Customers].children"/>
  <s v="[Customer].[Customer Geography].[Country].&amp;[Australia]"/>
  <s v="[Customer].[Customer Geography].[Country].&amp;
    [United States]"/>
  <s v="[Customer].[Customer Geography].[Country].&amp;
    [United Kingdom]"/>
  <s v="[Customer].[Customer Geography].[Country].&amp;[Germany]"/>
  <s v="[Customer].[Customer Geography].[Country].&amp;[France]"/>
  <s v="[Customer].[Customer Geography].[Country].&amp;[Canada]"/>
</metadataStrings>

Regarding metadataStrings:

count indicates the number of strings in the collection.
s is the string container element
v is the string value itself.
Last updated on
L.2.8.3 ExampleL.2.9.3.3 XML - pivotCacheRecords part