XSD Schema sample

Email
Home
XSD Schema sample
XSD schema to load XML data to Excel.

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element nillable="true" name="dataroot">
<xsd:complexType>
<xsd:sequence minOccurs="0">
<xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true" name="gemba" form="unqualified">
<xsd:complexType>
<xsd:sequence minOccurs="0">
<xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="ID" form="unqualified"></xsd:element>
<xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="wid" form="unqualified"></xsd:element>
<xsd:element minOccurs="0" nillable="true" type="xsd:string" name="portfolio" form="unqualified"></xsd:element>
<xsd:element minOccurs="0" nillable="true" type="xsd:dateTime" name="sow" form="unqualified"></xsd:element>
<xsd:element minOccurs="0" nillable="true" type="xsd:dateTime" name="eow" form="unqualified"></xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="generated" form="unqualified" type="xsd:dateTime"></xsd:attribute>
</xsd:complexType>
</xsd:element>
</xsd:schema>