title: Import Excel Tables into pandas dataframe
body: <p>I would like to import excel tables (made by using the Excel 2007 and above tabulating feature) in a workbook into separate dataframes. Apologies if this has been asked before but from my searches I couldn't find what I wanted. I know you can easily do this using the read_excel function however this <a href="https://stackoverflow.com/questions/43367805/pandas-read-excel-multiple-tables-on-the-same-sheet">requires the specification of a Sheetname</a> or <a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html" rel="nofollow noreferrer">returns a dict of dataframes for each sheet</a>. </p>
  
  <p>Instead of specifying sheetname, I was wondering whether there was a way of specifying tablename or better yet return a dict of dataframes for each table in the workbook.</p>
  
  <p>I know this can be done by <a href="https://stackoverflow.com/questions/44793540/read-excel-table-headers-with-xlwings?rq=1">combining xlwings with pandas</a> but was wondering whether this was built-into any of the pandas functions already (maybe ExcelFile). </p>
  
  <p>Something like this:-</p>
  
  <pre><code>import pandas as pd
  xls = pd.ExcelFile('excel_file_path.xls')
  # to read all tables to a map
  tables_to_df_map = {}
  for table_name in xls.table_names:
      table_to_df_map[table_name] = xls.parse(table_name)
  </code></pre>