How to merge excel file?

Posted by Tripati.24 under C# on 9/9/2011 | Points: 10 | Views : 2015 | Status : [Member] | Replies : 2
Hi,

Actually I have two workbooks(i.e two excel files). Each workbook is having one worksheet(i.e excel sheet). Let's say Workbook1 have mysheet1 and workbook2 have mysheet2.
So how can I merge these two workbooks to a new workbook called Workbook3 so that in that new workbook it will contain 2 worksheets as mysheet1 and mysheet2 by using c# and without any third party tool. If that third party tool is free then not an issue.

If anybody know, then please try to help me out.

Thanks.




Responses

Posted by: T.saravanan on: 9/12/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Try this link...

http://www.codeproject.com/KB/office/datasettoexcel.aspx

Thanks,
T.Saravanan

Tripati.24, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Tripati.24 on: 9/28/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

Sorry T.saravanan. What ever I have asked and what ever you have given the link, its completely different.
I need merge of two excel sheets and in third excel, the two existing excel files will come.

I think without verifying you have given the link.

Thanks.

Tripati.24, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response