Convert xs:Enumerations in XSD to dropdown lists in Excel
- by ashwnacharya
I have an XSD file which contains the schema for my XML.
The XSD file contains an xs:Enumeration definition, which allows me to choose between 5 options as a value for one of the nodes.
Now, we want to be able to generate this data through Excel, so that non techie people can create it...
When I import this XSD file into Excel, i want the xs:enumeration values to be listed as dropdowns.
How do I get to do that?
Edit: Starting a bounty. To win, I need a working sample code for this :)