WorkbookBase.XmlNamespaces Property
Gets an Microsoft.Office.Interop.Excel.XmlNamespaces collection that represents the XML namespaces contained in the workbook.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public ReadOnly Property XmlNamespaces As XmlNamespaces
public XmlNamespaces XmlNamespaces { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.XmlNamespaces
An Microsoft.Office.Interop.Excel.XmlNamespaces collection that represents the XML namespaces contained in the workbook.
Examples
The following code example uses the XmlNamespaces property to write the Uniform Resource Identifier (URI) for each XmlNamespace in the workbook to column A of worksheet Sheet1.
This example is for a document-level customization.
Private Sub DisplayXmlNamespaceURI()
If Me.XmlNamespaces.Count = 0 Then
MsgBox("The current workbook does not have " & _
"any XML namespaces.")
Else
Dim i As Integer
For i = 0 To (Me.XmlNamespaces.Count)
Globals.Sheet1.Range("A" & i).Value2 = _
Me.XmlNamespaces(i).Uri
Next i
End If
End Sub
private void DisplayXmlNamespaceURI()
{
if (this.XmlNamespaces.Count == 0)
{
MessageBox.Show("The current workbook does not have " +
"any XML namespaces.");
}
else
{
for (int i = 0; i < this.XmlNamespaces.Count; i++)
{
Globals.Sheet1.Range["A" + i].Value2 =
(this.XmlNamespaces[i].Uri);
}
}
}
.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.