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