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

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

Hi @sagar.raval

Have a look on the video and docs

Regards
Gokul

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

HI @sagar.raval

You can try with Invoke VBA activity

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

Regards
Gokul

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