How to merge two excel workbook into one workbook in c#?
<p>Let us consider that I have two excel files (Workbooks) in local. Each excel workbook is having 3 worksheets.</p>

<p>Lets say WorkBook1 is having Sheet1, Sheet2, Sheet3</p>

<p>Workbook2 is having Sheet1, Sheet2, Sheet3.</p>

<p>So here I need to merge these two excel workbook into one and the new excel workbook that is let's say Workbook3 which will have total 6 worksheets (combination of workbook1 and workbook2).</p>

<p>I need the code that how to perform this operation in c# without using any third party tool. If the third party tool is free version then its fine.</p>

<p>Please try to help me out. Its quite urgent. For more clearification please feel free to ask.</p>

<p>Thanks in advance...</p>
