title: Reading an Excel named range into a pandas DataFrame
body: <p>How can you read the data from a named range in Excel into a pandas DataFrame?
  <a href="https://i.stack.imgur.com/tKe99.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tKe99.png" alt="Excel screenshot" /></a></p>
  <p>Unfortunately, the canonical function <code>pandas.read_excel()</code> is designed to only read entire sheets within a workbook.</p>