Get workbook Delete Sheet

[Palaniyappan (Palaniyappan P)]

Hi

we can use the Delete Sheet activity.

To get that activity, please install this package: BalaReva.Excel.Activities

we can pass the sheet name as input here to this select range activity and then delete with send hot key as per this page

Delete a sheet in Excel

Hi All, Hopefully this is a simple one and someone can give me a lead. I’ve created and excel scope with a blank workbook, and written two datatables into two new sheets. The workbook has the default “Sheet1” still, so I’d just like to delete it. I can’t see an excel activity for that, so have tried to do that just be including sending three hotkeys (Alt + h, d, s). which seems to delete the sheet. However, then I close the scope, close the workbook and when I open it up to check, Sheet1 is…

Cheers @Arun_Pondhe