Finding specific value on excel then get the location of it

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!

1 Like

@rtablate,

Check this post

Check Value from excel - #3 by Arunachalam

Kindly have view on this thread

Cheers @rtablate

I’m getting an error. see below

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

Cheers @rtablate

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

1 Like

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

Cheers @rtablate

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!

1 Like

Cheers @rtablate

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

1 Like

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

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