How to compare text from web and excel

Help
1

Hello guys,

1

For example I get a “B112” text from web and want to compare it with excel, if they are not same it will loop until they meet and give “2” as a output.

Can anyone help me? Thank you very much

1 Like
2

hi @claudiojody

Do you mean if the text isn’t found the value is stored in excel with value 2 or it gives out a popup as “2”

1 Like
3

if the text isn’t found it will check to another column until they are same

1 Like
4

So basically its needs to be there ?

1 Like
5

yes, if the text from web and excel are same, it will give popup as “2”, the number from column B

6

Two ways I could do this:
First Way:

  1. Read Excel and convert it to data-table
  2. Do a for loop on data-table and search for the required text from the web-site
  3. If true, do the popup of the 2nd column of the item
    Second way:
  4. Read Excel and convert it to data-table
  5. Do a filter or select query on the data-table and just get the row item with the match
  6. Get the 2nd element of the column

Hope this helps
Cheers @claudiojody

1 Like
7

can you please explain how to popup the item from 2nd column?

8

Hey @claudiojody

Did you understand how I get the index of the found item??

I can use the activity message box for the pop-up item required

9

@claudiojody,

I have attached sample work flow , please find the same.

Please like and mark this as resolved, if your requirement met.

Thanks,
AnilWebAndExcel.zip (17.8 KB)

10

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