How do I get the last value in Column A?

Learn
1

Hello everyone, I have the following information.
Test.xlsx (8.9 KB)

Excel7
Excel7540×811 63.2 KB

Thanks.
Perawat

2

@Perawat First get the number of rows present in the excel by Read Range or Read column and then use Read Cell activity and pass A+rownumber

1 Like
3

@Perawat use Assign

LastValue=dt(dt.Rows.Count-1)(Debit Amount).tostring

Assuming dt is datatable from above excel.

Hope this will help you.

2 Likes
4

Can you write an example for me.

5

(post withdrawn by author, will be automatically deleted in 24 hours unless flagged)

6

image

7

I just made a examle just have a look at it,
_Test.xaml (9.7 KB)

8

Hi @Perawat,

Here is an activity called “Find Last Row” . So it will return the last row index of the sheet. after you can use the read cell activity to get the value .

Thank you
Balamurugan.s

1 Like
9

Excel8
Excel8816×326 11.4 KB

10

@Lakshay_Verma, I don’t know which part is wrong.

Excel9
Excel9857×707 19 KB

11

What is the output of read range activity ?
It should be dt of type datattable

12

Looking at the message on popup,
You’re making varible of double type. it must be string.

13

Excel10
Excel101252×729 18.9 KB

14

@Perawat Can you do this and Check :
Capture

output

Where DT is the output of Read Range Activity

2 Likes
15

@supermanPunch I didn’t get results like yours.

Excel11
Excel111178×819 114 KB

16

@Perawat Try with this :
DT.Rows(DT.Rows.Count-1)(0).ToString

3 Likes
17

@supermanPunch, I got results like yours. Thank you very much.

1 Like
18

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