title: Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
body: <p>I've an Excel File:</p>
  <pre><code>Arm_id      DSPName        DSPCode          HubCode          PinCode    PPTL
  1            JaVAS            01              AGR             282001    1,2
  2            JaVAS            01              AGR             282002    3,4
  3            JaVAS            01              AGR             282003    5,6
  </code></pre>
  <p>I want to save a string in the form <code>Arm_id,DSPCode,Pincode</code>. This format is configurable, i.e. it might change to <code>DSPCode,Arm_id,Pincode</code>. I save it in a list like:</p>
  <pre><code>FORMAT = ['Arm_id', 'DSPName', 'Pincode']
  </code></pre>
  <p>How do I read the content of a specific column with provided name, given that the <code>FORMAT</code> is configurable?</p>
  <p>This is what I tried. Currently I'm able to read all the content in the file</p>
  <pre><code>from xlrd import open_workbook
  wb = open_workbook('sample.xls')
  for s in wb.sheets():
      #print 'Sheet:',s.name
      values = []
      for row in range(s.nrows):
          col_value = []
          for col in range(s.ncols):
              value  = (s.cell(row,col).value)
              try : value = str(int(value))
              except : pass
              col_value.append(value)
          values.append(col_value)
  print values
  </code></pre>
  <p>My output is :</p>
  <pre><code>[
      [u'Arm_id', u'DSPName', u'DSPCode', u'HubCode', u'PinCode', u'PPTL'],
      ['1', u'JaVAS', '1', u'AGR', '282001', u'1,2'], 
      ['2', u'JaVAS', '1', u'AGR', '282002', u'3,4'], 
      ['3', u'JaVAS', '1', u'AGR', '282003', u'5,6']
  ]
  </code></pre>
  <p>Then I loop around <code>values[0]</code> trying to find out the <code>FORMAT</code> content in <code>values[0]</code> and then getting the index of <code>Arm_id, DSPname and Pincode</code> in the <code>values[0]</code> and then from next loop I know the index of all the <code>FORMAT</code> factors , thereby getting to know which value do I need to get .</p>
  <p>But this is such a poor solution.</p>
  <p><strong>How do I get the values of a specific column with name in excel file?</strong></p>