不废话,看代码
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()