Description
Should Excel tables with more than one sheet be supported? I normally gather all relevant outputs for some analysis in one Excel file writing several sheets. One could inspect the sheets using something like that from dsp_pandas:
# pip install dsp_pandas
from dsp_pandas.io import read_all_excel_sheets
fpath = 'path/to/file.xlsx'
excel_sheets = read_all_excel_sheets(fpath)
print(excel_sheets.sheet_names) # with whitespaces
print(excel_sheets.sheets_names_attr # as attributes
excel_sheets.protein_data # accessing the sheet with name 'protein data'