python读取多个sheet的xlsx文件_python读取包含200个sheet的excel

不废话，看代码

def read_excel2(path):
    data_xls = pd.io.excel.ExcelFile(path)
    data={}
    test = BlobDataTestor()
    print(data_xls.sheet_names)
    for name in data_xls.sheet_names:
        df=pd.read_excel(data_xls,sheet_name=name,header=None , usecols = [1,3,5])
        data[name]=df
        print("df = ",df , type(df))
        if df.empty:
            continue

        mm = np.array(df)                                    
        ss = mm.transpose()
1
2
3
4
5
6
7
8
9
10
11
12
13
14