How to extact xml data and write in to the Excel file

[ppr (Peter Preuss)]

its depending on what info you want to extract. In case of that it can be brought into a tabular format we add the values to a datatable and write the datatable to Excel.

Also have a look here:

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 …

And more