1.调用xlrd:import xlrd
2.使用xlrd模块调用excel表格
3.结合pytest参数化格式处理方式来实现DDT
首先创建个excel表格:
代码:
import pytest
import xlrd
from openpyxl.workbook import Workbook
def get_data():
filename = 'test_data.xlsx'
wb = xlrd.open_workbook(filename)
sheet = wb.sheet_by_index(0)
rows = sheet.nrows
cols = sheet.ncols
lst = []
for row in range (rows):
for col in range(cols):
cell_data = sheet.cell_value(row, col)
lst.append(cell_data)
return lst
@pytest.mark.parametrize('name', get_data())
def test1(name):
print(name)
if __name__ == '__main__':
pytest.main(['-sv', 'test_excel.py'])
运行结果:
test_excel.py::test1[byzhang] PASSED [ 33%]byzhang
test_excel.py::test1[tom] PASSED [ 66%]tom
test_excel.py::test1[tony] PASSED [100%]tony