def data(excelPath, sheetName):
data = xlrd.open_workbook(excelPath)
table = data.sheet_by_name(sheetName)
# 获取第一行作为key值
keys = table.row_values(0)
# 获取总行数
rowNum = table.nrows
# 获取总列数
colNum = table.ncols
if rowNum <= 1:
raise BaseException("测试数据异常")
else:
r = []
j = 1
for i in range(rowNum - 1):
s = {}
# 从第二行取对应values值
values = table.row_values(j)
for x in range(colNum):
s[keys[x]] = values[x]
r.append(s)
j += 1
return r
用xlrd读取excel表格(python)
最新推荐文章于 2023-07-10 11:46:19 发布