Excel sheet names in Pandas: Listing them with pd.ExcelFile

Excel sheet names in Pandas: Listing them with pd.ExcelFile

What sheets are in an Excel document you’re about to read into Python Pandas?

You can check with:

pd.ExcelFile(filename).sheet_names

You’ll get a list of Python strings back.