Renaming an Excel sheet

excel

#1

How can one rename an Excel sheet on UiPath


#2

Hi,

UiPath does not have an activity to rename sheets yet.

Perhaps you can treat the problem as follows:

Read the Excel sheet and save it in a new Excel. (WriteRange activity automatically creates Excel and sheet)

I hope it helps you :slight_smile:


#3

Hey @Nkululeko_Mindu_ZA

You can use hot keys for that purpose.

please see the attached solution.

renameasheet.xaml (9.7 KB)

Let me know if you have any doubts on this.

Regards…!!
Aksh


How to rename the specific sheet on excel?
Renaming a sheet in Excel
#4

Hi Guys,

Thank you very much for your assistance.

Cheers


#5

Hi Akash,

Can try out the same workflow, it’s not working. Not sure if something changed within UiPath packages

Regards,
Priya


#6

Hi @PD2,

i checked its working fine what exception/error you are getting.

renameasheet (1).xaml (9.7 KB)

Regards,
Arivu


#7

no errors, just not renaming the sheet!


#8

Ok use this @PD2,
renameasheet (1).xaml (10.3 KB)

Regards,
Arivu


#9

@arivu96: I put the excel application selectors for the first send hotkey and that brings it to focus and also saved in the end. That did the trick!

Thank you!


#10

Thanks! You are always a big Help!


#11

Hi ,

Here I have attached a custom activity to rename the excel sheet.

Regards
Balamurugan.S