title: paste data from xml file to Excel workbook
body: <p>I have an xml file which I created by extracting data from an Excel workbook. </p>
  
  <p><a href="http://www.2shared.com/document/wbAYcQ4F/XMLTest.html" rel="nofollow">http://www.2shared.com/document/wbAYcQ4F/XMLTest.html</a></p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;?mso-application progid="Excel.Sheet"?&gt;
  &lt;Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"&gt;
    &lt;Styles&gt;
      &lt;Style ss:ID="Default" ss:Name="Normal"&gt;
        &lt;Alignment ss:Vertical="Bottom" /&gt;
        &lt;Borders /&gt;
        &lt;Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000" /&gt;
        &lt;Interior /&gt;
        &lt;NumberFormat /&gt;
        &lt;Protection /&gt;
      &lt;/Style&gt;
      &lt;Style ss:ID="s16"&gt;
        &lt;Borders&gt;
          &lt;Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2" /&gt;
          &lt;Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2" /&gt;
          &lt;Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2" /&gt;
        &lt;/Borders&gt;
      &lt;/Style&gt;
      &lt;Style ss:ID="s17"&gt;
        &lt;Borders&gt;
          &lt;Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2" /&gt;
          &lt;Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2" /&gt;
        &lt;/Borders&gt;
      &lt;/Style&gt;
      &lt;Style ss:ID="s18"&gt;
        &lt;Borders&gt;
          &lt;Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" /&gt;
          &lt;Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2" /&gt;
          &lt;Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2" /&gt;
        &lt;/Borders&gt;
        &lt;Interior ss:Color="#16365C" ss:Pattern="Solid" /&gt;
      &lt;/Style&gt;
    &lt;/Styles&gt;
    &lt;Worksheet ss:Name="First Worksheet"&gt;
      &lt;Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="9" ss:DefaultRowHeight="15"&gt;
        &lt;Column ss:Index="3" ss:Width="54" /&gt;
        &lt;Row ss:Height="15.75" /&gt;
        &lt;Row&gt;
          &lt;Cell ss:Index="3" ss:StyleID="s16"&gt;
            &lt;Data ss:Type="Number"&gt;12345&lt;/Data&gt;
          &lt;/Cell&gt;
        &lt;/Row&gt;
        &lt;Row&gt;
          &lt;Cell ss:Index="3" ss:StyleID="s17" /&gt;
        &lt;/Row&gt;
        &lt;Row&gt;
          &lt;Cell ss:Index="3" ss:StyleID="s17"&gt;
            &lt;Data ss:Type="String"&gt;Some Text&lt;/Data&gt;
          &lt;/Cell&gt;
        &lt;/Row&gt;
        &lt;Row&gt;
          &lt;Cell ss:Index="3" ss:StyleID="s17" /&gt;
        &lt;/Row&gt;
        &lt;Row ss:Height="15.75"&gt;
          &lt;Cell ss:Index="3" ss:StyleID="s18" /&gt;
        &lt;/Row&gt;
      &lt;/Table&gt;
    &lt;/Worksheet&gt;
  &lt;/Workbook&gt;
  </code></pre>
  
  <p>The xml file contains data of the range I selected. The worksheet name, and in the range all values, and formatting (colours, borders etc) In this example only column C has a cell with a number, a cell with a string and a coloured cell, plus a border surrounding all data. When you open the file with Excel it shows the data exactly how it's extracted.</p>
  
  <p>Now I want to know if it's possible to extract this as an Excel.Range programmatically with all values and formatting, to paste it into a new Excel Workbook. Preferably without opening the xml file in Excel.</p>
  
  <p>Thanks in advance.</p>