Hi Folks, How to delete the specific workbook sheet in excel in UiPath? The Sheet name is “Sheet1”. Thanks in advance. Regards, Sharu

Hi @sharu_priya , Use Delete sheet activity. https://docs.uipath.com/activities/other/latest/user-guide/delete-sheet-x [image]

Yeah i saw this. But i do not have this activity in m studio. Which package needs to be installed for this? Regards, Sharu

Delete Sheet Activity is not Showing in modern also

Hi @sharu_priya Please try to this macro: Sub DeleteSheet() Dim sheetName As String sheetName = "Sheet1" Application.DisplayAlerts = False Worksheets(sheetName).Delete Application.DisplayAlerts = True End Sub Hope this helps, Best Regards

Hi @sharu_priya , You can use excel VBA as well to delete the sheet: Inside the excel application scope, insert the invoke vba. Sub vba_delete_sheet() Sheets(“SheetName”).Delete End Sub Regards,

Thank you @vishal.kp Can you please elaborate?

[image.jpeg] Is modern activity enabled?

Delete Specific Sheet From workbook

Help Studio

vishal.kp (vishal) April 12, 2023, 1:30pm 14

@sharu_priya , check this:

BlankProcess10.zip (8.6 KB)

Regards,

1 Like

Delete sheet from excel

Topic		Replies	Views
Delete a specified sheet from an Excel Activities excel , activities , question	6	10208	January 7, 2022
Delete sheet from excel Studio studio , question , activities_panel	5	327	May 16, 2024
How to delete EXCEL sheet from workbook Activities excel , activities , question	3	2498	July 4, 2022
How can I delete a sheet in the excel file? Studio studio , question , template	5	2666	November 5, 2021
Get workbook Delete Sheet Help excel , activities , question	12	4519	May 9, 2022

Delete Specific Sheet From workbook

Related topics