How to get the cell address of a specific value in datatable

Hi Team,

Can some help me in the below query-
How to get the cell address of a specific value in a datatable

Example - value = “Accounts” cell address =B9

Thanks

Hi @Hitesh1

Basically you need to find the index of row and index of column where the value is located.

Regards
Roshan

Hi @Hitesh1

Use below code to convert index to corresponding alpabet. Keep in mind that index starts at zero.

Convert.ToChar(convert.ToUint16("@"c)+(index+1))

Regards
Roshan

Please mark as solution if found useful

1 Like

Yes…

Hi @unknownay

I want to search a word in excel sheet and want the cell address for the same.

Hello @Hitesh1

This might help you: LookupRange activity.

2 Likes

Hi @Hitesh1

Since you told you want to find in datatable initially i said about this if you are searching from a excel
use look up range activity only it will return you the exact range

Regards
Roshan

2 Likes

Thankyou so much for the help!!!

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