Automation: Open Excel and Go to URL based on typed keyword

Help
, , ,
1

Hi Team,

Looking for some support. I have an excel file with certain keywords and their corresponding URL’s in adjacent cells. I wish to build a bot such that when I type the keyword in Uipath then the corresponding URL opens up. For example in cell A1 I have the keyword “Medicaid”, now i type “Medicaid” then the path opens chrome and goes to the URL in cell B1 which is “Mediaid.gov”. if anyone has already built something similar, let me know.

2

Hy @M23,

You could try the following:
Use a ‘read range’ activity, inside an excel scope.
Use a Dialog Input to get data from the user
Use a ‘Filter Data Table’ Activity to filter the records, using as a parameter the typed value.
Use the URL to open a browser.

I will prepare something for you and send you shortly

Regards

3

Hy @M23,

Please have a liik at my worfklow, if you have any questions please let me know.

Open_Excel_and_Go_to_URL-based_on_typed_keyword.zip (30.7 KB)

Regards

2 Likes
4

HI @William_Blech_Sister @M23

That was a good approach to work on, however we can save this mapping in dictionary and based on user input, it will be picked up from config file.
For ex.

Read this excel.
Put mapping data in dictionary as key value pair.
Take user input.
use config(userInput) and it will give corresponding URL.

5

Hy @Lakshay_Verma @M23 ,

Yes, It could be an alternative. The ‘Item exists’ activity could be used to check if any item was found :slight_smile:

Regards

2 Likes
6

Yes, Cheers :slight_smile:

7

Hello William, Thank you. However, I am unable to open the project. I am using UIpath studio 2018.4.5 version.

8

Ok, I deleted the json file (reading some suggestions on how to open). Now i am getting this error.

image
image781×407 11.6 KB

9

Hy @M23,

See the screenshots for the project:

image

image

If you have any questions please let me know.

Regards

1 Like
10

Thank you. I was able to configure. However, when I add keywords and URL it is not picking them up. Do i need to reconfigure range to read?

11

Hy @M23,

Please check screenshots of the entire project

image

First you get the keyword through an input dialog box
then you read the excel file, using a Read Range Activity and populate Data Table “DT_Input”

Then in the Filter Data Table Activity

image

You filter based on your typed keyword

image

this is the file result

image

Any questions please let me know, almost there.

Regards

1 Like
12

Thank you. It worked.

1 Like
13

@M23,

Very glad I could help you.

Please like my posts and mark my answer as solutions.

image

Thank you

14

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