Filter Data and Delete Rows
Hi
I want to use Pega Robotics Studio capabilities to do the following on Excel :
1) Filter data on some condition
2) Delete the data filtered
3) Sort the table on a column
Thank You
Accepted Solution
Pegasystems Inc.
US
The best and simplest way to do this is to create macros in excel that do these things and then have the automation call the macros.
Hope this helps.
Cecil Howell, CSA | Senior Instructor | Pegasystems Inc.
Pegasystems Inc.
US
The best and simplest way to do this is to create macros in excel that do these things and then have the automation call the macros.
Hope this helps.
Cecil Howell, CSA | Senior Instructor | Pegasystems Inc.
Deloitte
US
Hi Cecil
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.
Pegasystems Inc.
US
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.
https://collaborate.pega.com/discussion/pega-robotics-excel-how