I need to create an XML file containing data from Excel from an existing schema. The schema includes nested repeating elements, and Excel doesn’t seem to like nested repeating elements. When I try to verify that the XML will export, I get the “lists of lists” error indicating that I won’t be able to export the data.
As an example of what I’m trying to do, imagine annual sales of games, where the types of games are not explicitly defined in the schema but are assigned to the GameName element instead.
Here is a simplified example of the structure of the schema. Please excuse any syntax issues; I’m only trying to get data into the format and don’t require a complete grasp of the schema formatting.
<xsd:extension gYear=”YearGameSales”> <xsd:extension string=”GameNameDetail”> <xsd:extension name=”GameSales”>
Where YearGameSales repeats for each year and is therefore complex, GameName repeats for each game and is therefore comples, and GameSales is the value of the sales and is simple.
And here is the type of table I have in Excel:
Year Jacks Chess Checkers 2000 100 40 120 2001 400 30 100 2002 50 100 50
Can I even use Excel to get these data into the required schema? If so, how? If not, how do I get the data from Excel into XML that works with the schema? I’m fairly new to XML and schema, but I’m reasonable proficient in Excel.
Finally, the Excel and Office help files and online help have been incredibly opaque or unhelpful for working with XML in Excel.