I want to perfrom these steps:
- Open excel sheet stored at path say “C:\Users\username\Documents\UiPath\excelFolder\abc.xlsm”
- Select the required sheet say “Test Data”
- Using hot keys clear the sheet except the header
Condition: Excel application scope I cannot use as there are lots of issues coming up due this activity.
If there is any other way to clear the sheet do let me know.
PS : I tried using start process and open application but unable to open the required sheet.