pandasxl provides convenience functions for reading data from Excel files into a pandas DataFrame.

...

For example, to read a table from an Excel file into a DataFrame:

import openpyxl
import pandasxl as pdxl

wb = openpyxl.load_workbook('file.xlsx')
df = pdxl.read.from_name(wb, 'table_name')

Public API of the pandasxl package.

The read module contains the core functions for reading data from Excel files.

• read.from_name(wb: openpyxl.Workbook, name: str, header: bool) -> pd.DataFrame

Read an Excel named range or table into a DataFrame.

• read.from_reference(wb: openpyxl.Workbook, ref: str) -> pd.DataFrame

Read an Excel range reference into a DataFrame.