Need to find particular column cells using row index and column index in Uipath

[Pravin_S]

Hi,

Need to find particular column cells values using row index and colum index number. I have created variable for rowindex and columnindex. I am using dtTable.rows(rowNum)(Colnum) but it’s not working. I have to assign that range in write cell activity. Could you please me.

[Srini84 (Srinivas)]

@Pravin_S

Can you try as below

dtTable.rows(rowNum)(Colnum).Tostring

Hope this may help you

Thanks

[Pierre_Fleury]

Hello,

You try to affect value to a specific cell or read it?
I just try to read and affect a new value with dt.rows(indexR)(indexC) and it seems to work.

Do you have an error?

[Pravin_S]

I used this but getting compiled error

[Rahul_Unnikrishnan]

Please check whether the below post will help here.

Get row and column index of cell with specific value

Thank you! I’ve did that using For Each loop with Lookup Data Table activity inside it. In my case: List variable contains SAP symbol, and I look for correlated system name in data table. You only need to change the names and indexes of columns where to look for data. Feel free to use this workflow in your projects correlated_values.xaml (8.8 KB)