RPA Log Hub

You can do Excel Automation in UiPath in four different ways: Using UiPath Activities. Using LinQ. Using Macros (VBA). Using Excel as a Database. Lets go with one by one : Using UiPath Activities Excel Application Scope: In this You can use Read Range Activity to read all the data into the DataTable. You can use the Read Cell Activity to read the data one by one into the Generic Format. You can use Loops on your DataTable. You can Filter DataTable Activity to filter out your data. Workbook: Even if excel is not installed in your system, then also you can use these activities to read or write excel. Using  LINQ You can use LinQ queries to Filter out the data directly on DataTable or List. In this case you cannot use Read Cell Activity. Read More About LinQ from here: Click here LinQ Syntax . LinQ Queries Used for Filter Out the Data . Using Macros (VBA) You can use macros also, not for Excel but you can do any type of work from Macros. VBA code is easy like a E...

So there are various ways to define the Array, List and Dictionary in UiPath. Take Assign Activity and Put your variable at left side with a data type defined with "New" keyword then write the below lines at the right side. Array New String(){"Blue", "Green"} List New List(Of String) ({“value1”,”value2”}) New List(Of String) from {“value1”,”value2”} New List(Of String)(New String(){“value1”,”value2”}) Dictionary New Dictionary(Of String, Object) Thanks!

This is actually same like other programming language or lets try to find different ways to do it.  First Method:  Logic : Compare two numbers and get the output then compare with the third number. Using If condition inside single Assign Activity and it will provide us the output in a variable. Lets look at the If condition first, how it works: If (Condition, True, False) Similarly if we want to use another if inside the first one, this is how we will use. If (Condition, True , False) If (Condition, If (Condition, True, False) , False) If (Condition,  If (Condition, True, False) ,  If (Condition, True, False) ) Lets take three numbers of datatype Int , and assign the values Then in output variable we declare the condition we defined above. Output= If ( _No < second_No , if (first_No < third_No, first_No, third_No) , if (second_No < third_No, second_No, third_No) ) It will give you the least number, similarly if you change the sign greater than > then it ...

Sometimes, we come across the situation where we have to send the email to some group and then they will cross check some data or fixing from their side and reply back on the same email with their approval, then only you have to proceed forward. In that case we can configure our code in such a way that it will check the outlook emails to wait for approval email to come. We are assuming that currently the wait time is 10 minutes and after that we will send the email again to the team/group and we will keep sending the email until they provide us approval. So, accordingly you can change your scenario or you can do little changes in this easy logic. The whole logic will look like this, its very simple and easy to understand. 1. First send the email to the concerned team and set the time after 10 minutes in one variable. Now we will check this variable with the current time to get to know that we have waited for 10 minutes or not. 2. Then we will assign on new List of Mail messages and wil...

To do excel formatting, there is no specific activities available in UiPath, so either you have to go for VBA or Vb.Net to get the required formatting. Both methods are good and fast. Lets see how we can write a simple code to do our formatting. First of all, if you are using this  Microsoft.Office.Interop.Excel in UiPath , then there are chances that it will show you error, so you have to install this. First to go to Manage Packages and install this: If still shows error then open your .xaml file in Notepad and paste this below line along with another assemblies present in file: Now you are ready to use below Code, Use Invoke Code activity and paste this entire code into that and run. FullFilePath,  SheetName----  Replace these with your File Path and Sheet Name, you can also make them as Argument and use that variable in place of this. '--------------Code------------------ Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Ex...

As you already have seen the situation where multiple users are logged in on single VDI. On this situation when we use Kill Activity directly to kill the process forcefully then it kills all processes without checking the user details. So we are writing small code so which you can use in your KillAllProcess workflow of Re-framework. It will kill processes for logged in users and plays a vital role when running Bots in High Density Environment on Servers or standalone systems. It works as per below: It will get the process session Id as Process_Username. It will get the current user session Id as Current_user. Then Check the If condition that Process Name is Equals to your Input process Name and Process_Username=Current_user Then it will pass process variable into the Kill Activity to kill that process. 1. Get Processes Activity , Output Variable: ActiveProcesses 2. Use For Each Loop and Pass the Above variable inside it and make the TypeArgument as System.Diagnostic.Process 3. Insi...

Robotic Process Automation is the technology that allows anyone today to configure a “robot” to emulate and integrate the actions of a human interacting within digital systems to execute a business process. As demand is increasing so, we have to update ourselves with latest trending questions in the market. So lets look at some basic Questions related to RPA UiPath. What is RPA? Automating the rule based tasks. What is RPA LIFE CYCLE? Analysis & L4 (Process Maps) Development Unit Testing User Acceptance Testing (UAT) Production Deployment Maintenance & Support How many types of variable present in UiPath? String, Int32, Double, Data Table, Array, List ,Generic Value, Boolean. For more variable you can click browse for types in variable panel. What are some common properties present in UiPath Activities? ContinueOnError DelayAfter DelayBefore TimeoutMS WaitForReady Difference between Full & partial Selector. Full selectors:  Contain all the elements needed to identi...