How to update the data table in between for each row after deleted a record in excel sheet

hi Team,

i have excel sheet with 4 rows.
i want to remove the duplicate records.
i applied logic read range into Data table and compared with other columns.

now i removed 1,3 rd and 4th rows and inserted into other excel sheet. then already data is contains the data table with 4 records but reality is deleted the 3rd, 4th and 1 st rows.
it is trying to find the any duplicates with 3 rd row. and found 4th row so in excel sheet again adding 3rd, 4th row second time. any suggestions. how to update the data table data inside the for each row.

@anilkumar.vegi

Check below post for your reference

Dt.Rows(index).Item(ColumnName).ToString = Your value

Hope this helps you

Thanks

If the requirement is to remove duplicate rows. You can simply use Remove Duplicate rows activity.

Ya Shubham i applied same activity… thanks You

1 Like

Great! :slight_smile: