Extract Data from XML

[ppr (Peter Preuss)]

@Htwe_Ko_Ko_Wynn
you can set up like following:

• define with build datatble the datatable structure as needed
• use add datatrow for filling up the datatable
• use datatable e.g. within a write range and write extracted data to Excel

also have a look here to find and alternate approach for retrieval with namespaces and XPath

Reading all the tags of an XML and take them to excel

@Fabian_DDD I do feel that a XPath Approach is better for the retrieval Setting up a NamespaceManager with a Config Datatable: [grafik] for the default namespace with empty prefix “def” is assigne as prefix the retrieval is configured as another datatable (could also be externalize into an excel) [grafik] I did also for a deeper nested element for demo purpose After all preperation it is iterating over the retrieval config and retrieves the specfied values. et voila: [grafik] So this …