Menu

List Manipulation

Unleash the Power: Excel Automation in UiPath Studio with Practical Examples

, , , , , , , , , , , , , , , , , 0

Microsoft Excel is a cornerstone of data analysis and manipulation. But what if you could automate those tedious, repetitive tasks you do on a regular basis? Let me introduce you to UiPath Studio – a powerful Robotic Process Automation (RPA) tool that seamlessly integrates with Excel, allowing you to streamline your workflow and free up valuable time.

Why Automate Excel Tasks with UiPath Studio?

Manual data processing in Excel can be time-consuming and error-prone. UiPath Studio allows you to automate these procedures, increasing accuracy and efficiency. Here’s why it’s so advantageous:

• Automate repetitive tasks to reduce errors and improve accuracy.
• Boost productivity by focusing on high-value activities instead of tedious tasks.
• Improved accuracy with UiPath Studio’s consistent and dependable data processing.
• Improved Scalability: Automate workflows for huge datasets.

Practical examples to help you get started.

Let’s look at some actual instances of automating operations in Excel using UiPath Studio.
To get the Excel files, click the get button.

Get Excel Files

Here are the actions to take:

1. Start by opening UiPath Studio and creating a new process with a name and description.
Name: Excel Automation.
Description: Use Excel Activities to compute EMIs and total interest.

Excel Process Scope

2. Use the Excel Process Scope and the Use Excel File to read data from the Details.xlsx file. Enter the Excel file path in the activity. In the “do” section, select the Read Range and type Excel.Sheet(“EMI”) into the Range. Use CTRL+K to create a variable named dt_EMIDetail.

Read Ranges in Use Excel File

3. Following the Read Range, utilize the Read Cell Value Activity to obtain the message cell value. Insert Excel.Sheet(“message”).Cell(“A1”) in Cell and set the ExcelMessage variable to Save to.

4. To access the EMI_calculator.xlsx file, open another Use Excel file that is not inside the scope of the previous Use Excel file. Enter the Excel file path in the activity. In the “do” section, select For Each Row in Data Table and enter dt_EMIDetail into the Data Table field.

Use Excel File for EMI Calculator Excel
For Each Row in Data table

5. Within the For Each scope, utilize three Write Cell activities with the following parameters:

    a. Write Cell 1:

      – What to Write: CurrentRow(“Loan Amount”).ToString

      – Where to Write: Excel.Sheet(“Loan Calculator (2)”).Cell(“‘Loan Calculator (2)’!Loan_Amount”)

    b. Write Cell 2:

      – What to Write: CurrentRow(“Interest”).ToString

      – Where to Write: Excel.Sheet(“Loan Calculator (2)”).Cell(“‘Loan Calculator (2)’!Interest_Rate”)

    c. Write Cell 3:

      – What to Write: CurrentRow(“Tenure”).ToString

      – Where to Write: Excel.Sheet(“Loan Calculator (2)”).Cell(“‘Loan Calculator (2)’!Loan_Months”)

Write Cell Activity

6. Following the Last Write Cell, perform two Read Cell actions with the following details:

    a. Read Cell Value 1:

      – Cell: Excel.Sheet(“Loan Calculator (2)”).Cell(“I6”)

      – Save to: ActualEmis (Variable)

    b. Read Cell Value 2:

      – Cell: Excel.Sheet(“Loan Calculator (2)”).Cell(“I8”)

      – Save to: TotalInterest

Read Cell Value

7. Use Multiple Assign After Activity with the following parameters:

  1. OutputMessage = ExcelMessage.Replace(“{LoanAmount}”, CurrentRow(“Loan Amount”).ToString)
  2. OutputMessage = OutputMessage.Replace(“{EMI}”, ActualEmis)
  3. OutputMessage = OutputMessage.Replace(“{interest}”, TotalInterest)
  4. OutputMessage = OutputMessage.Replace(“Hello”, “Hello +CurrentRow(“Username”).ToString)

8. Finally, use the Message Box Activity to view the results.

Multiple Assign and Message Box

These are just example – UiPath Studio’s capabilities extend far beyond these. With a bit of exploration, you can unlock a world of possibilities for automating your Excel workflows.

Empower Yourself with UiPath Studio

UiPath Studio empowers you to transform the way you work with Excel. By automating repetitive tasks, you can achieve greater efficiency, accuracy, and productivity. Take the first step towards a smarter and more automated future – explore UiPath Studio today!

Click here for Documentation

Mastering the Flow: Control Flow in UiPath Studio

, , , , , , , , , , , , , , , , 0

UiPath Studio is a powerful automation tool, but its true potential shines with control flow. Just like a recipe with specific steps, control flow dictates the order actions are executed in your automation. This blog post dives into the various control flow activities in UiPath Studio, equipping you to build dynamic and efficient automations.

Control Flow

Conquering Decisions with If/Else

The If/Else activity allows your automation to make choices. Imagine processing orders: an If activity checks if the amount value exceeds a certain amount, triggering an “auto approve for less-value order” sequence. Otherwise, the automation follows a standard processing sequence.

If/ Else Flow

Looping Through Repetitive Tasks

Loops are the workhorses of automation, allowing you to repeat actions until a condition is met. Here are two common loop types:

  • While Loop: This loop continues executing a block of actions as long as a specific condition remains true. For example, a While loop might iterate through a list of customers until all have been processed.
  • Do While Loop: This loop executes a block of actions at least once, then continues to repeat as long as a condition is true. Imagine a Do While loop retrying a data download until it’s successful.
  • For Each Loop: The For Each activity enables you to step through arrays, lists, data tables or other types of collections, so that you can iterate through the data and process each piece of information individually.
While Loop
Do While Loop

Simplifying Choices with Switch

The Switch activity offers a multi-way branching option. It evaluates a variable against different cases and executes corresponding sequences. Think of processing different product categories in an online store: a Switch activity checks the product category and directs the automation to the appropriate pricing or handling sequence.

Switch case

Taking Control with Break

The Break activity allows you to prematurely exit a loop. This is useful when specific conditions within the loop trigger an early termination. For example, a Break activity could exit a data processing loop if an error is encountered.

Click here for Documentation

Conclusion

By mastering these control flow activities, you can create robust and adaptable UiPath Studio automations that handle diverse situations and repetitive tasks with ease. So, unleash the power of control flow and take your UiPath Studio skills to the next level!

Mastering UiPath Studio: Variables and Arguments Explained

, , , , , , , , , , , , , , , , 0

In the world of Robotic Process Automation (RPA), UiPath Studio stands out as a powerful tool for building efficient and scalable automations. But to truly unleash its potential, a grasp of variables and arguments is crucial.

Variables: The Backbone of Data Storage

Imagine variables as tiny boxes within your UiPath workflow. These boxes hold data – numbers, text, dates, or even entire collections – that you can access and manipulate throughout your automation.

  • Here’s a practical example:

    • You create a variable named invoiceNumber to store an invoice number extracted from a PDF document.
    • Later in your workflow, you use the invoiceNumber variable to populate a data field in a web application.

Understanding Variable Scope

It’s important to remember that variables have a scope, meaning they are only accessible within a specific area of your workflow. UiPath offers different scopes:

  • Local Variables: Defined within a sequence or activity, these variables are only accessible within that specific area.
  • Arguments: These special variables act as bridges, allowing you to pass data between different workflows.

Arguments: Sharing Data Across Workflows

Think of arguments as a way to send data from one workflow (the sender) to another (the receiver). This enables you to create modular and reusable automations.

Here’s an example of using arguments:

    • You create a workflow to calculate the total cost of an order. This workflow has an argument named itemPrices (an array) to receive a list of item prices.
    • Another workflow retrieves item prices from a database and passes them to the itemPrices argument when calling the calculation workflow.

Benefits of Using Variables and Arguments:

  • Improved Code Reusability: By storing data in variables and passing it through arguments, you can create reusable workflows that adapt to different scenarios.
  • Enhanced Readability: Clear variable names make your workflows easier to understand and maintain for yourself and others.
  • Efficient Data Management: Variables and arguments provide a structured way to handle data throughout your automation process.

Types of Variables

  • Text Variables: A text or string variable is a type of variable that can store only strings. These types of variables can be used to store any information such as employee names, usernames or any other string.

  • True or False Variables: The true or false variable, also known as boolean, is a type of variable that only has two possible values, true or false. These variables enable you to make decisions, and thus have a better control over your flow.

  • Number Variables: Number variables are also known as integer or Int32, and are used to store numeric information. They can be used to perform equations or comparisons, pass important data, and many others.
  • Array Variables: The array variable is a type of variable which enables you to store multiple values of the same type.

    UiPath Studio supports as many types of arrays as it does types of variables. This means that you can create an array of numbers, one of strings, one of boolean values and so on.

  • Date and Time Variables: The date and time variable is a type of variable that enables you to store information about any date and time. This type of variable can be found in the Browse and Select a .Net Type window, under the System namespace System.DateTime.
  • Data Table Variables: DataTable variables represent a type of variable that can store big pieces of information, and act as a database or a simple spreadsheet with rows and columns. They can be found in the Browse and Select a .Net Type window, under the System.Data namespace (System.Data.DataTable).

Click here for Documentation

Conclusion

Mastering Variables and Arguments in UiPath Studio empowers you to build robust and adaptable RPA solutions. With a solid understanding of these concepts, you can streamline your automation journey and achieve greater efficiency.

Mastering Data: String & List Manipulation in UiPath Studio

, , , , , , , , , , , , , 0

Introduction

The field of robotic process automation, or RPA, is revolutionizing how businesses operate. The ability to manage data effectively is at the core of this change. But raw data is rarely neat and tidy. This is where data manipulation comes in, allowing you to extract, transform, and organize information for seamless automation.

An effective tool for handling these data wrangling business is UiPath Studio. By reading this blog article, you will have the ability to work with strings and lists, which are the basic building blocks for data processing in UiPath Studio.

String Manipulation Techniques in UiPath Studio

Imagine working with text data, such as product descriptions, addresses, and client names. Using string manipulation techniques will enable you to work with this data precisely.

  • Slicing and Dicing with Substring Extraction:

    Need to isolate a specific portion of a string? Substring extraction allows you to grab a defined segment based on starting and ending positions.
    Example:
    Extracting Chandreshsinh From String Chandreshsinh Jadeja
    var_String.Split(” “)(0).toString
    Output:
    Chandreshsinh

  • String Concatenation:

    Often, you’ll need to combine multiple strings. String concatenation seamlessly merges separate strings into a single, unified string.
    Example:
    Merge var_String (Chandreshsinh) with Jadeja
    var_String+” Jadeja”
    Output:
    Chandreshsinh Jadeja

  • Replacing data:

    Errors in data might cause problems with automation. String replacement allows you to discover and replace undesired characters with the appropriate values.
    Example:
    Replacing Chandreshsinh from Chandreshsinh Jadeja with Mahavir
    var_String.Replace(“Chandreshsinh”,”Mahavir”)
    Output:
    Mahavir Jadeja

Conquering Lists in UiPath Studio

Lists, or ordered collections of items, are another important data structure in UiPath Studio. Let’s look at how to manage them successfully.

  • Creation and Initialization:

    Lists must first be created before they can be used. UiPath Studio has functionality for initializing empty lists and populating them with appropriate data.
    Go to Variable > Variable Type > Brows Type > and select/search System.collections.generic.List

    Example:
    1. Initialize list with Data
    new List(of String) from {“India”,”Nepal”,”China”,”America”,”Canada”}
    init list with data
    2. Initialize list without data
    new List(of String)
    init list without data

  • Adding and Removing Elements:

    Lists are dynamic! You can add new elements or remove unwanted ones using dedicated methods.
    Example:
    Adding new elements in List using Append Items to Collection Activity we will add Canada to MyList variable
    Append List
    Removing elements in List using Remove From Collection Activity we will Remove China to MyList variable
    Remove From List

  • Looping Through Lists:

    Processing each item within a list is essential. Looping techniques allow you to iterate through the list, performing actions on each element one by one.
    Example:
    Using For Loop to get all countries one by one from list

For each in list

Conclusion

Mastering string and list manipulation unlocks a world of possibilities within UiPath Studio. By effectively manipulating data, you can streamline automation processes, improve data quality, and unlock valuable insights from your information.

This blog post has equipped you with the foundational knowledge to conquer string and list manipulation in UiPath Studio. Remember, this is just the beginning! UiPath offers a vast array of functionalities for even more complex data wrangling tasks.

Back To Top
Empowering your forward-thinking company with efficient automation solutions. All sizes welcome.

Get In Touch

contact@roboautomator.com

+91 97696 44056

Subscribe

Subscribe to our mailing list and receive a free guide on RPA!

Subscribe