IRobot

  In RPA as we work mostly with the excel application, there are so many operations that we usually perform on it. What if we are asked to rename a column of a DataTable? Let us see how to do it!!! dataTable .Columns( “old_ColumnName”) .ColumnName =  “new_ColumnName” Note: 1. old_ColumnName is the specific column that you want to rename 2. new_ColumnName is the column name with which you want to rename the above old column name with. Example Implementation using UiPath : Let us implement a workflow which takes a sample DataTable as input and we will try to  rename an existing column  of it from “Name” to “FirstName” Step 1: Drag “Build Data Table” activity into the design panel and populate it with some sample data. Step 2: Drag “Assign” activity into the design panel and fill it with above-mentioned code. Note: We are renaming “Name” column of above build DataTable to “FirstName” Step 3: Drag “Output Data Table” activity into the design panel and convert Datat...

  While automating business processes, we deal with a lot of files and might perform few activities on them like deleting, moving or renaming. Here, for now, let’s see how to delete multiple files from a folder!!! Array.ForEach(Directory.GetFiles(our_DirectoryPath),Sub(x) File.Delete(x)) Note: Replace our_DirectoryPath with your desired folder path Example Implementation using UiPath : Let us implement a project to delete multiple files from a given folder  Step 1: Drag  “Assign”  activity into the designer panel and supply the “Folder Path” to it. Step 2: Drag  “If”  activity to check if the folder contains any files. Directory.GetFiles(DirectoryPath).Count > 0 Step 3: Drag  “Invoke Code”  activity, supply the below-mentioned code to it to and pass the folder’s Path from which we have to delete the files. Array.ForEach(Directory.GetFiles(DirectoryPath),Sub(x) File.Delete(x)) Step 4: Now, execute the workflow to find the result 

  Mails are something that is widely used in the automation processes to receive inputs and to notify the users using the process. UiPath provides us the facility to download the attachments from particular mail. By default, it downloads all the attachments available, but what if we are planning to download only specific extension files? Let’s see how to do that!!! Filter = “.*(.xlsx|.XLSX|.xls|.pdf)” Note: Pass the EXTENSIONS according to your choice Example Let us implement a workflow that  read emails  from an account and then download the attachments according to our requirement. Step 1: Drag  “Get IMAP Mail Messages”  activity into the design panel and populate its properties with required fields. Step 2: Drag  “For Each”  activity into the design panel and pass the above “ newMailList ” variable to it and change the type in the properties window to “ System.Net.Mail.MailMessag e ” Step 3: Drag  “Message Box”  activity into the For Each ...