title: import an xml file generated by Excel in Python
body: <p>I have an xml file generated by an excel software. The file is done this way:</p>
  
  <pre><code>&lt;?xml version="1.0"?&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"
   xmlns:html="http://www.w3.org/TR/REC-html40"&gt;
   ...
   &lt;Worksheet ss:Name="Table1"&gt;
    &lt;Table ss:ExpandedColumnCount="9" ss:ExpandedRowCount="162" x:FullColumns="1"
     x:FullRows="1" ss:DefaultRowHeight="15"&gt;
     &lt;Column ss:AutoFitWidth="0" ss:Width="110.25" ss:Span="8"/&gt;
     &lt;Row ss:AutoFitHeight="0"&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Sezione&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Bambino&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Sesso&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Luogo di nascita&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Data di nascita&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Indirizzo&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;CAP&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Città&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Accompagnatori&lt;/Data&gt;&lt;/Cell&gt;
     &lt;/Row&gt;
     &lt;Row ss:AutoFitHeight="0"&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;ARANCIONE&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;pippo &lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Maschile&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Mirano (VE)&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;2000-02-08&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;Via xx, 10&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;00000&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;xxx&lt;/Data&gt;&lt;/Cell&gt;
      &lt;Cell&gt;&lt;Data ss:Type="String"&gt;xxx mmm&lt;/Data&gt;&lt;/Cell&gt;
     &lt;/Row&gt;
    &lt;/Table&gt;
   ...
   &lt;/Worksheet&gt;
  &lt;/Workbook&gt;
  </code></pre>
  
  <p>I need to read the python xml file to process the cell contents.
  I use the minidom, but I can not properly import the content of the cells, broken down by rows.</p>
  
  <p>I wrote this code, but I can not extract the string:</p>
  
  <pre><code>from xml.dom import minidom
  xmldoc = minidom.parse("xxx.xml")
  itemlist=xmldoc.getElementsByTagName('Row')
  
  for s in itemlist :
      item=s.getElementsByTagName('Cell')
      print item
  </code></pre>
  
  <p>Does anyone know how to help me? Thank you</p>