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.