title: Export Data from excel to an XML schema has nested lists within nested lists
body: <p>Is it possible to export Excel Data to an XML Files where the XML schema has nested lists within other nested lists?</p>
  
  <p>What I have tried so far:
  Googling - I have found one thread that states it can not be done as Excel is inherently a flat table: <a href="https://social.msdn.microsoft.com/Forums/vstudio/en-US/8ded1f7a-2f9c-4c5a-aec5-c7bd6c594976/convert-data-from-excel-to-xml-when-schema-includes-list-of-lists?forum=vsto" rel="nofollow noreferrer">https://social.msdn.microsoft.com/Forums/vstudio/en-US/8ded1f7a-2f9c-4c5a-aec5-c7bd6c594976/convert-data-from-excel-to-xml-when-schema-includes-list-of-lists?forum=vsto</a></p>
  
  <p>Setting up fake data of two nested lists in an XML file and importing it into Excel. Excel's automatic recognition system works, but even if I do not change any of the displayed data, Excel doesn't allow me to export the file back into XML.</p>
  
  <p>Here my sample XML Data:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;
  &lt;Daten&gt;
      &lt;Mitarbeiter&gt;
          &lt;Vorname&gt;Lukas&lt;/Vorname&gt;
          &lt;Name&gt;Rohr&lt;/Name&gt;
          &lt;Department&gt;BDTP&lt;/Department&gt;
          &lt;Points&gt;206&lt;/Points&gt;
      &lt;/Mitarbeiter&gt;
      &lt;Workdays&gt;
          &lt;Holiday&gt;1&lt;/Holiday&gt;
          &lt;Days&gt;1&lt;/Days&gt;
          &lt;Days&gt;1&lt;/Days&gt;
          &lt;Days&gt;1&lt;/Days&gt;
          &lt;Days&gt;1&lt;/Days&gt;
          &lt;Days&gt;0&lt;/Days&gt;
          &lt;Days&gt;0&lt;/Days&gt;
          &lt;Days&gt;0&lt;/Days&gt;
          &lt;Sickdays&gt;
              &lt;Holiday&gt;1&lt;/Holiday&gt;
              &lt;Days&gt;1&lt;/Days&gt;
              &lt;Days&gt;1&lt;/Days&gt;
              &lt;Days&gt;1&lt;/Days&gt;
              &lt;Days&gt;1&lt;/Days&gt;
              &lt;Days&gt;0&lt;/Days&gt;
              &lt;Days&gt;0&lt;/Days&gt;
              &lt;Days&gt;0&lt;/Days&gt;
          &lt;/Sickdays&gt;
      &lt;/Workdays&gt;
  &lt;/Daten&gt;
  </code></pre>