XPath.SetValue Method

Maps the specified XPath object to a ListColumn object or Range collection. If the XPath object has previously been mapped to the ListColumn object or Range collection, the SetValue method sets the properties of the XPath object.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub SetValue ( _
    Map As XmlMap, _
    XPath As String, _
    SelectionNamespace As Object, _
    Repeating As Object _
)
'Usage
Dim instance As XPath
Dim Map As XmlMap
Dim XPath As String
Dim SelectionNamespace As Object
Dim Repeating As Object

instance.SetValue(Map, XPath, SelectionNamespace, _
    Repeating)

void SetValue(
    XmlMap Map,
    string XPath,
    Object SelectionNamespace,
    Object Repeating
)

Parameters

• Map
  Type: Microsoft.Office.Interop.Excel.XmlMap

  Required XmlMap. The schema map that contains information about the XPath object.

• XPath
  Type: System.String

  Required String. A valid XPath statement.

• SelectionNamespace
  Type: System.Object

  Optional Object. Specifies any namespace prefixes used in the XPath argument. This argument can be omitted if the XPath object doesn't contain any prefixes, or if the XPath object uses the Microsoft Excel prefixes.

• Repeating
  Type: System.Object

  Optional Boolean. Specifies whether the XPath object is to be bound to a column in an XML list, or mapped to a single cell. Set to True to bind the XPath object to a column in an XML list.

Remarks

XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

See Also

Reference

XPath Interface

XPath Members

Microsoft.Office.Interop.Excel Namespace