Value of last row

i want to know the last value of Column in excel.Capture

i want to know the value of rowno 7
that which value is presnt

that meant output should be 7(cell value)

1 Like

Yah
Hope this expression would help you resolve this
after READ RANGE activity with output dt a datatable variable
In writeline activity
dt.Rows(dt.Rows.Count-1)(0).ToString

Cheers @Ananya1
.

2 Likes

error
there is no row at position 6

1 Like

Kindly have a view on the above comment changes
Cheers @Ananya1

1 Like

BLANK is coming

1 Like

Yah you need to have value in that
Make sure the expression used is
dt.Rows(dt.Rows.Count-1)(0).ToString

Cheers @Ananya1

1 Like

Value is present

nd i have written same code

1 Like

Capture

i want last value of column I ie 6
and last value of column G ie 8

1 Like

By using read range activity,in read range activity give the range Which one you to show on message box…

1 Like

u mean i should give range I8

but its not fixed ,might be it can I20

1 Like

take ana assign activity and create the variable and assign the expression like"A7:A"+(FullDT.Rows.Count+1).ToString
here "DT"means readrange out put variable…

A7 is not fixed

Hi,

Check that excel, may be other part of the excel been used. When your are getting value using Read Range activity that will populate empty values of the range is used even if there is no value.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.