How to Remove duplicate columns inside excel

[Venkata_NitishM]

Hi, I have an excel sheet, in that i have a duplicate data, how can i remove duplicate data, i read excel sheet data in the form of collection, here i need to do compare the collections how i can do comparision??

[Venkata_NitishM]

Hi sudheer, i am getting this exception: Internal : Could not execute code stage because exception thrown by code stage: Cannot run the macro 'Blueprism systest.xlsm'. The macro may not be available in this workbook or all macros may be disabled.

[ChandraAddepall]

Hi Prateek , Can you please elaborate it that means how to pass shortcut key(Alt+A+M) in send keys

[JivankumarKedar]

You can use OLEDB to get the desired o/p. All you need is SQL Query which will return you the result in a collection. Write back this collection to the file. Sample Query be like: select min[ur_identifier_Header] from [SheetName$] group by [Header1], [Header2] so on..... First u need to set connection to excel sheet using OLEDB VBO. That link u can have in the portal. Search for OLEDB.

[parthasarathy]

Use Global send keys Events to pass (Alt+A+M)  in the excel