Robotic Process Automation is the technology that allows anyone today to configure computer software, or a “robot” to emulate and integrate the actions of a human interacting within digital systems to execute a business process.
RPA robots utilize the user interface to capture data and manipulate applications just like humans do. They interpret, trigger responses and communicate with other systems in order to perform on a vast variety of repetitive tasks. Substantially better: an RPA software robot never sleeps and makes zero mistakes.
UiPath is a leading Robotic Process Automation vendor providing a complete software platform to help organizations efficiently automate business processes.
UiPath Studio is a tool that can model an organization's business processes in a visual way.
Reading this article, you can learn how to create a datatable, store the data into a datatable, retrieve the data from the datatable and write the data into a CSV file with Assign, Do While, Add Data Row and Write CSV activities using UiPath Studio Pro Community.
The following important tools are required for developing UiPath Bots,
- Windows 7/8.1/10 (Recommended)
- UiPath Studio Pro - Community Cloud (It is a free software available online –https://www.uipath.com/start-trial)
Now we can discuss step by step app development.
Step1
Open UiPath Studio -> Start -> New Project-> Click Process
Step 2
Now, create New Blank Process , Name as UiDatatable and give your Description
Step 3
After that UiPath studio creates the project UiDatatable with supporting files.
Step 4
Next , for storing data to a Datatable, create a new sequence workflow named Testdatatable,
Create a Datatable variable named Datastore,
Similarly, create 3 variables, with Name as String, MobNo as Int32 and City as String for values for local variables storing data in datatable,
Click Activities -> search Buid Data Table activity->Drag and drop into sequence,
Click the Datatable and create 3 columns based on our data like Name, MobileNo and City,
First, click Edit column icon and Column name as Name, Datatype as String and click ok
Similarly, create another two variables, MobileNo and City
Set the output Datatable as Datastore,
Create one more local variable count for record
Click Activities -> search Assign activity->Drag and drop into sequence and set the value,
Count = 0
Click Activities -> search Do While activity->Drag and drop into the sequence,
Click Activities -> search Assign activity->Drag and drop into the sequence and assign
Count = Count +1
Click Activities -> search Add Data Row activity->Drag and drop in to sequence,
Set the INPUT -> Array Row Property value in Add Data Row, {“Vijay”, 123456789, “Namakkal”}
Set the INPUT -> Datatable Property value as Datastore in Add Data Row
Set the Do While Loop condition as count > 5 for storing 5 records in Datastore Table,
Click Activities -> search Write CSV activity->Drag and drop into sequence,
Set the Write to what file property and Write from property in Write CSV activity for displaying the data in the Datastore table,
Step 5
For running your project, Select debug file -> Run,
The output of the UiNotepad project is, Click the Folder icon in Project tab and find the newly created file test.csv
Open test.csv file, the file contains 5 records,
Summary
Now, you have successfully created and tested a Datatable and displayed the stored values in a .csv file using UiPath Studio.