Delete Sheet

How to delete sheet runtime in excel?

1 Like

Hi @Babita22,

Please use the Delete Sheet activity.

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

Thanks and regards,
David

1 Like

It is not working Runtime

1 Like

Hi.

It can be deleted using a hot key.

using hotkey we cant give specific sheet name.

Hi
hope this thread would help you resolve this

Cheers @Babita22

@Babita22
What about using a hotkey after “ExcelSelectRange”?

It is not working Runtime.

You can use Invoke VBA for delete that specific sheet
ex

Sub VBA_Delete_Sheet2()
For Each Sheet In ActiveWorkbook.Worksheets
     If Sheet.Name = "Sheet1" Then
          Sheet.Delete
     End If
Next Sheet
End Sub

Hi @Babita22,

Welcome to UiPath Community Forum !

Here I have attached the sample to delete the sheet …

Before Delete :

image
After Delete :
image

Design Screen:

Sample : Babita22.zip (30.5 KB)

Package info :

Regards
Balamurugan.S

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.