How can one rename an Excel sheet on UiPath
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
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.
Thank you very much for your assistance.
Can try out the same workflow, it’s not working. Not sure if something changed within UiPath packages
i checked its working fine what exception/error you are getting.
renameasheet (1).xaml (9.7 KB)
no errors, just not renaming the sheet!
@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!
Thanks! You are always a big Help!
Here I have attached a custom activity to rename the excel sheet.