title: UnicodeEncodeError: 'ascii' codec can't encode character u'\xa0' in position 37: ordinal not in range(128)
body: <p>Getting this error while executing below code:</p>
  
  <pre><code>def csvFromExcel(path):
      'This is for converting Delights.xlsx sheets into sheetName.csv '
      wb = xlrd.open_workbook(path)
      print wb.nsheets
      sheetNames = []
      sheetNames = wb.sheet_names()
      print sheetNames
      for sheetName in sheetNames:
          sh = wb.sheet_by_name(sheetName)
          csvFile = open("processed/"+sheetName+'.csv', 'wb')
          wr = csv.writer(csvFile, quoting=csv.QUOTE_ALL)
  
          for rownum in xrange(sh.nrows):
              wr.writerow(sh.row_values(rownum))
          csvFile.close()
  
  if __name__ == "__main__":
      path = 'toBeProcess/Delights.xlsx'
      csvFromExcel(path)
  </code></pre>
  
  <p>At this point i'm getting error: <code>wr.writerow(sh.row_values(rownum))</code></p>
  
  <p>Does anyone have any idea how to fix it.</p>