How to rename multiple excel sheets in a folder

[Edward_Tan]

Hi all,

I have a FOLDER with multiple excel files, all have the same structure and different sheet name. All files only have one sheet…
I want to take rename all sheet name to “New”

Thanks,

[Sudharsan_Ka]

Hi @Edward_Tan

Try this

• For Each File in Folder
  • Excel Process Scope
    • Use Excel File
      • Get Workbook sheet and index as 0 store in a variable
      • Rename Sheet
        
        

Regards
Sudharsan

[supermanPunch (Arpan)]

@Edward_Tan

rename all sheet name to “New”

Hi @Edward_Tan ,

We have the Rename Sheet Activity in the Modern Design, do check it and let us know if you require further help.