Delete the whole data in sheet without deleting the sheet name

Help Studio
, ,
1

Hai

I needto delete the old data in Excel sheets without deleting the sheet names

Eg . In Excel there r 5 sheets . In that i want to remove the old data without deleting the sheet names

2

Hi @Aarthy1 ,

Have you tried using the Clear Sheet Activity ?

image

3

Hello @Aarthy1
Kindly Refer to this video, you may get some idea

If you are a classic user, to use modern activity try this

  1. Click the filter in the Activity panel
  2. Enable or check the modern activity
  3. Now you can use the modern activity excel
    image
4

It not visible

5

hi @Aarthy1
If you want to keep sheet and delete data simple make a Empty Datable and use write range activity and write in data sheet.

Regards
Mohini
Happy automation!!!

6

IMG_20230117_104009_441.jpg
IMG_20230117_104009_441.jpg1560×2080 963 KB

IMG_20230117_104029_868.jpg
IMG_20230117_104029_868.jpg3120×4160 3.08 MB

7

Hi @Aarthy1
change classic to modern
To enable or disable the modern experience for a project, in the Project panel, select Project Settings, then use the Modern Design Experience toggle from the General tab and reload the project .
thanks and regards
mohini sonule

8

@Aarthy1 ,

The Activity mentioned is a Modern Activity, available only when we enable the Modern Design Experience.

Could you try the Steps mentioned by @Gokul_Jayakumar in the above post and let us know if you cannot use Modern Design and would want to use only Classic Activities.