Skip to content

Instantly share code, notes, and snippets.

@pmorch
Last active December 9, 2016 15:14
Show Gist options
  • Save pmorch/8fa7c15ef120dfb345f8fc25e8f415d8 to your computer and use it in GitHub Desktop.
Save pmorch/8fa7c15ef120dfb345f8fc25e8f415d8 to your computer and use it in GitHub Desktop.
Excel XML Import problems with Regional Format Danish
<?xml version="1.0" encoding="iso-8859-1"?>
<statistics xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="schema.xsd">
<record>
<name>name</name>
<value>123.45</value>
</record>
</statistics>
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
<xs:element name="statistics">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="unbounded" ref="record"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="record">
<xs:complexType>
<xs:sequence>
<xs:element ref="name"/>
<xs:element minOccurs="0" ref="value"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="name" type="xs:string"/>
<xs:element name="value" type="xs:double"/>
</xs:schema>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment