General Organization

<metadata>
  <metadataTypes/>
  <metadataStrings/>
  <mdxMetadata/>
  <valueMetadata/>
</metadata>

There are four general collections in the metadata part:

  • <metadataTypes -> expresses various application runtime behaviors that apply to a set of metadata.

  • <metadataStrings - >expresses supporting string resources for the metadata part. This includes the connection name to the OLAP cube as well as mdx expressions identifying members and sets.

  • <mdxMetadata> - expresses the tuples in use in this workbook.

  • <valueMetadata -> The block (<bk>) elements stored in <valueMetadata> are referenced from cells in the sheet definition (<vm> on the cell is an index (1-based) to a <bk> element). Each record in a block references additional element collections in the metadata part to define fully the metadata associated with this particular record, and therefore the full metadata definition for a particular cell's value. The records in <valueMetadata> serve as the bridge between the metadata definitions and the cells or values in the sheet.