import xlrd;
# 打开工作表
workbook = xlrd.open_workbook("test.xlsx")
# 获取所有的工作薄
sheets = workbook.sheet_names()
# 获取sheet总个数
print(workbook.nsheets)
num = workbook.nsheets
# 返回的结果集
for i in range(num):
sheet = workbook.sheets()[i]
#python3.8用法
print(f'第 {str(i + 1)} 个sheet: {sheet.name} ')
rows = sheet.nrows
for i in range(rows):
print(sheet.row_values(i))
python xlrd读取excel多个sheet页
最新推荐文章于 2024-06-24 11:00:35 发布