title: How can I read a range('A5:B10') and place these values into a dataframe using openpyxl
body: <p>Being able to define the ranges in a manner similar to excel, i.e. 'A5:B10' is important to what I need so reading the entire sheet to a dataframe isn't very useful.</p>
  
  <p>So what I need to do is read the values from multiple ranges in the Excel sheet to multiple different dataframes.  </p>
  
  <pre><code>valuerange1 = ['a5:b10']
  valuerange2 = ['z10:z20']
  df = pd.DataFrame(values from valuerange)
  df = pd.DataFrame(values from valuerange1)
  </code></pre>
  
  <p>or</p>
  
  <pre><code>df = pd.DataFrame(values from ['A5:B10'])
  </code></pre>
  
  <p>I have searched but either I have done a very poor job of searching or everyone else has gotten around this problem but I really can't. </p>
  
  <p>Thanks. </p>