title: is there a better way to use OpenPyXL's defined_names feature to return values from an Excel Named Range?
body: <p>I have an Excel workbook that has a worksheet called 'Professional Staff'. On that sheet, there is a range of cells named 'ProStaff'. I retrieve a list of the values in those cells with this code:</p>
  
  <pre><code>import openpyxl
  
  wb = openpyxl.load_workbook(filename='SOexample.xlsx', read_only=True)
  
  
  #Get the ProStaff range values
  ProStaffRange = wb.defined_names['ProStaff']
  
  #returns a generator of (worksheet title, cell range) tuples
  dests = ProStaffRange.destinations
  
  #use generator to create a list of (sheet, cell) tuples
  cells = []
  for title, coord in dests:
      ws = wb[title]
      cells.append(ws[coord])
  
  #Above was from the OpenPyXL website
  
  #Below is my best attempt to retrieve the values from those cells
  cellsStr = []
  startChar = '.'
  stopChar = '&gt;'
  
  for item in cells[0]:
      itemStr = str(item)
      cellsStr.append( (itemStr.split("'")[1].strip(),  itemStr[itemStr.find(startChar)+1:itemStr.find(stopChar)]) )
  
  for item in cellsStr:
      print(wb[item[0]][item[1]].value)
  </code></pre>
  
  <p>The string manipulation I do takes something like:</p>
  
  <pre><code>(&lt;ReadOnlyCell 'Professional Staff'.A1&gt;,)
  </code></pre>
  
  <p>and turns it into:</p>
  
  <pre><code>('Professional Staff', 'A1')
  </code></pre>
  
  <p>It seems to me that there should be a way to work with the ReadOnlyCell items directly in order to retrieve their values, but I haven't been able to figure out how.</p>