Name

xpath.SetValue(Map, XPath, [SelectionNamespace], [Repeating])

Synopsis

Maps a node from an XML map to a list column or range. Use SetValue when creating new lists or ranges from XML maps.

Argument

Settings

Map

The XmlMap object to use for the mapping.

XPath

A string containing the XPath of the node to map to the list column or range.

SelectionNamespace

A string containing the namespace prefix used in the preceding XPath. The namespace takes the form "xmlns: prefix= ' namespace '".

Repeating

True indicates the mapping repeats; False indicates the mapping is to a single cell in a range. Must be True or omitted when mapping to a list column.

The SelectionNamespace argument is required only if the specified XPath uses a different namespace from that shown in the XML map. For example, the Orders_Map sample includes the namespace prefix ns1. Since this namespace is defined in the workbook, you can omit the SelectionNamespace argument, as shown here:

Set xmap = ThisWorkbook.XmlMaps("Orders_Map")
 [A10].XPath.SetValue xmap, _
  "/ns1:Orders/ns1:Order/ns1:BillTo/ns1:Address/ns1:Street1"

If, however, the XPath uses a different prefix, you must define that new namespace prefix using SelectionNamespace, as shown here:

[A10].XPath.SetValue xmap, _
  "/ord:Orders/ord:Order/ns1:BillTo/ord:Address/ord:Street1", _
  "xmlns:ord='http://www.mstrainingkits.com'"

Use the Repeating argument to map a repeating node to a single cell. For example, the preceding code creates a list column at cell ...

Get Programming Excel with VBA and .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.