Python-DDT-01
2021/6/5 22:21:17
本文主要是介绍Python-DDT-01,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
Python-DDT-01
- 课题
- 环境
- Excel操作案例
课题
数据驱动测试
Python接口自动化-DDT-Excel-01
环境
1.pycharm,python3
2.安装xlrd:pip install xlrd
Excel操作案例
import xlrd # 从Excel中获取数据 def GetListFromExcelData(excelname, sheetname): # 打开Excel文件方式 Exc = xlrd.open_workbook(excelname) # 选择其实中一个sheet sheet1 = Exc.sheet_by_name(sheetname) # 常用方法使用 # print('第一行数据:', sheet1.row_values(0)) # print('第一行,第一列数据:', sheet1.row_values(0)[0]) datelist = [] for i in range(1, sheet1.nrows): for j in range(0, sheet1.ncols): values = sheet1.row_values(i)[j] datelist.append(values) return datelist datas = GetListFromExcelData('test01.xls', 'Sheet1') print(datas) def GetDictFromExcelData(excelname, sheetname): Exc = xlrd.open_workbook(excelname) sheet1 = Exc.sheet_by_name(sheetname) datelist = [] for i in range(1, sheet1.nrows): datadict = {} for j in range(0, sheet1.ncols): # datadict[sheet1.row_values(0)[j]] 获取字段名-key,赋值为value # 示例 dict['Age'] = 8 datadict[sheet1.row_values(0)[j]] = sheet1.row_values(i)[j] datelist.append(datadict) return datelist datas = GetDictFromExcelData('test01.xls', 'Sheet1') print(datas) # 示例:获取第二个的用户名 print(GetDictFromExcelData('test01.xls', 'Sheet1')[1]['username']) # 输出结果 # ['Mike', '123456', 'Bob', '147852', 'An', '147854'] # [{'username': 'Mike', 'password': '123456'}, {'username': 'Bob', 'password': '147852'}, {'username': 'An', 'password': '147854'}] # Bob
这篇关于Python-DDT-01的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-05-08有遇到过吗?同样的规则 Excel 中 比Python 结果大
- 2024-03-30开始python成长之路
- 2024-03-29python optparse
- 2024-03-29python map 函数
- 2024-03-20invalid format specifier python
- 2024-03-18pool.map python
- 2024-03-18threads in python
- 2024-03-14python Ai 应用开发基础训练,字符串,字典,文件
- 2024-03-13id3 algorithm python
- 2024-03-13sum array elements python