def get_excell_data(cls, path, sheet_name, *clos):
# 读取表格
book = Utility.read_excell(path)
# 得到具体工作表
sheet_target_name = book.sheet_by_name(sheet_name)
# 定义 返回的列表
test_case_list_directory = []
# 遍历读取
for i in range(1, sheet_target_name.nrows):
# 空字典
test_case_list = []
clos_dict = {}
# 具体列
value_clos_datas = sheet_target_name.cell(i, clos[0]).value.splitlines()
value_clos_expect = sheet_target_name.cell(i, clos[1]).value.strip()
for clos_data in value_clos_datas:
# 切割，用"="
data_split = clos_data.split("=")
# = 左边为键，右边为值
clos_dict[data_split[0].strip()] = data_split[1].strip()
# 添加预期
clos_dict["expect"] = value_clos_expect
# 添加列表
test_case_list.append(clos_dict)
test_case_list_directory.append(test_case_list)
return test_case_list_directory
def get_role_info(cls, path, role_data):
# 读表格
book = Utility.read_excell(path)
role_sheet = book.sheet_by_name("roles")
# 遍历每一行
for i in range(1, role_sheet.nrows):
# 读取 角色 判断账号
role_info = role_sheet.cell(i, 1).value.strip()
# 找到要找的角色
if role_data in role_info:
# 读取账号、密码
role_user = role_sheet.cell(i, 3).value.strip()
role_upass = role_sheet.cell(i, 4).value.strip()
return role_user, role_upass
else:
return None
