To Read Data from XML File using in Microsoft Excel, you need to follow the steps below:
- Create the object of “Microsoft XML Parser” ) (Microsoft.XMLDOM is the COM object of Microsoft XML Parser)
- Load the XML from a specified path.
- Select the tag from the XML file using SelectNodes or SelectSingleNode.
o SelectNodes – Selects a list of nodes matches the Xpath pattern.
o SelectSingleNode – Selects the first XMLNode that matches the pattern.