Dynamically rename sheet name in one excel files

Hi,

Is there anyway to rename my original sheet name to new sheet name in one excel files using for each to loop or etc?

Thanks!

1 Like

Hi @phoenix123,

Refer the below workflow which explains how to rename a sheet using Invoke code activity.

Rename Worksheet (1).xaml (8.3 KB)

If you want to rename the sheet using send hot keys then refer the below workflow

renameasheet (1).xaml (9.4 KB)

2 Likes

@anil5 thanks for the files!

1 Like

Hi @phoenix123,

Have you tried this, is it working?

2 Likes

@anil5 hi sir! So sorry for the late reply was handle other use cases for my company yup it work, I use the file to renameasheet (1).xaml file yup it work for my cases! So i mark the solution for one of the files?
Thanks for your effort and solution!

Hi @phoenix123,

Can you close the topic if its working

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.