Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1380
Home > Forums > C# >

Merge the multiple excel into single excel using C#

Posted by Agopi.net under C# on 10/11/2011 | Points: 10 | Views : 5771 | Status : [Member] | Replies : 2
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
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).



Reply | Reply with Attachment
Alert Moderator 

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

Latest Posts