Find text and get the value beside in excel

Help
1

Hi, how can I get the number on the beside cell?

I looked through forum and saw get text activity etc but how can I use that on excel?

image

Thank you xoxo

2

Hello,

You can use Read Cell activity to get cell values.

Cheers,
Pankaj

3

@Pankaj.Patil Hi, is there any ways to do as the position of the cell may vary every time

4

Hello,

Please use below xaml file.

FindTextGetValue.xaml (9.9 KB)

Cheers,
Pankaj

5

Hi, giving me an error though

image
image1156×318 23.2 KB

6

Hello,

Yeah, it will keep giving an exception because I used my excel file and it captured selector of my file. you will have to modify or recapture them.

Cheers,
Pankaj

7

Oh I see, I managed to change the other selectors but not sure how to change this selector.
image

8

you just recapture it by clicking Indicate on screen.
or you give me excel file. i will make it work.

9

2018_v1.0.xlsx (30.9 KB)

10

@sangasangasanga

Try Like this

Read the Excel Sheet and store it in a datatable dta

Then Use this Query

dataRow ABC= (From p In dta.Select
                         Where string.Join(",",p.ItemArray).Contains("Total Number of Monthly Subscription")
                         Select p).ToArray(0)

Array Values= (From p In ABC.ItemArray
                     Where not string.IsNullOrEmpty(Convert.ToString(p))
                      Select p).Array

String Value=Values(Values.Length-1).ToString

The Value will be Your Required OutPut.

You can use the same logic for another one.

Regards,
Mahesh

11

Hello,

here you are,
I made it with your excel file, find below xaml file.
you have to supply path of excel file in second activity(Type Into).

FindTextGetValue.xaml (16.4 KB)

Cheers,
Pankaj