python读取多个sheet的xlsx文件

不废话，看代码

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
  
15
  
16
  
17
 

读取csv按行来读

    with open('3.csv','r') as csvfile:
        reader = csv.reader(csvfile)        
        rows = [row for row in reader]

    print(rows)
    for i in range(len(rows)):
        print(rows[i])

  
 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
 

文章来源: blog.csdn.net，作者：IM-STONE，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/doubleintfloat/article/details/124640437