title: Read Excel sheet table (Listobject) into python with pandas
body: <p>There are multiple ways to read excel data into python.
  Pandas provides aslo an API for writing and reading</p>
  
  <pre><code>import pandas as pd
  from pandas import ExcelWriter
  from pandas import ExcelFile
  
  df = pd.read_excel('File.xlsx', sheetname='Sheet1')
  </code></pre>
  
  <p>That works fine.</p>
  
  <p>BUT: What is the way to access the tables of every sheet directly into a pandas dataframe??</p>
  
  <p><a href="https://i.stack.imgur.com/Sz3eY.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Sz3eY.jpg" alt="enter image description here"></a></p>
  
  <p>The above picture shows a sheet including a table SEPARATED THAN CELL (1,1).</p>
  
  <p>Moreover the sheet might include several tables (listobjects in VBA).</p>
  
  <p>I can not find anywhere the way to read them into pandas.</p>
  
  <p>Note1: It is not possible to modify the workbook to bring all the tables towards cell(1,1).
  Note2: I would like to use just pandas (if it is possible) and minimize the need to import other libraries. But it there is no other way I am ready to use other lybray. In any case I could not manage with xlwings for instance.</p>
  
  <p><a href="https://stackoverflow.com/questions/17063458/reading-an-excel-file-in-python-using-pandas">here</a> it looks like its possible to parse the excel file, but no soilution is provided for tables, just for complete sheets.</p>
  
  <p>The <a href="https://pandas.pydata.org/pandas-docs/version/0.11.0/generated/pandas.io.parsers.ExcelFile.parse.html" rel="nofollow noreferrer">documentation of pandas</a> does not seem to offer that possibility.</p>
  
  <p>Thanks.</p>