topic Re: remove duplicates from excel in University Forum

remove duplicates from excel

blazino17 — Thu, 15 May 2025 21:05:13 GMT

I need to duplicate an Excel file, move it to a specific directory, remove duplicate records from the moved excel file, and send an email to a client with the cleaned Excel file attached. How can i do this and also remove duplicate records? because i cant see any vbo that does this

Re: remove duplicates from excel

Chakkravarthi_PR — Fri, 16 May 2025 07:53:00 GMT

https://community.blueprism.com/t5/Product-Forum/Remove-Duplicates-from-excel/m-p/56058#M10309

check this

Re: remove duplicates from excel

blazino17 — Fri, 16 May 2025 10:26:34 GMT

This is the code I developed in the code stage, but it is not successfully removing duplicate records. Could you help review it and guide me in the right direction so it performs as intended?

Can you also assist? @sonuiiml @

@devneetmohanty07

Re: remove duplicates from excel

blazino17 — Fri, 16 May 2025 13:17:55 GMT

@MohamadDAKKOUR1

Re: remove duplicates from excel

blazino17 — Fri, 16 May 2025 14:44:42 GMT

Thank you, everyone! I have resolved the issue. It is now working correctly—I needed to pass the handle and workbook into the object instead of using a new data item, and also in the input range i used "B:B" instead of "A:A". That was what was causing the error.