(Excel) Methods for Getting Attributes

Demonstrates some methods for getting attribute name/values.

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

<root>
    <car color="black" make="mercedes" model="C350" hp="302" engine="v6" type="sedan">Mercedes Benz C350</car>
</root>

Download Excel Class Modules Chilkat Excel Class Modules

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

' The sample input XML is available at http://www.chilkatsoft.com/data/car.xml
success = xml.LoadXmlFile("car.xml")
If (success <> True) Then
    Debug.Print xml.LastErrorText
    Exit Sub
End If

' Navigate to the "car" node, which is the 1st child:
Set carNode = xml.FirstChild()

' Get the value of the "model" attribute:
Debug.Print "model = "; carNode.GetAttrValue("model")

' Get the value of the "hp" attribute as an integer:
horsepower = carNode.GetAttrValueInt("hp")
Debug.Print "horsepower = "; horsepower

' Iterate over the attributes and show the name/value of each:
numAttr = carNode.NumAttributes

i = 0
Do While i < numAttr
    Debug.Print carNode.GetAttributeName(i); ": "; carNode.GetAttributeValue(i)
    i = i + 1
Loop