Creating an XML file with a specific schema

Originally Posted by papusale

Thanks regress! This actually worked, and it also supports special characters!

One slight thing though;
at the very beginning of my XML schema it says: <?xml version="1.0"?>, and under it <unapproved xmlns:sql="urn:schemas-microsoft-com:xml-sql">
at the very beginning of excel XML file it says: <?xml version="1.0" encoding="UTF-8" standalone="true"?>

Is there a way to change it to exactly correspond to my XML schema?

Open the xml file in notepad and simply replace the lines (or even better, insert the lines in your xsd).

Originally Posted by papusale

Also regress,
The map.xsd has "NewsItemRow" and "NewsItemTable" instead of "Products".
When I tried to change them to "Products", it gave me an error while trying to load the map in Excel: "Cannot load the specified XML or schema source".

Download an XML editor and modify the name of NewsItemRow element in definition, meaning the change will be applied on the whole document (NewsItemTable can be amended similarly or as described above, in notepad, since those are only two lines).

Technically, you should be able to use Product and Producs in the xsd file, but it somehow doesn't work with the definition from http://bitwizards.com/blog/november-...rksheet-to-xml. I have an xsd at my workplace with which it works, but I don't have access to it right now. If you google other definitions, you will surely come across a solution. As I said above though, you can amend it in every XML editor as well.