How do I get the last value in Column A?

[Perawat]

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

Thanks.
Perawat

[Arpit_Kesharwani]

@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

[Lakshay_Verma]

@Perawat use Assign

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

Assuming dt is datatable from above excel.

Hope this will help you.

[Perawat]

Can you write an example for me.

[Lakshay_Verma]

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

[Lakshay_Verma]

[Pankaj.Patil (Robot Master)]

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

[balupad14 (Balamurugan)]

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 .

UiPath Go ! BalaReva EasyExcel Activities

Hi , I have developed 2 new activities. Find LastColumn that to find the last column Index and Column Name of the sheet . Find LastRow that to find the last row of the sheet and it returns the row index. [image] [image] Find LastColumn’s Properties : [image] Find LastRow Properties : [image] Note : If the sheet name is empty , It will take the first sheet name . Here is the video demonstration. [UiPath excel Extract Graph as Image | find last column Index| find last Row No…

Thank you
Balamurugan.s

[Perawat]

[Perawat]

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

[Lakshay_Verma]

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

[Pankaj.Patil (Robot Master)]

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

[Perawat]

[supermanPunch (Arpan)]

@Perawat Can you do this and Check :

Where DT is the output of Read Range Activity

[Perawat]

@supermanPunch I didn’t get results like yours.

[supermanPunch (Arpan)]

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

[Perawat]

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