Excel delete

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

Hey @Arya_Squares ,

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


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

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

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

Hi @Arya_Squares,

kindly try below “Invoke VBA”

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

Sub Deletesheet(sheetName)
End Sub