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

[chaithanya_kumar_M]

Hi @all

Please check the zip file and help me to solve this
Downloadxml.7z (652.9 KB)

[ppr (Peter Preuss)]

@chaithanya_kumar_M
the XML are defining namespaces. Have a look below on how we can handle:

Read from xml file

@Zlotzky Setting up the quick prototype: Variables: Handling Namespace: [grafik] ElementNames to Extract - Prototype reduced set: [grafik] Read In XML [grafik] Ensure: [grafik] Retrieval of private contact element (mandatory use of the Namespace within the name) [grafik] iterating over the list of elmentnames (ExtractNames) and reading element value: [grafik] Logs: [grafik] Find starter help here: Zlotzky.xaml (6.3 KB)

[chaithanya_kumar_M]

Hi @ppr

Am able to retrieve the data from xml, Now my task is what ever the data i have retrieved i need to add in to excel file
Note: am reading the multiple files so if onefile complete then it should start from next 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