How clear the entire data in a excel sheet

Help Studio
, , ,
1

Hi Guys,

I have to clear all the data in this excel sheet. How can i do it ? is there any querey instead of using excel activities?

Thanks in Advance :slight_smile:

Screenshot 2022-12-05 114610

2

Hi @mohamedalthaf

How above this VBA code?

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

Check out this blog

How to clear all the contents in an excel sheet UiPath - RPA Learners(%22Sheet1,way%20of%20achieving%20this%20task.

Regards
Gokul

1 Like
3

Thanks @Gokul001 this works

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.