How to merge excel file?

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

Latest Posts