Excel is picking last cell value only

Help Activities
, ,
1

i have to login on web page and i have a sheet where i have given id
Now when ever i am coming on the web my bot is picking the last cell value of “ID” column everytime.
please let me know any solution of it.

2

steps to follow:
read range workbook activity to read the excel file->name the data table table as dt_1(ex:)
use for each row in data table -assign:id=currentRow(“ID”).tostring ,then use this id for type into activity …Let me know if it works

Regards.

3

@office_work

Dt.AsEnumerable.Select(function(x) x(“Id”).ToString).Last()

Cheers!!