How to get last row value in particular column in excel using uipath

Help Studio
,
1

Hi guys,

I couldn’t able to get last row data in particular column in excel ,

For example
Column1
AA
BB
GG
JJ— i need to get “JJ”

please any one help this.

Regards,
Raja G

2

Like this:

Processusvierge.zip (17,9 Ko)

1 Like
3

@Anthony_Humphries,

Thanks but i couldn’t able to take that value,i checked in message box but shown System.data.row

please can you help this

4

Hi @Raja.G,

You can achieve this by giving using this syntax —> DT.Rows(RowIndex)(ColumnIndex).ToString

Use following code in assign activity.
Value1 = dt.Rows(dt.Rows.Count-1)(0).ToString
Use message box with Value1 variable to check expected output.

Value1 —> is of String type.
We’ve use dt.Rows.Count - 1 because, Index starts from 0 —> 4 (Count) -1 —> 3
ColumnIndex (0) —> as it is first column.

that’s it. :slightly_smiling_face:

1 Like
5

@samir,

Thanks working fine

6

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