How to last row value of a specific column in an excel sheet?

[Vaishnav_Tej]

Hi All,

I want to know How to get the last row value of a specific column?

For E.g. Here I need to get 7500 as output.

[Harshith_Adyanthaya]

Hi @Vaishnav_Tej ,

Try this.

Dt(Dt.rows.count-1)(“Expected Product TCV ($000s)”).ToString

where Dt is the datatable.

Hope it helps.

[arjunshenoy]

Hi @Vaishnav_Tej

You can use this query:

dt.Rows(dt.Rows.Count - 1)("ColumnName").ToString()

Hope this helps,
Best Regards.

[Anil_G (Anil Gorthi)]

@Vaishnav_Tej

Another way would be to use a lookup Datatable activity…

you can look up for Grand Total: and get the value from next column

https://docs.uipath.com/activities/docs/lookup-data-table

cheers