Thanks for your quick response. My back up plan was to go to macros. I was hoping more of Pega Robotics approach. I will try to give a shot to Data Table approach and see if I can get something out of it.
Posted: 5 years ago
Posted: 2 May 2017 9:22 EDT
Thomas Sasnett (ThomasSasnett)
Lead Robotics Architect
Are you trying to do this to the sheet so that it is visible to the user, or do you need to simply manipulate the data. If so, I would extract the data into a DataTable and then perform your operations on it there. You could then write it back to the Excel sheet in the correct order if needed. The post below has information on how to extract the Excel data to a DataTable that you could then manipulate in a C# script as needed.