Comparing two excels and writing the output to new excel file

[Shiva_Nikhil]

@Yoichi

can any one help me

inputs

final output

[Yoichi]

HI,

Can you elaborate? Do you mean need to remove rows in the second table which exists in the first table?

Regards,

[Shiva_Nikhil]

@Yes

I tried with 2 for each activity

Is there any linq?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Shiva_Nikhil ,
My way
get differ form 2 file.xaml (21.4 KB)
input

my output

regards,
LNV

[Yoichi]

Hi,

Can you try the following?

dt2.AsEnumerable.Except(dt1.AsEnumerable,data.DataRowComparer.Default).CopyToDataTable

Sample20230823-5L.zip (9.2 KB)

Regards,

[Shiva_Nikhil]

@Yoichi

thanks i tries with

dt1.AsEnumerable.Except(dt2.AsEnumerable,system.Data.DataRowComparer.Default).CopyToDataTable

I encounteres ad no datarow

now i have got the expected output

thanks @Nguyen_Van_Luong1

[Yoichi]

FYI, If there is possibility no rows exist in result, the following help you.

arrDr = dt2.AsEnumerable.Except(dt1.AsEnumerable,data.DataRowComparer.Default).ToArray

Regards,