Value of last row

Help
1

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
2

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
.

3 Likes
3

error
there is no row at position 6

1 Like
4

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

1 Like
5

BLANK is coming

1 Like
6

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

Cheers @Ananya1

2 Likes
7

Value is present

nd i have written same code

1 Like
8

Capture

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

1 Like
9

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

1 Like
10

u mean i should give range I8

but its not fixed ,might be it can I20

1 Like
11

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…

12

A7 is not fixed

13

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.

14

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