• Neo

Bot 2: Remove duplicate rows in Excel

Updated: Sep 28

Scenario

The bot will remove duplicate records from an excel file based on some specified columns (single or multiple).


Benefits

  • Useful for any cases that uses excel.

  • Fast and efficient.

How it works

User has to specify the excel file and sheet name, and based on what column (single or multiple) the bot will remove the duplicate records.


Techniques used

  • Excel activities.

  • CSharp scripting: The bot has a C# script that contains a method, this method receives a DataTable and a list of columns as parameters and output a list of row indexes that need to be removed from the DataTable.

How to use

  • Download the bot package (.aupkg) here.

  • Open Auteros Studio. if you don't have Auteros Studio installed, you can get it here.

  • Open the Explorer tab, from the root Auteros Node, right click and then click Import Workflow Package, then point to the ExcelRemoveDuplicateRows.aupkg file.

  • Open the workflow RemoveDuplicateRows, select the Open Workbook activity and change the FilePath to your Excel file.

238 views

Contact

+84 (90) 541-873

  • LinkedIn
  • Facebook
  • Twitter
  • YouTube

Copyright ©2020 by Auteros. All rights reserved.