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??
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.
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.
