I have searched for the solution in UiPath forum and found most of them suggest Either:
1.> Read the data in DT and remove the rows from DT and write he DT in excel using "Write Range " activity. Or
2.> Using select range activity and then putting hot keys Ctrl + “-”
But I need some better solution as either of the above solution has its own limitation.
1.> Why do I have to read the whole data when I know I need to delete top 5 rows.
2.> Using Send Hot keys is not good if that hot key already defined in OS for some other activity.
Can any one suggest something better with either “Invoke Method” or “Invoke Code” activity?
For example lets say excelInstance is the Workbook object. How we can use invoke method activity to delete top 5 rows.