def get_depend_key(self, row):
col = int(data_config.get_data_depend())
depent_key = self.opera_excel.get_cell_value(row, col)
if depent_key == "":
return None
else:
return depent_key
def get_depend_key(self, row):
col = int(data_config.get_data_depend())
data = self.opera_excel.get_value(row, col)
if data == '':
return None
else:
return data
def get_case_depend(self, row):
case_col = int(data_config.get_case_depend())
case = self.opera_excel.get_cell_value(row, case_col)
rowRes = self.opera_excel.get_cell_row(case)
res = None
if rowRes:
result_col = int(data_config.get_result_value())
resData = self.opera_excel.get_value(rowRes, result_col)
if resData:
resData = json.loads(resData)
data_col = int(data_config.get_data_depend())
data = self.opera_excel.get_cell_value(row, data_col)
field_col = int(data_config.get_field_depend())
field = self.opera_excel.get_cell_value(row, field_col)
if field:
res = resData[data][field]
else:
res = resData[data]
return res