Workbook.ContentTypeProperties Property (2007 System)
Gets a collection of properties that describe metadata that is stored in the workbook.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property ContentTypeProperties As MetaProperties
'Usage
Dim instance As Workbook
Dim value As MetaProperties
value = instance.ContentTypeProperties
[BrowsableAttribute(false)]
public MetaProperties ContentTypeProperties { get; }
[BrowsableAttribute(false)]
public:
property MetaProperties^ ContentTypeProperties {
MetaProperties^ get ();
}
public function get ContentTypeProperties () : MetaProperties
Property Value
Type: MetaProperties
A Microsoft.Office.Core.MetaProperties collection that contains properties that describe metadata that is stored in the workbook.
Examples
The following code example retrieves the metadata that is associated with the current workbook. The example shows the total number of metadata properties found followed by the name and value of each property. To run this example, you must publish the workbook to a Microsoft Office SharePoint Server 2007 document library and provide a custom metadata property for this workbook. For example, you can add a column in the document library where the workbook is published. For more information about content type properties, please refer to the Microsoft Office SharePoint Server 2007 documentation.
This example is for a document-level customization.
Private Sub GetContentTypeProperties()
Dim props As Office.MetaProperties = Me.ContentTypeProperties
MessageBox.Show("Number of metadata properties found: " _
+ props.Count.ToString())
For Each prop As Office.MetaProperty In props
MessageBox.Show("Metadata property name: " + prop.Name _
+ vbCrLf + "Metadata property value: " _
+ prop.Value.ToString())
Next
End Sub
private void GetContentTypeProperties()
{
Office.MetaProperties props = this.ContentTypeProperties;
MessageBox.Show("Number of metadata properties found: "
+ props.Count.ToString());
foreach (Office.MetaProperty prop in props)
{
MessageBox.Show("Metadata property name: " + prop.Name
+ "\r\nMetadata property value: "
+ prop.Value.ToString());
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.