title: How to merge two Excel workbook into one workbook in C#?
body: <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>