How can i compare 2 excel file and if there is a difference write it on an other excel file

Help Activities
,
1

How can i compare 2 excel file and if there is a difference write it on an other excel file ???

2

@Soudios

What you want to compare?

Row-wise?
Column-wise?

Cheers

3

names, if a new name was added on the file

4

@Soudios

So basically you want o compare only one column which contains names and check if there are any differneces?

Read both excels into dt1 and dt2

Use dt1.AsEnumerable.Select(function(x) x("Names").ToString).Except(dt2.AsEnumerable.Select(function(x) x("Names").ToString)).ToList to get list of all names that are not matching

Cheerd

5

do you have an example plz ?

6

@Soudios

Use Joindatatable activity

Mention which column need to compare

Create an output

And use writerange to write to excel

7

where i need to put all of that ? do you have a picture ?

8

@Soudios

image
image903×560 23.9 KB

9

@Soudios

The above given is the example code

cheers

10

it takes a long time more than 5min and nothing yet, is it the good structure ? :

image
image576×683 20.9 KB

image

11

@Soudios

yes it will give you the entire data

12

it takes too long time, is it normal ?
What i need is just the difference between these 2 excel file

13

@Soudios

Dt1.AsEnumerable().Where(Function(row) Not Dt2.AsEnumerable().Any(Function(x) x(“Item Name”).ToString=row(“Item Description”).ToString)).CopyToDataTable

14

where i need to put this ?

15

@Soudios

in the assign activity

newdatatablevar=synatx

16

https://forum.uipath.com/search?q=compare%20two%20excel%20files

17

can you show me all the process with the input
image

18

@Soudios

Main.xaml (16.6 KB)

19

it doesnt work, it merge the 2 excel file, what i want is to have only the line in plus than the first file

20

@Soudios

can you share your output which you are expecting