如何獲取Excel文件的所有sheets名稱

1. ExcelFile

import pandas as pd
xl = pd.ExcelFile(filename)
xl.sheet_names
xl.parse(sheet_name)

ExcelFile使用xlrd模塊，將表格類型的數(shù)據(jù)解析為pandas的數(shù)據(jù)框?qū)嵗?。參?shù)填寫文件路徑或者緩存即可，其sheet_names屬性就是所有sheet的名稱。parse函數(shù)可以獲取指定的某個sheet。

2. read_excel的sheet_name參數(shù)

help(pd.read_excel)
------------------------------------------------------------------------------------------
sheet_name : string, int, mixed list of strings/ints, or None, default 0

    Strings are used for sheet names, Integers are used in zero-indexed
    sheet positions.

    Lists of strings/integers are used to request multiple sheets.

    Specify None to get all sheets.

    str|int -> DataFrame is returned.
    list|None -> Dict of DataFrames is returned, with keys representing
    sheets.

    Available Cases

    * Defaults to 0 -> 1st sheet as a DataFrame
    * 1 -> 2nd sheet as a DataFrame
    * "Sheet1" -> 1st sheet as a DataFrame
    * [0,1,"Sheet5"] -> 1st, 2nd & 5th sheet as a dictionary of DataFrames
    * None -> All sheets as a dictionary of DataFrames
----------------------------------------------------------------------------------------------
df = read_excel(filename, sheet_name=None)
df.keys()

sheet_name參數(shù)可以為字符串、整數(shù)以及由整數(shù)、字符串組合成的列表或者None。默認為0，即返回第一個sheet。
當sheet_name為 str|int 時，直接返回DataFrame；
當sheet_name為 list|None時，返回DataFrame和sheet名稱組成的字典。
所以直接將sheet_name設(shè)置為None，然后調(diào)用df.keys()可獲取所有sheet的名稱。