Excel Made Easy

Vba xml dom nodes in Excel

In the previous chapter, we saw the basics of DOM or Document Object Model.

The DOM specifies the Logical structure of the XML document.

In this chapter, we will explore the DOM Nodes in detail.

What is a Node?

According to the Document Object Model of XML, everything in a XML file is a node.

The entire document is a document node.

Every XML element is an element node.

The text in the XML elements are text nodes.

Every attribute is an attribute node.

Comments are comment nodes.

Consider the following XML document as an example.

  1. <?xml�version="1.0"�encoding="UTF-8"?>
  2. <Agencies>
  3. <Contractor>

    4. excel vba xml dom nodes

  4. ����<name>Bhandhan Servicing</name>
  5. ����<service_type>Marriage arrangement</service_type>
  6. ����<description>
  7. All Services related to marriages
  8. ���</description>
  9. </Contractor>
  10. <Contractor>
  11. ����<name>VS functions</name>
  12. ����<service_type>Party arrangements</service_type>
  13. ����<description>
  14. Official get together, birthday party arrangements.
  15. ����</description>
  16. </Contractor>
  17. <Contractor>
  18. ����<name>Swami services</name>
  19. ����<service_type>Spiritual Services</service_type>
  20. ����<description>
  21. ��� Ganapathi homam, New home poojas performed.
  22. ����</description>
  23. </Contractor>
  24. <Contractor>
  25. ����<name>B Plus Services</name>
  26. ����<service_type>Blood Donation</service_type>
  27. ����<description>
  28. ��� Conducts Blood donation camps, organizing emergency blood donation
  29. ����</description>
  30. ����<calories>600</calories>
  31. </Contractor>
  32. </Agencies>

With reference to the above XML document, we will explore the various nodes discussed above.

<Agencies> is the root node of the document.

<Contractor> is the child node of the root node <bookstore>

<Contractor> node holds the child nodes: <name>, <service_type> and <description>.

The child nodes contain one text node each in every Contrator nodes and its child nodes.

 

You can find similar Excel Questions and Answer hereunder

1) Is there a way to get a log value of a number using Excel?

2) I have several pictures that are misaligned - manually aligning them is very laborious. Is there an automatic alignment option?

3) How can I dynamically add a hyperlink using VBA?

4) What is the xml group in the developer tab in Excel

5) How to convert a number or string into a data with the cdate function

6) Every time I make an update to my Worksheet, I would like to add a timestamp to my Last Updated field. In Excel, how can I do that in Worksheet?

7) How can I enter a cent symbol in a cell?

8) Want to use SQL to manipulate a database. Here some basic explanation to get you started.

9) How can I enter a cent symbol in a cell?

10) How do I enter a formula in a cell using VBA (using Absolute Reference)?

 

Here the previous and next chapter

Excel Made Easy was founded in 2002. Excel Made Easy is a service to people looking to learn Microsoft Excel or any other spreadsheet SW on the market.

We endeavor to provide the best service and support and to respond quickly to your questions.

Excel Made Easy is a proud sponsor of Dismantle-It.com the site that shows you the belly of your daily objects, Poupounette.com the site of cars loving cat and PowerPointMadeEasy.com the world top reference for PowerPoint Presentations questions and Pet Cemetery Online a site dedicated to your loving Pets.