title: Extract xlrd package data extraction
body: <p>When i am trying to extract the data from an xlsx files. I get the encoding details with the data as well. </p>
  
  <p>Consider the code as shown below,</p>
  
  <pre><code>column_number = 0
  column_headers = []
  #column_headers = sheet.row_values(row_number)
  while column_number &lt;= sheet.ncols - 1:
      column_headers.append(sheet.cell(row_number, column_number).value)
      column_number+=1
  
  return column_headers
  </code></pre>
  
  <p>output is,</p>
  
  <pre><code>[u'Rec#', u'Cyc#', u'Step', u'TestTime', u'StepTime', u'Amp-hr', u'Watt-hr', u'Amps', u'Volts', u'State', u'ES', u'DPt Time', u'ACR', u'DCIR']
  </code></pre>
  
  <p>I just want to extract the cell value which is the data without "u'" attached to it . How can i get just that ?</p>