Finding specific value on excel then get the location of it

[rtablate (Ricky Tablate)]

Hi,

Need help! I am searching value (e.g. port-56) if its existing in the excel I’ve download then store the value location (e.g. A10) Thanks!

[sarathi125 (Parthasarathi)]

@rtablate,

Check this post

Check Value from excel - #3 by Arunachalam

[Palaniyappan (Palaniyappan P)]

Kindly have view on this thread

Find cell with String Value and get no. of row, name of column

HI @AKY, can you go through this post, its may be helpful for you. @ClaytonM Regards, Arivu

Cheers @rtablate

[rtablate (Ricky Tablate)]

I’m getting an error. see below

[Palaniyappan (Palaniyappan P)]

here you go with a xaml
hope its resolved
cellpoistion.zip (16.6 KB)

Cheers @rtablate

[rtablate (Ricky Tablate)]

it’s works! but the result is H64 but upon checking the file it’s under H65.

[Palaniyappan (Palaniyappan P)]

awesome
here we can change the value accordingly in the writeline activity
like set as 1,

Cheers @rtablate

[rtablate (Ricky Tablate)]

Yeah it’s working saw it already. Need to chat with you to verify. it’s a 2-in-1 on my end once it’s search the position then I must say that it is existing too. Thanks!

[Palaniyappan (Palaniyappan P)]

Cheers @rtablate

[rtablate (Ricky Tablate)]

just to add how to get the value of the specific field (H20) and pass it on a variable. Thanks!

[Palaniyappan (Palaniyappan P)]

we can use READ CELL activity where we can mention the cell position and get the output with a variable of type string
Cheers @rtablate