title: Openpyxl: 'Worksheet' object has no attribute 'values'
body: <p>My goal is to read in an excel file and view the codes in a pandas dataframe (i.e. '= A3') rather than the resulting values from excel executing the codes, which is the pandas default if read in using pandas.</p>
  
  <p>My goal was described here: <a href="https://stackoverflow.com/questions/42102674/how-can-i-see-the-formulas-of-an-excel-spreadsheet-in-pandas-python/">How can I see the formulas of an excel spreadsheet in pandas / python?</a></p>
  
  <p>Openpyxl is supposed to support this, but I can't get the import to function correctly. Anyone spot the error?</p>
  
  <pre><code>import pandas as pd
  from openpyxl import load_workbook
  from openpyxl.utils.dataframe import dataframe_to_rows
  
  df = pd.DataFrame()
  wb = load_workbook(filename = 'name.xlsx')
  sheet_names = wb.get_sheet_names()
  name = sheet_names[0]
  sheet_ranges = wb[name]
  df = pd.DataFrame(sheet_ranges.values)
  
  &gt; AttributeError: 'Worksheet' object has no attribute 'values'
  </code></pre>
  
  <p>(Note: the exact implementation of the answer at the linked question yields <code>KeyError: 'Worksheet range names does not exist.'</code> My code above resolved this, but then gets stuck as described.)</p>