Python gets all sheet names for Excel files

When the sheet of an Excel file is more often, it is time to get all the sheet names.

XL = PD. Excelfile ('foo.xls') xl.sheet_names  # See all sheet names xl.parse (sheet_name)   # read a specific sheet to DataFrame

You can also read all the sheet directly and set the SheetName to none. The result is a dict.

 df = pandas.read_excel("/yourPath/FileName.xlsx", None);

"DF" is all sheets as a dictionary of Dataframes, you can verify it by run this:

df.keys()

Python gets all sheet names for Excel files