So I have an attached XML document. XML is my least favourite plus this looks formatted in a completely different way to any others I have seen. If I open it in excel I would like the below 2 columns [image] The strange part that I cannot get my head around is when imported to excel the ns1 part…

[image] rmorgan: ow do we incorporate the element retrieval method in a for each loop as already mentioned above and derivable to: [grafik] xnsNs2 = xDoc.Root.GetNamespaceOfPrefix("ns2") item = xDoc.Root.Descendants(xnsNs2 + "GoodsServicesDescriptionText") having output: [grafik] RnD …

XML Like I've Never seen before

Help Studio

ppr (Peter Preuss) April 17, 2024, 11:36am 11

Perfect, so the topic can be closed by marking the solving post
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

Topic		Replies	Views
Save in XML format Studio datatable , uiautomation , activities , string , question , xml	3	1710	June 29, 2020
Import XML to Excel Help excel , activities	11	14743	February 8, 2019
Sample template to extract data from xml file and write it in excel Help uiautomation , studio , question , xml	1	1203	December 25, 2020
Convert XML into Datatable Studio datatable , excel , uiautomation , activities , string , question , xml	0	1540	July 1, 2020
Read out request with xml Activities uiautomation	2	227	December 6, 2023

Most Active Users - Yesterday
prashant1603765
ashokkarale
sharazkm32
Anon_Robot
Yoichi
Anil_G
bhanu.priya2
sonaliaggarwal47
xspunky
MD_Farhan1
More details...

XML Like I've Never seen before

Related topics