Delete a sheet in Excel

[David_Johnston]

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 back (and as blank as ever). Have included a quick screenshot of my Excel Application Scope.

[David_Johnston]

Solution was to just send a Ctrl + S hotkey for save while we were sending hotkeys anyway.

Easy solution when you think about, thanks for the lead @aksh1yadav

[Chand (Chandani Dave)]

Alt + h then d and then ctrl + S these 3 hotkeys will work in sequence and no need to pass enter key?

[sanjay21051990 (sanjay shankhla)]

hi,
YOU can try using invoke code activity
microsoft.office.interop.excel
provides delete method() to to remove a sheet from a workbook Main (2) (1).xaml (13.5 KB)

[im_heathen (Lokesh R)]

Alt+h then d and then s and finaly ctrl+s,i think

[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