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

Hi @all

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

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

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

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:

And more