Delete sheet in Excel

[Saikat_Chowdhury]

How to delete a sheet in Excel?

[Palaniyappan (Palaniyappan P)]

Kindly have a view on this with Delete Sheet activity

Delete a Sheet from a Excel

Hi Trying to delete a sheet from a Excel which contains Data,I am deleting the sheet through vb.net,here when the sheet is empty it is deleting,when it is non empty the sheet is not get deleted, please suggest me with this please verify code i have used Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As Microsoft.Office.Interop.Excel.Worksheet Dim rng As Microsoft.Office.Interop.Excel.Range excel = New Microsoft.Office.Inte…

Cheers @Saikat_Chowdhury

[Saikat_Chowdhury]

I tried the same. Its not showing any error but its not deleting the sheet.

[Saikat_Chowdhury]

I was using the activity inside the excel app scope. Now, I used outside that and its working now.
Thanks

[Palaniyappan (Palaniyappan P)]

That’s great
Cheers @Saikat_Chowdhury

[Palaniyappan (Palaniyappan P)]

Kindly let know for any queries or clarification
@Saikat_Chowdhury