Hi Ravi,
Ideally if you try to read this data into a collection directly using any VBO, you always will face this issue. My recommendation here would be to get the list of all the header rows from excel. You can use a logic to iterate cells in first row and keep appending values to a collection till you find an empty cell. Then based on those values you can identify which values are duplicate in your case, get the index of those rows and based on that you can update the header name. If lets say you got fourth row as a duplicate which has the value PO#, update the cell 'A4' with the same value suffixed by some identifier like '_1' which should be 'PO#_1'
------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website:
https://devneet.github.io/Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.