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

Learning Hub Academy Feedback
1

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

2

Hi @Hitesh1

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

Regards
Roshan

3

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
4

Yes…

5

Hi @unknownay

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

6

Hello @Hitesh1

This might help you: LookupRange activity.

2 Likes
7

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
8

Thankyou so much for the help!!!

9

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