How to generate an XML file from an XSD Schema?

Question

XSD

Good day, toasts. Who fumbles, tell me, I have a lot of data in Excel and I need to form this data in XML schemas, according to the XSD layout. But how to do it, I can't. I tried it in Excel, it says that the scheme is not intended for export. Help, who can do it. Files by link

Answer 1

1. Read what xml is. Study the structure
2. Study the schema structure (there is even a doc file)
3. Create xml using any means known to you (lxml, libxml, msxml2)
4. Validate against the provided schema.
5. Fix validator errors.
6. Get a valid xml schema.
There are also a lot of resources on the Internet that, according to the scheme, create pseudo xml with fake data, however, in them, most often not all the features of the scheme are taken into account.