Joining excel files

Hi,

I am having trouble joining multiple excel files. on a day to day basis i generate multiple reports that all have the same header row. I want to merge all of the excel files into 1 file from a WinForm.

I want to be able to Select a directory which contains multiple excels, and then click a button that removes the header from all of the files (apart from the first 1) and then joins them all together, so my end result is 1 excel file.

e.g.

a folder on my desktop contains 3 excel files:

File 1 contains 5 rows (including header)
File 2 contains 10 rows (including header)
file 3 contains 2 rows (including header)

when I click the button on my form, i want it to create a new excel document which contains 15 rows (with 1 header row). so it only keeps the header from 1 file.

is anyone able to help me code this? I am completely new with using microsoft.office.interop.excel and just cant work out how to do it.

Many thanks,

AC

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

ramya bharath11y ago
Step 1. As mentioned in this link create a new xml http://regular-expressions.mobi/brackets.html

Step 2 in a loop read a xml as mentioned in this link and write the values in the newly created xml http://csharp.net-informations.com/excel/csharp-read-excel.htm