(Excel) Traverse Direct Children via FirstChild / NextSibling, or LastChild / PreviousSibling

Demonstrates some ways to iterate over direct child nodes using the FirstChild / NextSibling and LastChild / PreviousSibling methods.

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

<root>
    <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>
</root>

Download Excel Class Modules Chilkat Excel Class Modules

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


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

' Iterate over the direct children by using FirstChild / NextSibling
Set child = xml.FirstChild()

bContinue = xml.LastMethodSuccess
Do While (bContinue = True)
    Debug.Print child.Tag; " : "; child.Content
    Set nextSibling = child.NextSibling()
    bContinue = child.LastMethodSuccess

    Set child = nextSibling
Loop
Debug.Print "-----"

' Do the same, but with FirstChild2 / NextSibling2 to avoid
' creating so many XML object instances:
success = xml.FirstChild2()
Do While success = True
    Debug.Print xml.Tag; " : "; xml.Content
    success = xml.NextSibling2()
Loop
' Revert back up to the parent:
success = xml.GetParent2()

Debug.Print "-----"

' Iterate in reverse order using LastChild / PreviousSibling
Set child = xml.LastChild()
bContinue = xml.LastMethodSuccess
Do While (bContinue = True)
    Debug.Print child.Tag; " : "; child.Content
    Set prevSibling = child.PreviousSibling()
    bContinue = child.LastMethodSuccess

    Set child = prevSibling
Loop
Debug.Print "-----"

' Do the same, but with LastChild2 / PreviousSibling2 to avoid
' creating so many XML object instances:
success = xml.LastChild2()
Do While success = True
    Debug.Print xml.Tag; " : "; xml.Content
    success = xml.PreviousSibling2()
Loop
' Revert back up to the parent:
success = xml.GetParent2()