Merge two different excel files into one excel file in c#

Hi;

I simply want to merge two excel files into another excel file. I guess i should use Intertor for that but i don't know how to use it, never use it before. May anyone help please... Thanks!

Re: Merge two different excel files into one excel file in c#

Hi,

1. Open excel to read

2. create new sheet in different file.

3. Read cell by cell from source and submitt it to newer one.

4. do the same thing for other source and finally save file and close it.

Re: Merge two different excel files into one excel file in c#

Not c# code sample but in case you are looking for tool to merge excel files, i wrote a small app to do so, here's the link.

http://jeeshenlee.wordpress.com/2010/09/23/jmc-excel-join-merge-combine-multiple-excel-sheets-or-excel-workbooks/

Re: Merge two different excel files into one excel file in c#

I guess it is too late to reply but I think people visiting this page can be benefitted with this macro.

It can merge excel 2010, 07 and 03 files into one file. Just two shortcut keys and it will merge all your sheets.