title: How can I extract excel data by column name?
body: <p>My excel data looks like this:</p>
  
  <pre><code>    A    B    C
  1   123  534  576
  2   456  745  345
  3   234  765  285
  </code></pre>
  
  <p>In another excel spreadsheet, my data may look like this:</p>
  
  <pre><code>    B    C    A
  1   123  534  576
  2   456  745  345
  3   234  765  285
  </code></pre>
  
  <p>How can I extract column C's contents from both spreadsheets?</p>
  
  <p>My code is as follows:</p>
  
  <pre><code>#Open the workbook
  ow = xlrd.open_workbook('export.xlsx').sheet_by_index(0)
  
  #Store column 3's data inside an array
  ips = ow.col_values(2, 1)
  </code></pre>
  
  <p>I would like something more like: <code>ips = ow.col_values(C, 1)</code></p>
  
  <p>How can I achieve the above?</p>