title: XML schema for Excel XML exportation
body: <p>I'm getting mad trying to create an XML schema to transform an Excel file to an XML file.
  The sample .xls file has two cell with </p>
  
  <ul>
  <li>the name of the event and</li>
  <li>the name of the location
  then there's a table with a session for every column and a rider's name for every row.</li>
  </ul>
  
  <p><a href="http://www.cheekychaz.com/example/1.jpg" rel="nofollow">This is a screenshot of the spreadsheet.</a></p>
  
  <p>To save as XML data I need to make the XML schema and I've achived this using the <a href="http://www.microsoft.com/download/en/details.aspx?id=3108" rel="nofollow">Excel 2003 Add-in: XML Tools Add-in</a>.
  So I have this XML schema:</p>
  
  <pre><code>&lt;?xml version='1.0' encoding='UTF-16'?&gt;
  &lt;!-- Created from XmlMap.Name: Results_mapping --&gt;
  &lt;!-- XmlMap.DataBinding.SourceUrl:  --&gt;
  &lt;xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
      &lt;xsd:element nillable="true" name="Results"&gt;
          &lt;xsd:complexType&gt;
              &lt;xsd:sequence minOccurs="0"&gt;
                  &lt;xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true" name="rider" form="unqualified"&gt;
                      &lt;xsd:complexType&gt;
                          &lt;xsd:sequence minOccurs="0"&gt;
                              &lt;xsd:element minOccurs="0" nillable="true" type="xsd:string" name="Column1" form="unqualified"/&gt;
                              &lt;xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="Column_1st_session" form="unqualified"/&gt;
                              &lt;xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="Column_2nd_session" form="unqualified"/&gt;
                              &lt;xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="Column_3rd_session" form="unqualified"/&gt;
                          &lt;/xsd:sequence&gt;
                      &lt;/xsd:complexType&gt;
                  &lt;/xsd:element&gt;
              &lt;/xsd:sequence&gt;
          &lt;/xsd:complexType&gt;
      &lt;/xsd:element&gt;
  &lt;/xsd:schema&gt;
  </code></pre>
  
  <p>which generate the following XML code:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;
  &lt;Results xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;
      &lt;rider&gt;
          &lt;Column1&gt;Mike&lt;/Column1&gt;
          &lt;Column_1st_session&gt;5&lt;/Column_1st_session&gt;
          &lt;Column_2nd_session&gt;10&lt;/Column_2nd_session&gt;
          &lt;Column_3rd_session&gt;8&lt;/Column_3rd_session&gt;
      &lt;/rider&gt;
      &lt;rider&gt;
          &lt;Column1&gt;John&lt;/Column1&gt;
          &lt;Column_1st_session&gt;5&lt;/Column_1st_session&gt;
          &lt;Column_2nd_session&gt;9&lt;/Column_2nd_session&gt;
          &lt;Column_3rd_session&gt;8&lt;/Column_3rd_session&gt;
      &lt;/rider&gt;
      &lt;rider&gt;
          &lt;Column1&gt;Lea&lt;/Column1&gt;
          &lt;Column_1st_session&gt;4&lt;/Column_1st_session&gt;
          &lt;Column_2nd_session&gt;9&lt;/Column_2nd_session&gt;
          &lt;Column_3rd_session&gt;8&lt;/Column_3rd_session&gt;
      &lt;/rider&gt;
  &lt;/Results&gt;
  </code></pre>
  
  <p>That's not completely bad but I'd like to have something like</p>
  
  <pre><code>&lt;rider name="Mike"&gt;
  &lt;session name="1st_session"&gt;5&lt;/session&gt;
  &lt;session name="2nd_session"&gt;10&lt;/session&gt;
  &lt;session name="3rd_session"&gt;8&lt;/session&gt;
  &lt;/rider&gt;
  </code></pre>
  
  <p>can anybody please help me?
  Thanks!</p>