title: Using python and xlrd, what is the best way to read 2 columns from a spreadsheet
body: <p>I have an excel spreadsheet that has 2 columns. Something like this</p>
  
  <p>|ColA |  ColB |<br>
  |Key  | Value |<br>
  |1    | test  |<br>
  |2    | test2 |<br>
  |3    | test4 |  </p>
  
  <p>and I want to read these two columns into a dictionary.  I currently have this working but can't figure out how to extract out each key value pair</p>
  
  <pre><code>  sh = wb.sheet_by_index(0)
    for rownum in range(sh.nrows):
        print sh.row_values(rownum)
  </code></pre>