(Excel) XML SearchForAttribute Method

Demonstrates the SearchForAttribute method.

The input XML, available at http://www.chilkatsoft.com/data/fruitSearch.xml, is this:

<root>
    <searchRoot>
        <fruit color="red">apple</fruit>
        <fruit color="green">pear</fruit>
        <veg color="orange">carrot</veg>
        <meat animal="cow">beef</meat>
        <xyz>
            <fruit color="blue">blueberry</fruit>
            <veg color="green">broccoli</veg>
        </xyz>
        <fruit color="purple">grape</fruit>
        <cheese color="yellow">cheddar</cheese>
    </searchRoot>
    <fruit color="red">strawberry</fruit>
    <fruit color="orange">peach</fruit>
</root>

Download Excel Class Modules Chilkat Excel Class Modules

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml


success = xml.LoadXmlFile("qa_data/xml/fruitSearch.xml")
If (success <> True) Then
    Debug.Print xml.LastErrorText
    Exit Sub
End If

' Search the sub-tree rooted at "searchRoot"
Set xSearchRoot = xml.FindChild("searchRoot")
If (xml.LastMethodSuccess = False) Then
    Debug.Print "searchRoot not found, searching from root."
    Set xSearchRoot = xml.GetRoot()
End If

' Search for all "fruit" nodes having a color attribute
' where the name of the color ends in "e"
Set xBeginAfter = xSearchRoot.GetSelf()
Set xFound = xSearchRoot.SearchForAttribute(xBeginAfter,"fruit","color","*e")
Do While (xSearchRoot.LastMethodSuccess = True)

    Debug.Print xFound.Content; ": "; xFound.GetAttrValue("color")

    Set xBeginAfter = xFound
    Set xFound = xSearchRoot.SearchForAttribute(xBeginAfter,"fruit","color","*e")
Loop

' The correct output is:
' grape: purple
' blueberry: blue

Debug.Print "--------------------------"

' ---------------------------------------------------------------------------------
' Now do the same, but instead use SearchForAttribute2
' which updates the internal reference of the caller instead
' of returning the found node.

Set xBeginAfter = xSearchRoot.GetSelf()
Set xSearch = xSearchRoot.GetSelf()

success = xSearch.SearchForAttribute2(xBeginAfter,"fruit","color","*e")
Do While success = True

    Debug.Print xSearch.Content; ": "; xSearch.GetAttrValue("color")

    ' Copy the internal references so that the next search
    ' begins after the found node.
    xBeginAfter.CopyRef xSearch
    xSearch.CopyRef xSearchRoot

    success = xSearch.SearchForAttribute2(xBeginAfter,"fruit","color","*e")
Loop