文件名data.xlsx
import xlrd
class Read_Ex():
def read_excel(self):
#打开excel表
book = xlrd.open_workbook("../Data/data.xlsx")
#找到sheet页
table = book.sheet_by_name("Sheet1")
#获取总行数总列数
row_Num = table.nrows
col_Num = table.ncols
s =[]
key =table.row_values(0)# 这是第一行数据,作为字典的key值
if row_Num <= 1:
print("没数据")
else:
for j in range(row_Num-1):
d ={}
values = table.row_values(j+1)
for x in range(col_Num):
# print(values)
d[key[x]]=values[x]
s.append(d)
return s
if __name__ == '__main__':
r = Read_Ex()
s=r.read_excel()
print(s)
输出结果:
[{‘a’: 1.0, ‘b’: 2.0, ‘c’: 5.0},
{‘a’: 1.0, ‘b’: 954.0, ‘c’: 4.0},
{‘a’: 6.0, ‘b’: 9.0, ‘c’: 8.0},
{‘a’: 8.0, ‘b’: 88.0, ‘c’: 9.0}]