title: Copy Excel template in another template with pictures
body: <p>I try to merge two Excel templates together in C#. Everything works fine except for the pictures in the second template that aren't merged.</p>
  
  <p>I use the following steps to achieve my objective :</p>
  
  <ol>
  <li>Load the first template</li>
  <li>Add content to the first template</li>
  <li>Load the second template</li>
  <li>Copy the template's content in the clipboard</li>
  <li>Paste the clipboard's content in the current <code>Worksheet</code></li>
  </ol>
  
  <p>Sadly, I have no control over the templates themselves as they are provided by the client and I can't change them.</p>
  
  <p>Here's the code :</p>
  
  <pre><code>public static void MergeTemplates()
  {
      ExcelApp app = new ExcelApp();
      var path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
      app.Workbooks.Open($"{path}\\Excel1.xltx", true);
      var workbook = app.Workbooks[1];
      var sheet = workbook.Worksheets[1];
      sheet.Range["A1"].Value = "Sometext";
  
      //Loading the second template, which has images.
      var xlTemp = app.Workbooks.Open($"{path}\\Excel2.xltx", true);
      var xlSheetTemp = xlTemp.Worksheets[1];
  
      xlSheetTemp.Range["A1", "C10"].Copy();
  
      //Add the second template at the end of the first
      sheet.Range["A2","C11"].PasteSpecial();
  
      xlTemp.Close();
  
      workbook.SaveAs($"{path}\\Test.xlsx");
      workbook.Close();
      app.Quit();
  }
  </code></pre>
  
  <p>At the end, the images of <code>Excel2.xltx</code> aren't imported in the saved <code>Test.xlsx</code> document.</p>
  
  <p>How can I merge the two templates so that the images will be included?</p>