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
How to merge two excel files in one template Help studio	1	1277	December 17, 2018
Merging Excel Help	9	1569	April 14, 2019
Merge data Help	50	3551	August 24, 2019
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	531	May 24, 2023
Append Data From different Excel files to one file without Column headers Studio studio , question , workflow_diff	12	942	September 21, 2022

Merging multiple excel files

Related topics