且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用VBA选择单个节点XML对象

更新时间:2023-11-24 19:29:16

您只需使用/gfi_message/body/data/node/field [@ name ='Spot'] 即可找到该特定节点> xpath

You can find that particular node by simply using /gfi_message/body/data/node/field[@name='Spot'] xpath

注意-避免在xpath中使用//,因为它很慢.

Note - Avoid using // in xpaths as it is slow.

示例代码

Set objXML = CreateObject("MSXML2.DOMDocument.6.0")
With objXML
    .SetProperty "SelectionLanguage", "XPath"
    .ResolveExternals = True
    .ValidateOnParse = True
    .Async = False
    .Load "C:\Users\pankaj.jaju\Desktop\test2.xml"
End With

Set objNode= objXML.SelectSingleNode("/gfi_message/body/data/node/field[@name='Spot']")
Msgbox objNode.XML

输出