title: Must XML end tag names match XML end tag names exactly?
body: <p>I have the following XML (test example):</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;&lt;?mso-application progid="Excel.Sheet"?&gt;
  &lt;Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
  xmlns:o="urn:schemas-microsoft-com:office:office"
  xmlns:x="urn:schemas-microsoft-com:office:excel"
  xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" &gt;
  &lt;Styles&gt;
  &lt;Style ss:ID="s21"&gt;&lt;NumberFormat ss:Format="@"/&gt;&lt;/Style&gt;
  &lt;/Styles&gt;
  &lt;Worksheet ss:Name="--"&gt;
  &lt;Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1" ss:StyleID="s21"&gt;
      &lt;Column ss:StyleID="s21" ss:Width="184"/&gt;
      &lt;Row&gt;   
          &lt;Cell&gt;&lt;ss:Data ss:Type="String"&gt;42&lt;/Data&gt;&lt;/Cell&gt;
  &lt;/Row&gt;&lt;/Table&gt;&lt;/Worksheet&gt;&lt;/Workbook&gt;
  </code></pre>
  
  <p>When trying to read the file using <a href="https://msdn.microsoft.com/en-us/library/360dye2a(v=vs.110).aspx" rel="nofollow noreferrer">DataSet.ReadXml()</a>, the following exception is generated: <code>The 'ss:Data' start tag on line 12 position 14 does not match the end tag of 'Data'. Line 12, position 43.</code><br>
  While all examples in W3C documentation show namespace-qualified end tags, MS Excel opens such file without any warnings.</p>
  
  <p>Setting <code>DataSet.Namespace = "ss";</code> doesn't change anything.  </p>
  
  <p>What can be done to read such file, preferably without adding extra libraries?</p>