Hi, I am trying to compare two xml files where under one parent tag we can have multiple child tags. Please suggest how can I do that because using string function it will need a lot of coding effort to accomplish this thing. Thanks, Anjali

@anjalimishra , if you load UiPath.Excel.Activities pacakage then you will have following activities to use for XML. [image] hope my inputs are useful

Hi, How I can use these activities to compare my xml files? thanks, Anjali

[image] rkelchuri: UiPath.Excel.Activities Hi, I dont get xml activity, instead having excel activities downloaded. Thanks, Anjali

As stated earlier in my ask, if I go one after another tag it will take a lot of time. So please suggest a simpler way to do the same. Thanks, Anjali

Could you please let me know you want to compare parents nodes or child nodes?

Set xmlDoc1 = CreateObject(“Msxml2.DOMDocument”) xmlDoc1.load(“C:\Filepath\file1.xml”)’file 1 Set xmlDoc2 = CreateObject(“Msxml3.DOMDocument”) xmlDoc1.load(“C:\Filepath\file2.xml”)’file 2 Compare in if else condition. Hope this logic useful for you

If no other way try DataSet and see if you are able to compare(datatable columns) easily with that. [image] [image]

Hi, I am getting below error “Dataset does not have a public instance method name ‘ReadXml’” [image]

Xml File Comparison

Help

vvaidya (Vinay Vaidya) September 8, 2017, 2:57pm 11

xmlToDt.xaml (6.1 KB)

Reading xml file into dataset/datatable

XML To DataRow

Topic		Replies	Views
Read XML file and Compare them Help	1	1341	March 14, 2019
I have 2 xml files. I have to compare them by values present inside the tags. If they have any mismatches, I have to get the differences between the values side by side. How can i do that in a simpler way without using xpaths? Studio studio , question , activities_panel	0	465	April 21, 2023
I have been trying it from long ago plz anyone can help on this (Need an .NET code that need to compare two XMLs and need to show the differences if the differences present in the two XMLs Studio uiautomation , activities , studio , question , activities_panel	2	766	June 2, 2023
Compare Two Excel files in Ui path studio X StudioX studiox	3	2031	May 29, 2020
How to compare two excel files? Activities excel , activities , question	4	1041	August 29, 2022

Xml File Comparison

Related topics