title: How can I export simple repeating data from excel as xml?
body: <p>I'm attempting to use the Excel 2007 XML Developers tools, but I'm not able to export a simple set of simple repeating data.</p>
  
  <p>I have a worksheet with headers, and columns of data.</p>
  
  <p>I have an xsd which describes (I think) a map of the data, with the first element repeating.</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;xs:schema targetNamespace="http://tempuri.org/FeedbackLookup.xsd" elementFormDefault="qualified" xmlns="http://tempuri.org/XMLSchema.xsd" xmlns:mstns="http://tempuri.org/XMLSchema.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema"&gt;
    &lt;xs:element name="FeedbackLookup"&gt;
      &lt;xs:complexType&gt;
        &lt;xs:sequence&gt;
          &lt;xs:element name="RevieweeInfo" maxOccurs="unbounded"&gt;
            &lt;xs:complexType&gt;
              &lt;xs:sequence&gt;
                &lt;xs:element name="RevieweeName" type="xs:string"&gt;
                &lt;/xs:element&gt;
                &lt;xs:element name="RevieweeTitle" type="xs:string"&gt;
                &lt;/xs:element&gt;
                &lt;xs:element name="ReviewLevel" type="xs:string"&gt;
                &lt;/xs:element&gt;
                &lt;xs:element name="RecipientName" type="xs:string" /&gt;
                &lt;xs:element name="RecipientEmail" type="xs:string" /&gt;
                &lt;xs:element name="RecipientTitle" type="xs:string" /&gt;
              &lt;/xs:sequence&gt;
            &lt;/xs:complexType&gt;
          &lt;/xs:element&gt;
        &lt;/xs:sequence&gt;
      &lt;/xs:complexType&gt;
    &lt;/xs:element&gt;
  &lt;/xs:schema&gt;
  </code></pre>
  
  <p>And mapped that to the headings in my xml file.  </p>
  
  <p><img src="https://i.stack.imgur.com/6w9lv.png" alt="Excel XML Pane"></p>
  
  <p>But when I click <code>Verify Map for Export</code> I get the following error popup:</p>
  
  <p><img src="https://i.stack.imgur.com/C3vCL.png" alt="A mapped element&#39;s relationship with other elements cannot be preserved"></p>
  
  <p>The elements are all mapped to the same page, and are all regular data columns.</p>
  
  <p><img src="https://i.stack.imgur.com/N1gF0.png" alt="Excel Header Row"></p>
  
  <p>What am I doing wrong?  At this point would it be faster to write the naive VBA to create the XML?</p>