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
Table 2
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
Table 2
use join datatable like this and you will get only the row that is different:
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.
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
@yogavalli If you Still haven’t found the Solution, Can you show us the Output For the Two Excel Files you have Shown ?
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.
@yogavalli What do you mean by you don’t know the Column Names , 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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.