How to delete duplicate column in excel using UiPath


Step1: Read the excel with 'AddHeaders' unchecked.

Step2: Transpose the Resulting DataTable using 'Invoke Code' Activity.

Step3: Use  'Programming --> DataTable-->Remove Duplicate Rows' Activity to remove

Comments

Post a Comment

Popular posts from this blog

How to Bring a window in the Background to the Foreground in UiPath.

Solutions 1. Use " Activate " Activity 2. Use " Show Window " Activity . 3. Use " Minimize Window " Activity then " Maximize Window " Activity. 4. Use " Attach Window " Activity then Use " Activate  " or " Show Window " Activity. 5. If None of the above solution works(least likely scenario),then as a last resort automate - Selection of desired window from taskbar. Note: Also check for any missing .Net or Windows Update.
Read more

How To Download Specific Files From A Mail – In UiPath

Image
  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 ...
Read more

How To Delete Multiple Files – In UiPath

Image
  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 
Read more