I have multiple files where the need to merge all in separate excel in one sheet, I am able to merge all files in a single sheet, but I want to copy data with all sheets headers. As it’s copying first sheet header with data for rest of the sheets it’s copying data not copying header.

Hi @balkishan So you need to add headers of all the excel files in your output file one below the other. So to do that, I guess this type of flow is what you need. Have a loop iteration counter. If 1, do a write range to your output datasheet. If greater than one, get the row count of your output…

Merging multiple excel files

Help

Jan_Brian_Despi (Jan Brian Despi) April 15, 2019, 6:11am 4

Hi @balkishan,
Have you already read this one by @Lahiru.Fernando?

Hope this helps. THanks

Topic		Replies	Views
Merging Excel Help	9	1378	April 14, 2019
Merge data Help	50	2538	August 24, 2019
Unable to Merge different excel files into one Studio excel , activities , question	10	1047	October 13, 2021
Append Data From different Excel files to one file without Column headers Studio studio , question , workflow_diff	12	693	September 21, 2022
Hi I want to merge multiple csv file data in one csv file. but i want only one header but save all files of header(in screenshot line number 2,7,9) please send solution Activities excel , activities , question	4	393	May 24, 2023

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Merging multiple excel files

Related Topics