Check if files contain same data

Help Studio
,
1

if there are multiple excel files and i want to check there are same data present in some files
then how should i do it

2

@yogitagaikwad2206

You can read the data from each excel and whenyou mean same data if the files are exactly same with column names data everything then you can serialize the datatables and then equate both and check

Newtonsoft.Json.JSONConvert.SerializeObject(dt)

If the both resultant string are matching then they are exactly same

If need to compare row by row or column by column then we need to use loop on the datatable

For the above serializeObject to be available install UiPath.webapi.activities

Cheers

3

can you share sample input and expected output ?