title: How can I access the values via python in an XML that is structured as follows?
body: <p>I am having difficulties accessing the values in an XML using a python script. How can you go about accessing Value1-Value4 here? I have tried using the findall() function, but nothing returns.</p>
  
  <pre><code>tree =ET.parse('example.xml')
  
  root=tree.getroot()
  
  for child in root.findall("row"):
      print(child)
  </code></pre>
  
  <p>The XML looks as following:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="ISO-8859-1"?&gt;
  &lt;entities xmlns="http://www.example.com"&gt;
  &lt;entity id="Title" dataDate="2018-08-31"&gt;
  &lt;spreadsheetContainer name="ContainerA"&gt;
  &lt;row&gt;
  &lt;col name="A"&gt;Value1&lt;/col&gt;
  &lt;col name="B"&gt;Value2&lt;/col&gt;
  &lt;col name="C"&gt;Value3&lt;/col&gt;
  &lt;col name="D"&gt;Value4&lt;/col&gt;
  &lt;/row&gt;
  &lt;/spreadsheetContainer&gt;
  &lt;/entity&gt;
  &lt;/entities&gt;
  </code></pre>