import pandas as pd
import xlrd
file = '临时表.xls'
wb = xlrd.open_workbook(file)
sheets = wb.sheets()
for i in sheets:
df= pd.read_excel(file, sheet_name=i, header=1, index=False)
df.head()
xlrd读取多个sheets
最新推荐文章于 2021-09-25 11:30:55 发布