​import pytest 
import xlrd 
def get_data():
    filename="F:\\學(xué)習(xí)\\自動(dòng)化測(cè)試\\selenium自動(dòng)化測(cè)試\\selenium_test\\data\\test.xls" 
    # 讀取工作簿 
    wb=xlrd.open_workbook(filename) 
    # 讀取第一個(gè)sheet頁(yè)
    sheet=wb.sheet_by_index(0) 
    # 讀取行 
    rows=sheet.nrows 
    # 讀取列
    cols=sheet.ncols 
    lst=[] 
    for row in range(rows):
        for col in range(cols):
            #根據(jù)行列獲得單元格數(shù)據(jù)
            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.xls'])
 
​