Comparsion of 2 Excel files

Help
1

Hello Team,

I have two excel files with same column name, I need to compare two excel sheets and I need to get the difference.
Table 1
image

Table 2

image

2

@yogavalli Do you want to find the UnMatching Rows within the two Files?

3

use join datatable like this and you will get only the row that is different:
image

4

Yes @supermanPunch.

For me, every time the name will be same, but I need to know the status.

If my status has been stopped I need to get the value. Or else it wants execute the next level process.

5

Hi ,
→ you can read form excel to datatables(EX: DT1 and DT2) and use below code to uncomman values.

DT1.AsEnumerable().Except(DT2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

6

@yogavalli If you Still haven’t found the Solution, Can you show us the Output For the Two Excel Files you have Shown ?

7

Hello @bcorrea,

Thank you for your solution. But till I have one more issue.

If, I don’t have exact column name in my Excel. That time how can I write my conditions.

Same like the below format.
image

8

@yogavalli What do you mean by you don’t know the Column Names :sweat_smile: , Column Names Must be Present or you should know the Position of the Column Like If Status Column is the First Column you can use 0 instead of Column Name, If it is Second Column you can use 1 and so on

1 Like
9

Thank you @supermanPunch :grinning: :grinning:

Working great.

1 Like
10

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