Updated: Sep 28, 2020
The bot will remove duplicate records from an excel file based on some specified columns (single or multiple).
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.
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.