Who can i compare 2 excel file plz?

Learn Academy Feedback
21

The message boxes are simply there as placeholders so that my example can show you that the evaluation of the names has taken place and a result of equal or non-equal has been produced. You can add whatever code you want from that point into the “Then” side or the “Else” side of the evaluation, for example, your need to change the colour of the cell.

2 Likes
22

can you send me a picture of the process plz ?
What i have to change to have the right condition and the cell change color to red plz :slight_smile:

23

Please visit the links I sent which detail how to change cell colours in an excel document or ask the forum as I feel like I am having to do this for you.

1 Like
24

No sorry my friend its not really that, :wink: For the color i am checking the link, i am talking about the process, want i need to do to have the good process to search the names. Did i let the same process you gave me ?

25

I think your easiest option is to create a new file where the cells that don’t match are highlighted.

I have put together an example you can adapt to your needs.

CompareNames_v2.zip (6.6 KB)

The output is as below:

image
image1127×413 24.3 KB

1 Like
26

Yes maybe but i need some information in the excel i want to be highlighted

27

I’ve just added a step which does just that. Like I say, you can adapt it for your needs. I can’t keep doing this with only bits of requirements each time

1 Like
28

its not working, the process highlighted all the names not just the names on excel 1
For Example if there is 4 people so it will highlight the 4 first people on the list
Can you help me my friend ?
@ronanpeter

29

Screenshots or XAML file would help.

30

COMPARATEUR FORUM EXPLICATION.xaml (12.8 KB)

31

Looks ok to me, please provide screenshots of your data files.

33

There is something certainly wrong with your workflow. See attached two sample files and the same workflow I sent earlier, the output is fine:

DataFile1

image
image793×457 19.9 KB

DataFile2

image
image691×443 18 KB

Output

image
image654×1030 28.2 KB

CompareTables_v4.zip (15.5 KB)

Honestly, I have shown you how to do this, it works as I have explained it. If you are finding errors, let me know.

34

Have you checked your data to ensure they are in fact the same? As I stated, it works for me.

35

i see the probleme, the process is highlighting the name doesnt exist, but what i want is the reverse of that :slight_smile:

is this sentence says : if you find the same name in the data1 and 2 ?
row.Item(“Prénom Nom”).ToString = dtTable2.Rows(intRowNumber)(0).ToString

@ronanpeter