Contact Us

Popular posts from this blog

UiPath - Convert String to DateTime

Image
UiPath - Convert String to DateTime We need to convert a string date to DateTime format very frequently whenever we are going to work with date and times. Let’s understand and convert string to DateTime in UiPath using an example below: Step 1 – Take a variable/argument to store the string date in_DateString = "01/01/2020" Assign String Date Step 2 – Take a variable/argument to store the string date format in_DateStringFormat = "dd/MM/yyyy" Assign String Date Format Step 3 – Convert string to datetime using below provided method out_DateTime = DateTime.ParseExact(in_DateString,in_DateStringFormat, System.Globalization.CultureInfo.InvariantCulture) Convert String To DateTime The variable/argument out_DateTime would contain the date value in DateTime format.
Read more

Filter DataTable in UiPath Studio

Image
UiPath - Filter DataTable It is very important to be able to perform filter operations on DataTable in order to get a desired result. Let’s take an example of having a table with columns such as FirstName, LastName and Age. We need to filter the records having FirstName as "David". Input DataTable variable – InputDT Output Filtered DataTable variable – FilteredDT Method 1 – Using "Filter Data Table" Activity Add the variables and conditions as shown below: Filter DataTable Activity We can also choose the columns needed as a resulted FilteredDT, by adding columns via the Output Columns Tab as shown below: Filter DataTable Activity - Keep/Remove Output Columns Method 2 – Using "DataTable.Select() method" Using this method, we can directly assign filtered rows to a DataRow array or DataTable using below given expression. By default, this method returns the array of data rows, but we can convert it to DataTable.
Read more

UiPath - Kill Process for Current User

Image
UiPath - Kill Process for Current user Kill Process activity in UiPath terminates a specified process from the machine/server. This activity kill process for every user session, and this would create problem for other users working on the server. This would also create problem to work with High Density Robots features of UiPath. In order to avoid these issues and for good practice in development, we should kill process for current user only on machine/server. Below is the uipath code to kill process for current user. Step 1 – Take a variable/argument (string array) contains the process names needed to be killed. in_ProcessArrayToKill = New String(){"excel", "iexplore"} Initialize String Array with Process names to be killed Step 2 – Get All Processes processList = Process.GetProcesses Get All Processes Step 3 – Get Current session Username currentUsername = System.Security.Principal.WindowsIdentity.GetCurrent().
Read more