title: Reading a named range from excel - Python - xlrd
body: <p>Following is the piece of code that I wrote, and I'm unable to proceed beyond reading the range. I want to be able to read the actual content of the range. Any help is appreciated.</p>
  
  <pre><code>import xlrd
  xlBook = xlrd.open_workbook('data.xlsx')
  # Open the sheet
  sht = xlBook.sheet_by_name('calc')
  # Look at the named range
  named_obj = xlBook.name_map['load'][0]
  
  # Now, able to retrieve the range
  rangeData = (named_obj.formula_text)
  (sheetName,ref) = rangeData.split('!')
  # Gives me the range as $A$2:$B$20
  print(ref)
  # How do I print the contents of the cells knowing the range.
  </code></pre>