How to delete all the data from a sheet using delete range activity

Help Studio
, ,
1

I was trying to delete all the data from a excel sheet without knowing what is the range

so how can i delete all the data using delete range activity

2

Hi @indiedev91

Have a look on the video and docs

https://docs.uipath.com/activities/docs/excel-delete-range

Regards
Gokul

3

yes i have also watched the video , but let suppose i dont have to eneter a range , let suppose i enter empty " " or * isnt there any method like this which selcets all the data and delete

4

HI @indiedev91

You can try with Invoke VBA activity

Sub ClearSheet()
Sheets("Sheet1").Cells.Clear
End Sub

Regards
Gokul

5

Check this article, maybe it is helping you out https://uipath-survey.secure.force.com/CaseView/articles/Knowledge/How-to-use-Delete-Rows-activity-for-Studio-and-StudioX-profiles