Reading An Excel File In UiPath

What is RPA

 

RPA stands for Robotic Process Automation,  an emerging form of business process automation technology which provides easy GUI based tools and activity to automate business processes.

 

Here we are using UiPath RPA Tool.

 

First Install RPA Tool UiPath Community Edition from here.

 

Simple Hello World and Web Scraping Projects/Program articles are already here in C# Corner.

 

Now we will create Automation using UiPath to read the data from the existing Excel file and paste that data into Notepad.

 

Step1

 

Open Uipath Studio

 

 

Under New Project click on Process for blank project

 

 

It will give you the below screen,

 

 

Type Name and Description then click on the Create button

 

Step 2

 

As this is a very simple step first we will be reading an excel then we will open a notepad and write the invoice number into it. So we will choose Sequence activity as everything is in linear/sequence form.

 

 

Click open main workflow

 

Drag sequence activity under main

 

 

Change properties displayName from Sequence to “Read Excel and paste into notepad”

 

Step 3

 

For reading an excel first we will choose the activity called "Excel Application Scope" from activities

 

Type "Excel application scope" into search activities

 

 

Drag it into "drag activities here" under main

 

Give the Excel path in WorkbookPath Properties or else just click … and browse to the Excel file.

 

 

Search Read Excel and drag it as below: 

 

 

Now give the cell value and Sheet name from an existing Excel sheet as below

 

 

To store a result we need a variable

Create a variable by clicking on variable,

Select proper variable type and scope

 

 

Pass that variable to Result.

 

 

Now we have read the data invoice number from Excel and stored it in the Variable called getInvoiveNumber

 

Step 4

 

Open Notepad Application by taking open application activity from activities.

 

 

Pass the "C:\windows\system32\notepad.exe" into FileName Property

 

Open Notepad

 

Click on Indicate on Screen in Open application activity and click on the notepad screen.

 

Selector for Notepad

 

 

Note

Here I have replaced Notepad with '*' to make it dynamic 

 

Now we need to attach that notepad window

 

For that take attach window activity as shown

 

 

Go to indicate on screen and click on notepad

 

 

Now choose the type into activity to type the  invoice number to Notepad

 

 

Go to properties in text field and pass the variable that has stored the invoice number in variable getInvoiceNumber

 

 

Now run the automation/sequence by clicking on Debug button.

 

It will take the data from Excel and paste on notepad

 

Conclusion

 

Now you are able to write the Automation using UiPath for taking data from existing Excel and typing it to any application using type into activity. You can use the given use case explained here in any of your projects.