title: Excel XML table headings with spaces
body: <p>I'm exposing tables in my system via a webservice to use within Excel worksheets (as an XML Source). The tables can have headers that contain spaces and other characters not valid in XML element names. Excel is fine with that, and my system is fine with that, but the intermediate format (XML) is not.</p>
  
  <p>So, can the XML Source tell Excel (via schema or data) to use a table heading different from the element name? E.g. something like:</p>
  
  <pre><code>&lt;xs:element name="place-of-origin"&gt;
    &lt;xs:annotation&gt;
      &lt;xs:appinfo&gt;&lt;od:displayName&gt;Place of origin&lt;/od:displayName&gt;&lt;/xs:appinfo&gt;
    &lt;/xs:annotation&gt;
  &lt;/xs:element&gt;
  </code></pre>
  
  <p><strong>Edit:</strong> here's a <a href="http://paste.pocoo.org/show/351642/" rel="nofollow">sample XML file</a> and <a href="http://paste.pocoo.org/show/351645/" rel="nofollow">corresponding XSD</a>. Opening this in Excel yields a table with a column heading “sex_of_person” — so the question is: how can the XML or schema express that this heading should be “sex of person” (with spaces), or “#$!%” (excuse me), or any other string not valid as an <a href="http://www.w3.org/TR/xml/#NT-Name" rel="nofollow">XML name</a>?</p>