python实现接口自动化测试_operationExcel文件内容

#作者:Administrator
#时间:2019/10/19
import xlrd
from be.utils.public import public
from be.utils.excel_data import excel_data
class operationExcel:
#初始化
def init(self):
self.exdata=excel_data()
self.public=public()
#获取excel表格
def getExcel(self,f):
db=xlrd.open_workbook(self.public.data_dir(“data”,f))
sheet=db.sheet_by_index(0)
return sheet
#获取单元格的值
def get_cell_value(self,row,col,f):
return self.getExcel(f).cell_value(row,col)
#获取caseId的值
def get_caseId_value(self,row,f):
return self.get_cell_value(row,self.exdata.get_caseId_col(),f)
#获取url的值
def get_url_value(self,row,f):
return self.get_cell_value(row,self.exdata.get_url_col(),f)
#获取data的值
def get_data_value(self,row,f):
return self.get_cell_value(row,self.exdata.get_data_col(),f)
#获取expect的值
def get_expect_value(self,row,f):
return self.get_cell_value(row,self.exdata.get_expect_col(),f)