Delete a sheet in Excel

[vikas_reddy_Vicky (Vikas Reddy Kapu)]

Hi,

@sanjay21051990

Main (2) (1).xaml

Though I use Application.DisplayAlerts=False or Excel.DisplayAlerts=False, It is throwing a popup (Do you want to delete the sheet permanently). use this code instead

Delete a sheet in excel?

Just in case anyone else comes upon this question, an easier way to do this is to just use the invoke code activity and use VB.NET to remove it. You’ll need to add the Microsoft.Office.Interop.Excel reference if you don’t already have it. Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook xlApp = New Microsoft.Office.Interop.Excel.Application wb = xlApp.Workbooks.Open(filepath) xlApp.DisplayAlerts = False TryCast(wb.Sheets(sheetname), Mi…

Regards,
Vikas Reddy