在该测试框架中,我使用excel来存储WEB PAGE 的 Element:
在untils.file_reader.py文件中定义了excel的读取方法:
class ExcelReader:
def __init__(self, excelf, sheetname):
if os.path.exists(excelf):
self.excel_file = excelf
else:
raise FileNotFoundError("Excel file is not exist!")
self.sheetname = sheetname
self._data = {}
@property
def data(self):
workbook = xlrd.open_workbook(self.excel_file, 'r')
sheetbook = workbook.sheet_by_name(self.sheetname)
nrows = sheetbook.nrows
for i in range(nrows):
key = sheetbook.row_values(i)[0]
By = sheetbook.row_values(i)[1]
Value = sheetbook.row_values(i)[2]
self._data[key] = (By, Value)
return self._data
在selenium的API接口中,findElement(),在该方法中传入一个2个参数,定位类型和定位值