title: How do I export multiple Excel rows to an XML file using an XML schema?
body: <p>I have an Excel worksheet with a list of cars:</p>
  
  <p><a href="https://i.stack.imgur.com/ZEEvm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZEEvm.png" alt="Row 1 contains column descriptors for vehicle attributes"></a></p>
  
  <p>I created an XML schema document to allow me to export the worksheet to XML. The schema is as follows:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="no" ?&gt;
  &lt;xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
      &lt;xsd:element name="Root"&gt;
          &lt;xsd:complexType&gt;
              &lt;xsd:sequence&gt;
                  &lt;!--Below are the primary vehicle descriptors - essentially the attributes for the cars--&gt;
                  &lt;xsd:element name="Brand" type="xsd:string"/&gt;
                  &lt;xsd:element name="Model" type="xsd:string"/&gt;
                  &lt;xsd:element name="Colour" type="xsd:string"/&gt;
                  &lt;xsd:element name="Price" type="xsd:string"/&gt;   
              &lt;/xsd:sequence&gt;
          &lt;/xsd:complexType&gt;
      &lt;/xsd:element&gt;
  &lt;/xsd:schema&gt;
  </code></pre>
  
  <p>In Excel, I clicked Developer > Source > XML Maps > Add, then I selected the XML schema file from above and added it to my worksheet. 
  I mapped each element in the XML Source window to the corresponding column in the Excel worksheet (the "Brand" element is mapped to A:A, the "Model" element is mapped to B:B, etc.). </p>
  
  <p><a href="https://i.stack.imgur.com/J9b89.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/J9b89.png" alt="enter image description here"></a></p>
  
  <p>When it came to exporting the mapped worksheet (using Developer > Export, then selecting a directory and file name), the resultant XML file only had the first row of data from the worksheet. As my XML mapping included the title row of the worksheet, the XML file looked like this:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;
  &lt;Root&gt;
      &lt;Brand&gt;Brand&lt;/Brand&gt;
      &lt;Model&gt;Model&lt;/Model&gt;
      &lt;Colour&gt;Colour&lt;/Colour&gt;
      &lt;Price&gt;Price&lt;/Price&gt;
  &lt;/Root&gt;
  </code></pre>
  
  <p>I've looked through numerous different help pages, and I'm not sure how to make my XML file store every row (all five, including the title row) of the Excel worksheet.</p>