Hello, I am having multiple sheets in a single excel. i want to merge all these sheets into new sheet in same excel.When trying to merge all the data is not written in that sheet. How do i do it?

@sneha_arbole Try below steps. First use Excel Application Scope activity and create one workbook variable for this. And then use varWB.GetSheets to get all sheets from Excel file. Excel Application Scope ForEach item in varWB.GetSheets - Use Read Range activity and pass ite…

How to merge multiple sheets

Help

balupad14 (Balamurugan) January 3, 2021, 9:31am 4

Hi @sneha_arbole

This activity helps to merge the excel sheets from different files.

Regards
Balamurugan.S

1 Like

Topic		Replies	Views
Merge multiple excel sheets into single excel sheet (with multiple spreadsheets) Help datatable , excel , activities	1	3657	May 16, 2018
How to merge Data into one excel sheet Help datatable , excel , activities , question	7	2716	January 14, 2020
How to combine multiple excel data in to single sheet? Activities excel , activities , question	7	336	August 8, 2023
Merge - excel data Help datatable , excel , activities , question	7	1224	January 17, 2020
I wonder why there are no topics on merging multiple excel sheets into 1 here Studio studio , question , activities_panel	4	920	June 13, 2021

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

How to merge multiple sheets

Related Topics