title: Copy an Excel Sheet to another Workbook in C#
body: <p>I have an excel sheet which contains a Signature Line. I tried to copy this sheet to another workbook, but the values of the sheet can be copied, except the signature line. I think this copy method is based on cells.</p>
  
  <p>How to get signature line to another workbook. Here is my code</p>
  
  <pre><code>        Excel._Application xlApp;
          Excel.Workbook xlTemplateWB;
          Excel.Workbook xlTempWB;
          object missing = System.Reflection.Missing.Value;
  
          xlApp = new Excel.Application();
          xlApp.Visible = true;
  
          //Open Bench Sheet Template
          xlTemplateWB = xlApp.Workbooks.Open(@"C:\TempProjects\test.xlsx", 0, true, 5, "", 
          "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
  
          //Save As a temporary workbook
          xlTemplateWB.SaveAs(@"C:\\TempProjects\mytmp.xlsx");
  
          //Open temporary workbook
          xlTempWB = xlApp.Workbooks.Open(@"C:\TempProjects\my.xlsx", 0, false, 5, true, "",
          true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
  
          xlTemplateWB.Worksheets.Copy(xlTempWB.Worksheets["Sheet1"]);
          xlTemplateWB.Close(true, missing, missing);
          releaseObject(xlTemplateWB);
  
          xlTempWB.Save();
  
          //Close Workbooks
          xlTempWB.Close(true, missing, missing);
          xlApp.Quit();
  
          //Release Objects
          releaseObject(xlTempWB);
          releaseObject(xlApp);
  </code></pre>