Joining excel files

Question

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

Answer 1

OK... with a little more research I found my answer -------------------------------- using Microsoft.Win32; string myPath = ""; RegistryKey rk = Registry.LocalMachine.OpenSubKey("SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\App Paths\\SomeProg.exe", false); if(rk != null) { myPath = rk.GetValue("").ToString(); } ------------------------------------ In the code above I am getting the "Default" value which contains the programs executable path. The "false" parameter says that I want to open the key as read-only. I am not sure if the rk != null check is the right way to check that the key existed, but at first test this appears to work.