Merge the multiple excel into single excel using C#

Posted by Agopi.net under C# on 10/11/2011 | Points: 10 | Views : 4515 | Status : [Member] | Replies : 2
Hi Team,

How to merge the multiple excel file into single excel file by using the C# coding. (All the excel file will be in same location).




Responses

Posted by: Ndebata on: 10/11/2011 [Member] Starter | Points: 25

Up
0
Down
What do you mean by merging excel files
Is appending data from each file or creating multiple sheets based on the data from each file.

In any case you can do it by adding a reference to Microsoft.Office.Interop.Excel

Take a look at this link
http://www.dotnetperls.com/excel


Agopi.net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Agopi.net on: 10/11/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

I need to append the Data's from one file to another excel file. I have 10 excel files withe different name. Below are the examples.

001.xls
002.xls
003.xls
004.xls
005.xls
006.xls
007.xls
008.xls
009.xls
010.xls


The above all excel file data's will be copied into fresh excel file in the name of Merged.xls. So the output excel will have the all data's from the above 10 excel files. Also the format will not be change, and how the data's is appearing in the input file the same way i need the output data's (format should not change).

Agopi.net, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response