Hello , I am copying data from 3 different excel files into a single excel file into different sheets. How do i dynamically rename the sheets ? Could someone help with this ?

Hi @diya_poovamma Check out the Updated XAML file ExcelMerge_Update.zip (91.6 KB) Regards Gokul

Dynamically name excel sheet

raja.arslankhan (Raja Muhammad Arslan khan) September 16, 2022, 3:42am 2

@diya_poovamma
Ok so you want to get sheetsname from 3 different files and want to create one excel corresponding data?

Topic		Replies	Views
How to copy all different sheets name in one excel file and dynamically create new excel file? Help excel , activities	9	1126	April 18, 2019
Excel operation on dynamic sheet name Activities excel , activities	5	844	November 7, 2022
Pass dynamic data table and sheet name in write range Help	4	1567	September 28, 2019
How to use rename sheet activity Studio excel , uiautomation , activities , studio , question , rename , rename-excel-workbook	6	595	June 22, 2023
Copy sheets to a new workbook and rename the Activities excel , activities , question	13	1805	May 9, 2022