Is it possible to export Excel Data to an XML Files where the XML schema has nested lists within other nested lists?
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: 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
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.
Here my sample XML Data:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Daten>
<Mitarbeiter>
<Vorname>Lukas</Vorname>
<Name>Rohr</Name>
<Department>BDTP</Department>
<Points>206</Points>
</Mitarbeiter>
<Workdays>
<Holiday>1</Holiday>
<Days>1</Days>
<Days>1</Days>
<Days>1</Days>
<Days>1</Days>
<Days>0</Days>
<Days>0</Days>
<Days>0</Days>
<Sickdays>
<Holiday>1</Holiday>
<Days>1</Days>
<Days>1</Days>
<Days>1</Days>
<Days>1</Days>
<Days>0</Days>
<Days>0</Days>
<Days>0</Days>
</Sickdays>
</Workdays>
</Daten>