Renaming an Excel sheet

How can one rename an Excel sheet on UiPath

1 Like

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:

6 Likes

Hey @Nkululeko_Mindu_ZA

You can use hot keys for that purpose.

please see the attached solution.

renameasheet.xaml (9.7 KB) - By Using hot Keys.

Rename Worksheet.xaml (8.3 KB) - By using Invoke Code.

Let me know if you have any doubts on this.

Regards…!!
Aksh

18 Likes

Hi Guys,

Thank you very much for your assistance.

Cheers

Hi Akash,

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

Regards,
Priya

Hi @PD2,

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

renameasheet (1).xaml (9.7 KB)

Regards,
Arivu

no errors, just not renaming the sheet!

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

Regards,
Arivu

@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!

Thanks! You are always a big Help!

Hi ,

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

Regards
Balamurugan.S

7 Likes