Delete excel sheet without sheet name

Help Studio
1

Hai

I want to delete all data in excel sheet in 2 method ( 1st -with header, 2 nd - without header) , because in 1 st sheet i need header only and in 2nd sheet is in blank no data.

Delete sheet data without deleting sheetname and the data has A - ZZZ clmns the columns and dynamic, . But i want to delete the the datas in excel sheets

I don’t have BalaRava activity

2

Hi @Aarthy1 ,

Could you check with the below post :

You could use that part approach which uses Write Cell to perform what you require.

Another approach would be to use the Modern Excel Activities - Clear Sheet :
image

3

Hi @Aarthy1,

Method 1: Delete all data including header

  1. Use the “Excel Application Scope” activity to open the Excel file.
  2. Use the “Read Range” activity to read the data from the sheet.
  3. Check if the read data contains any rows using the “DataTable.Rows.Count” property. If it is greater than 0, proceed with the next step.
  4. Use the “Clear Range” activity to clear the entire sheet, including the header.

Method 2: Delete all data excluding header

  1. Use the “Excel Application Scope” activity to open the Excel file.
  2. Use the “Read Range” activity to read the data from the sheet.
  3. Check if the read data contains any rows using the “DataTable.Rows.Count” property. If it is greater than 1, proceed with the next step.
  4. Use the “Write Range” activity to write a blank row in the sheet starting from the second row until the last row to clear the data. Note that you should only write one blank row if there is only one data row in the sheet.
1 Like
4

Hai

I my UiPath there is no clear sheet activity

5

@Aarthy1 ,

Could you check if you have the Modern Design Experience enabled in the Project Settings.

image
image631×653 25.2 KB

Also, Let us know which version of UiPath Studio and Excel Activities do you have currently.

If possible update to the latest stable version available and check if you are able to get the above activity.