How to delete particular sheet from Excel without hotkeys by using coding

[sayli]

pls let me know if u have solution without using hotkeys

[lakshman (Ganta lakshman)]

@sayli,

Please check below thread. It will help you.

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…

[sayli]

ya i check but not working fa me.its showing like excel-read only and sheet remains as it is.if u have any ex workflow pls send me

[indra]

@sayli There is a custom activity which was created by @balupad14 so you can use
Refer This

[sayli]

thanks indra