@sophia111
Please follow the below suggested actions.
1. Launch Excel - Open the Workbook
2. Read from Excel Worksheet and read your required range of columns
3. convert you datable column into list using "Retrieve data table into list"
4. Use remove duplicate items from list to remove your duplicate values
Sample Excel:
Before Duplicate removal:
After duplicate removal:
Full flow:
Code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Documents\\Workflow_duplicate.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
Variables.RetrieveDataTableColumnIntoList DataTable: ExcelData ColumnNameOrIndex: $'''workflow name''' ColumnAsList=> WorkflowList
Variables.RemoveDuplicateItemsFromList List: WorkflowList IgnoreCase: False
Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟
