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…

Hi @balkishan Do it in a loop, For Each File in FileList { -> Excel Application Scope -> Read Range (make sure Include Headers is checked) -> Append Range (output of step2) to new Excel } Regards, Karthik Byggari

@KarthikByggari I did that bro, it’s copying the data and merge all excel sheets data in single sheet, but it copying the first sheet headers but rest of the files only data not headers.

Hi @balkishan , Have you already read this one by @Lahiru.Fernando ? [image] Read excel from a given file folder Help Hi… I’m sorry… my mistake… This is working fine. And it adds all the data in excel files into one file… Check it out… merge datatable.xaml (9.8 KB) Sorry…

In the Read Range Activity, uncheck the following option and try. AddHeaders - When selected, the column headers from the specified spreadsheet range are also extracted. By default, this check box is not selected.

@Jan_Brian_Despi Already checked this one bro, My requirement is different.

@KarthikByggari tried not worked bro

@Lahiru.Fernando Exactly bro, Means I want to copying the complete sheet with headers. And same for every sheet in a single sheet.

Then I suggest, Make sure Add Headers is included. Take headers from data table into one data row and use two append activities. Please try and let me know. Append range - for headers Append range - for data table

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	1297	December 17, 2018
Merging Excel Help	9	1635	April 14, 2019
Merge data Help	49	3828	August 21, 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	560	May 24, 2023
Append Data From different Excel files to one file without Column headers Studio studio , question , workflow_diff	11	1007	September 21, 2022

Merging multiple excel files

Related topics