selenium之使用xlrd模块读取ecel文件，使用pytest参数化实现DDT

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