Python读取Excel test data 最简单版

 读取Excel test data 最简单版

from openpyxl import load_workbook
import os
# 准备数据，找到路径
file_path = os.path.join(os.path.dirname(os.path.abspath(__file__)), "test_excel.xlsx")
#load_workbook模块，去打开测试数据，生成workbook对象（wb）
wb = load_workbook(file_path)
# 在表单中，获取单元格的数据
sh = wb["login"]
for item in list(sh.rows):
    print(item)

Excel数据是这样的

读取后想变成

    {"name": "nanwu", "password": "123456", "res": {"code": 0, "message": "登陆成功"}},
    {"name": "nanwu", "password": "qwer123", "res": {"code": 1, "message": "账号密码不正确"}},
    {"name": "nanwu", "password": "qwer1234", "res": {"code": 1, "message": "账号密码不正确"}}