Delete old data in excel sheet without remove sheet name

Hi team

I want to delete datas in excel sheet without deleting sheet name

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.

Hi @Aarthy1 ,

Have you tried using the Delete Range Activity.

Alternately, using a Write Cell Activity would also help, Check the below post on the method :

Hello @Aarthy1 ,

  1. Use read range to get the datatable in a datatable object.
  2. Filter the data.
  3. Use Clear Sheet activity to clear the sheet.
    4 Use write range to write the filtered data.

Thanks,
Sanjit