Excel Comparison using Uipath

[sayali_gujarathi1 (sayali gujarathi)]

Hi Folks,

Facing issue while comparing two excel files (SOurce file and destination file)
After comparison, if new entry found in source file, Update this new entry in destination file in respective columns as column index are not same but column name are same.

This is Source File. Highlighted entries should get add in destination file.

Below is Destination file image.

Kindly advise.

[lrtetala (Lakshman Reddy)]

Hi @sayali_gujarathi1

Can you try the below

Excel.Sheet("Sheet6").DataTableValue.RowCount+1

Source File:

Destination File:

Destination File(Output):

Cheers!!

[sayali_gujarathi1 (sayali gujarathi)]

Is it possible for you to share xaml file?

[lrtetala (Lakshman Reddy)]

@sayali_gujarathi1

Please check this

Sequence1.xaml (14.0 KB)

Regards,