How can one rename an Excel sheet on UiPath
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
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
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!
@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