Automate Country Lookup and fill back result in Excel

Members only Use Cases Repository
, ,
1

Automate Country Lookup and fill back result in Excel

Use Case Description

Description - Project take input from excel file, then checks the country on Google and writes back the result to Excel file. Skip REFDemo1 folder as it was shown for understanding the flow only. This could be useful where the input is predefined and we need to check the value on internet and log it back in the Excel file, provided there is a unique input value for the provided input. Below is the guide how I’ve implemented it using the REFramework.

REFLive folder as main, it has implementation of RE Framework which acts as performer of these activities and read the Country from Queue which is saved in cloud.uipath.com. Data file path is saved in the same url in Asset (which is a placeholder for the property such as ExcelPath file).
Then - Dispatcher project read the Data file using Path saved in Asset and then writes it in Queue saved in cloud.uipath.com.

AS-IS WORKFLOW, TO-BE WORKFLOW

REFrameworkLive.zip

Other information about the use case

Industry categories for this use case: Other Sector

Skill level required: Beginners

UiPath Products that were used: UiPath Studio

Other applications that were used: Excel file

Other resources: -

What is the top ROI driver for this use case?: Accelerate growth and operational efficiency
Workflow Sample-converted.pdf (22.8 KB)

2

Hi @

Thank you for your submission.

Please see our remarks below to qualify for a certification discount voucher:

  • as per the rules of the contest, the description of the use case should be at least 100 words
    Here, please provide more context about the problem that your use cases is solving in the broader context with slightly less focus on the technical implementation.
  • the To-Be workflow should follow the sample here and be attached as an image under the AS-IS WORKFLOW, TO-BE WORKFLOW header
    This is to allow everyone to easily access and understand the use case without having to go over the entire project. The zip of the project can of course stay as well for more context.

Please edit your post above with these changes :slight_smile:

1 Like