def test_new_export1(self): file_path = self.readConfig.port_data_filepath sheet_name = self.readConfig.new_export_sheet1 # 打开excel文件的具体sheet DataSheet = open_excel(file_path, sheet_name) # sheet行数 rowNum = DataSheet.nrows for i in range(rowNum): module = DataSheet.row_values(i) module_start = module[0:2] module_end = module[2:] # 去掉字符串中的空格 module_start = delete_blank(module_start) # 导航栏 module_end = delete_blank(module_end) # table栏 # 导航栏点击 module_name = change_navigate(module_start, self.driver) num = len(module_end) for j in range(num): # 切换table module_name = change_table(module_end, j, self.driver) # 导出照片、导出 Export(self.driver, self.logger).new_Export(module_name) # 页面刷新到首页 go_Homepage(self.driver)
def test_old_export(self): file_path = self.readConfig.port_data_filepath sheet_name = self.readConfig.old_export_sheet # 打开excel文件的具体sheet try: DataSheet = open_excel(file_path, sheet_name) except: self.logger.debug('导入导出配置文件不存在!') # sheet行数 rowNum = DataSheet.nrows for i in range(rowNum): module = DataSheet.row_values(i) # 去掉字符串中的空格 module_list = delete_blank(module) # 导航栏点击 module_name = change_navigate(module_list, self.driver) # 导出照片、导出 JugeOldExport(self.driver, self.logger, module_name).juge_old_export() # 页面刷新到首页 go_Homepage(self.driver)
def test_new_export(self): file_path = self.readConfig.port_data_filepath sheet_name = self.readConfig.new_export_sheet # 打开excel文件的具体sheet try: DataSheet = open_excel(file_path, sheet_name) except: self.logger.debug('导入导出配置文件不存在!') # sheet行数 rowNum = DataSheet.nrows for i in range(rowNum): module = DataSheet.row_values(i) # 去掉字符串中的空格 module_list = delete_blank(module) # 偶数行(通过link_text获取的模块链接)数据处理 module_name = change_navigate(module_list, self.driver) # 导出照片、导出 Export(self.driver, self.logger).new_Export(module_name) # 页面刷新到首页 go_Homepage(self.driver)