how to delete a sheet in excel using uipath commands and save the file…

Hi @shrganes , Please refer below post. @ddpadil [image] How to delete a sheet from excel or clear its data? Help Here we go. Just make sure excel is in the foreground while running the workflow. DeletExcel.xaml (5.8 KB) Regards, Arivu

@shrganes , Refer this, Delete Sheet Regards, Dominic :slight_smile:

thank you… i am able to delete it… but once i reopen the file the sheet still exists…how to over come that…??

Hi @shrganes , Try After delete save the excel file. Using send hot key ALT+H+D+S Regards, Arivu

what is the option for it… Ctrl S??

[image] arivu96: ALT+H+D+S use Send hot Key activity Alt + h then d and then ctrl + S Regards, Arivu

Alt F+S helps in saving the file

or ALT 1… helps in saving an excel file

Great then use the key to save the file. Regards, Arivu

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…

Delete a sheet in excel?

Learning Hub Academy Feedback

Dominic (Dominic) January 30, 2018, 7:07am 3

@shrganes, Refer this,
Delete Sheet

Regards,
Dominic

Deleting sheet

Blank Excel Sheet deletion

Topic		Replies	Views
Delete Multiple sheet in uipath Studio	4	1092	August 15, 2021
Delete a sheet in Excel Help excel	5	18995	June 27, 2018
Delete Specific Sheet From workbook Studio studio , question , activities_panel	17	1783	April 13, 2023
Delete Excel sheet Academy Feedback	2	3157	November 27, 2019
Invoke code - Exception has been thrown by the target of an invocation Studio activities , studio , question , activities_panel	4	1992	May 17, 2022

Delete a sheet in excel?

Related topics