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

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.

Hi @Vaishnav_Tej ,

Try this.

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

where Dt is the datatable.

Hope it helps.

1 Like

Hi @Vaishnav_Tej

You can use this query:

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

Hope this helps,
Best Regards.


Another way would be to use a lookup Datatable activity…

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


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