The easiest way to retrieve the sheetnames from an excel (xls, xlsx) is tabs = pdExcelFile("path")sheet_names print(tabs)enter code here Then to read and store the data of a particular sheet (say, sheet names are "Sheet1", "Sheet2", etc), say "Sheet2" for example data = pdread_excel("path", "Sheet2") print(data) With pandas it is easy to read Excel files and convert the data into a DataFrame Unfortunately Excel files in the real world are often poorly constructed In those cases where the data is scattered across the worksheet, you may need to customize the way you read the data pandas_moon_fuelingpy The Excel sheet doesn't have the exact amount of worksheets mentioned here, but the moon fuel stations sheet is identical In the left corner the Excel sheet Clearly at my work we don't maintain fueling stations on the Moon (yet), but the Excel sheet I encountered looked sort of like the layout of this one
How To Work With Excel Files In Pandas By Dorian Lazar Towards Data Science
Get sheet name excel python pandas