Compare excel table row by row

Help
1

Hi all,

I have a question ,I want to compare the data(row by row) between two excel sheet.
I have tried but it doesn’t give the desire solution .
I am going to attach the file.
can you please check it.

pls help.5_17_19(comparison).xaml (22.9 KB)

2

Hi @arpita2,
You have many topics related to this problem. Please have a look at list with those which are solved:

Search results for 'compare two rows status:solved' - UiPath Community Forum

3

Hi @arpita2

After comparing what you have to do ??
Can you please share a sample excel file ??

Regards,
Vijay

4

hi @Vijay_Kumar_C.
I have shared my file pls check. after comparison of every row I just want to display in message box. row is same or row is different.
Pls help

5

Hey @arpita2

Attached Sample workflow. In your code you already check row and column count is similar or not in bot datatables. so you can use below code.

CompareExcel.xaml (9.0 KB)

Regards,
Vijay.

6

@Vijay_Kumar_C thanks for your help .I have tried your solution .but when row is different . It show that row is same.

7

Hey @arpita2

Thank you for reply. Can you please share input file to me ?
so that i can check and give you proper solution.

Regards,
Vijay.

8

CompareExcel.xaml (8.0 KB)

i have attached
pls check.
I need to check row one by one

9

@arpita2 - i am asking for Input Excel File where you have your input data.

Regards,
Vijay.

10

samplefile2.xlsx (7.9 KB)

11

SampleFile.xlsx (9.3 KB)

this is excel file.

12

Hey @arpita2

Did few changes to your flow. now it will show message boxes for which row which cell value is equal. Please check it and let me know it is working or not.

5_17_19(comparison).xaml (24.2 KB)

Regards,
Vijay.

1 Like
13

thanks @Vijay_Kumar_C.
I will check and let you know.
thanks once again

14

Hey @arpita2 - Is it working …??

Regards,
Vijay.

15

yeah thanks @Vijay_Kumar_C
It is working now.
thank you so much for your help.

16

Great @arpita2
Please mark this thread as solved so that it will help others.

Regards,
Vijay.

17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.