Delete Sheet

Help
, ,
1

How to delete sheet runtime in excel?

1 Like
2

Hi @Babita22,

Please use the Delete Sheet activity.

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

Thanks and regards,
David

4 Likes
3

It is not working Runtime

1 Like
4

Hi.

It can be deleted using a hot key.

5

using hotkey we cant give specific sheet name.

6

Hi
hope this thread would help you resolve this

Cheers @Babita22

7

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

8

It is not working Runtime.

9

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
1 Like
10

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:

image
image1303×636 23.7 KB

Sample : Babita22.zip (30.5 KB)

Package info :

Regards
Balamurugan.S

8 Likes
11

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