Python - Looking up the list of sheets in an excel file - 找出指定excel檔的sheet name

Version

Python version ：Python 3.6.0 :: Anaconda 4.3.1 (64-bit)
Pandas version ：0.19.2
System version ：Windows 10

Codes

import pandas as pd
file_path=r'E:\download\tmp\test.xlsx'
sheet_name_list = pd.ExcelFile(file_path).sheet_names
sheet_name_list

執行結果：

['sheet1', 'sheet2', 'sheet3']

​