Excel delete

Help Activities
,
1

I needs to delete excel sheet data but we should not remove sheet headers

2

Hey @Arya_Squares ,

Better to keep an excel template and use it wherever you want.

Thanks,
Sanjit

3

@Arya_Squares - Can you explain more with a reference screenshot how does input looks like and what is the expected result.

4

Read the excel sheet to a variable dt then delete the sheet using delete sheet activity of balareva or excel then get an assign activity , give dt1=dt.clone then write range the dt1 with the sheet name to the excel

5

Please find the image below:
From manage package install balareva.excel.activities for delete sheet activity

image
image1541×697 39.8 KB

6

Hi @Arya_Squares,

kindly try below “Invoke VBA”

VBA code keep with “.txt” format (Deletesheet.txt)

image
image766×476 76.5 KB 

Sub Deletesheet(sheetName)
Sheets(sheetName).Delete
End Sub

image