title: how to get the table with merge cells in exactly same format in excel file
body: <p>I am trying to get the table in same manner from Link in excel file, I am  getting the table by using the code below</p>
  
  <pre><code>#Getting particular table from the page and sending to excel file
  page    = urllib2.urlopen('http://developer.android.com/about/dashboards/index.html').read()
  soup    = BeautifulSoup(page)
  a       = soup('div', {'class' : 'col-5'})[0]
  with open('android version 2013_01_18.csv', 'wb') as csvfile:
      csvout = csv.writer(csvfile, delimiter=',')
      csvout.writerow(["Version","Codename","API", "Distribution"])
      for table in a.findAll('table'):
          print '#'
          print '# Table'
          print '# Fields: ' + ','.join([tr.text for tr in table.findAll('th')])
          for row in table.findAll('tr'):
              csvout.writerow([tr.text for tr in row.findAll('td')])
  </code></pre>
  
  <p>I am getting output in excel as :</p>
  
  <pre><code>1.6 Donut   4   0.20%
  2.1 Eclair  7   2.40%
  2.2 Froyo   8   9.00%
  "2.3 - 2.3.2
  "   Gingerbread 9   0.20%
  "2.3.3 - 2.3.7
          "   10  47.40%  
  3.1 Honeycomb   12  0.40%
  3.2 13  1.10%   
  4.0.3 - 4.0.4   Ice Cream Sandwich  15  29.10%
  4.1 Jelly Bean  16  9.00%
  4.2 17  1.20%   
  </code></pre>
  
  <p>Here the problem is with the row immediately after merge cells, as td counts are 3 instead of 4
  I found that for creating merge cells rowspan=2 has been used in the code, but i want to know how to use this information for getting data exactly same, Below is the HTML structure </p>
  
  <pre><code>&lt;tr&gt;
   &lt;td&gt;
   &lt;a href="/about/versions/android-2.3.html"&gt;2.3 - 2.3.2&lt;/a&gt;
   &lt;/td&gt;
   &lt;td rowspan="2"&gt;Gingerbread&lt;/td&gt;
   &lt;td&gt;9&lt;/td&gt;
   &lt;td&gt;0.2%&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
   &lt;td&gt;
   &lt;a href="/about/versions/android-2.3.3.html"&gt;2.3.3 - 2.3.7 &lt;/a&gt;
   &lt;/td&gt;
   &lt;td&gt;10&lt;/td&gt;
   &lt;td&gt;47.4%&lt;/td&gt;
  &lt;/tr&gt;
  </code></pre>