def readExcel(self, fileName): # 打开文件 workBook = xlrd.open_workbook(filePath('data', fileName)) # sheet索引从0开始 sheet1_content = workBook.sheet_by_index(0) # 获取总行数 row = sheet1_content.nrows # 获取总列数 #col = sheet1_content.ncols result = [] for i in range(1, row): dict_i = dict( zip(sheet1_content.row_values(0), sheet1_content.row_values(i))) dict_i['Data'] = json.loads(dict_i['Data']) dict_i['Header'] = json.loads(dict_i['Header']) if dict_i['IsRun'] == 'y': dict_i['Url'] = getUrl() + dict_i['Url'] dict_i['Header']['OrganId'] = getOrgCode() dict_i['Data']['belongOrgId'] = getOrgCode() result.append(dict_i) return result
def readExcel(self, fileName): # 打开文件 workBook = xlrd.open_workbook(filePath('data', fileName)) # sheet索引从0开始 sheet1_content = workBook.sheet_by_index(0) # 获取总行数 row = sheet1_content.nrows # 获取总列数 #col = sheet1_content.ncols result = [] for i in range(1, row): dict_i = dict( zip(sheet1_content.row_values(0), sheet1_content.row_values(i))) dict_i['Data'] = json.loads(dict_i['Data']) if dict_i['IsRun'] == 'y': if dict_i['CaseId'] == 'test_006': dict_i['Data']['data']['ImgName'] = '1.jpg' dict_i['Data']['data']['ImgBase64'] = imgBase('1.jpg') dict_i['Url'] = getUrl() + dict_i['Url'] dict_i['Data']['orgcode'] = getOrgCode() result.append(dict_i) return result
# 获取总行数 row = sheet1_content.nrows # 获取总列数 #col = sheet1_content.ncols result = [] for i in range(1, row): dict_i = dict( zip(sheet1_content.row_values(0), sheet1_content.row_values(i))) dict_i['Data'] = json.loads(dict_i['Data']) if dict_i['IsRun'] == 'y': if dict_i['CaseId'] == 'test_006': dict_i['Data']['data']['ImgName'] = '1.jpg' dict_i['Data']['data']['ImgBase64'] = imgBase('1.jpg') dict_i['Url'] = getUrl() + dict_i['Url'] dict_i['Data']['orgcode'] = getOrgCode() result.append(dict_i) return result if __name__ == '__main__': # obj = OperationExcel() # for i in obj.readExcel('testdata.xlsx'): # with open(filePath('data','teacherIdList.txt'),'a') as f: # f.write(i['CaseId']+'|') # print(i) with open(filePath('data', 'teacherIdList.txt'), 'r') as f: str = f.read() l = str.strip('|').split('|') print(l)
def dictYaml(self, fileDir='data', fileName='book.yaml'): with open(filePath(fileDir=fileDir, fileName=fileName), 'r', encoding='utf-8') as f: return yaml.safe_load(f)
def readYaml(self): with open(filePath(), 'r', encoding='utf-8') as f: return list(yaml.safe_load_all(f))
def readDataValue(self, fileDir='config', fileName='dangdang.yaml'): '''获取列的具体值dictConfig()''' with open(filePath(fileDir=fileDir, fileName=fileName), 'r', encoding="utf-8") as f: return yaml.safe_load(f)
def getSheet(self): book = xlrd.open_workbook(filePath('data', 'books.xlsx')) return book.sheet_by_index(0)
import pytest, time, os, sys, shutil sys.path.append( "C:\\Users\\DONGCHUAN\\AppData\\Roaming\\Python\\Python37\\site-packages") p = os.path.join(os.path.dirname(__file__)) sys.path.append(p) from common.public import filePath, mkdir, sendEmail if __name__ == '__main__': now = time.strftime("%Y-%m-%d_%H-%M", time.localtime()) path = filePath('report', now) mkdir(path) path = filePath('report', 'assets') mkdir(path) filedir = 'report/' + now path = filePath(filedir, '测试报告.html') path = "--html=" + path pytest.main([path]) p = os.path.join(os.path.dirname(__file__), "report", "assets", "style.css") p1 = os.path.join(os.path.dirname(__file__), "report", now, "assets", "style.css") shutil.copy(p1, p) p = os.path.join(os.path.dirname(__file__), "report", "测试报告.html") p1 = os.path.join(os.path.dirname(__file__), "report", now, "测试报告.html") shutil.copy(p1, p) sendEmail()
def getSheet(self): '''打开excel文件''' execl=xlrd.open_workbook(filePath('data','books.xlsx')) '''返回excel文件第一个sheet,将数据尽量放在第一个sheet里''' return execl.sheet_by_index(0)
def dicYaml(self, fileDir='config', fileName='books.yaml'): with open(filePath(fileDir=fileDir, filename=fileName), 'r', encoding='utf-8') as f: return yaml.safe_load(f)
def dictYaml(self, fileDir='config', fileName='book.yaml'): with open(filePath(fileDir=fileDir, fileName=fileName), 'r', encoding='utf-8') as f: return list(yaml.safe_load_all(f))
def getSheet(self): '''获取sheet(一般只会用一个sheet,会从下标获取)''' workbook = xlrd.open_workbook(filePath('data','dangdang.xls')) return workbook.sheet_by_index(0)
def readYaml(self): with open(filePath(fileDir='data', fileName='login.yaml'), 'r', encoding='utf-8') as f: return list(yaml.safe_load_all(f))
def readYamlE(self, fileDir, fileName): with open(filePath(fileDir=fileDir, fileName=fileName), 'r', encoding='utf-8') as f: return yaml.safe_load(f)
def readYaml(self): with open(filePath('data', 'ya.yaml'), 'r', encoding="utf-8") as f: return list(yaml.safe_load_all(f))
def getSheet(self): book = xlrd.open_workbook(filePath("data", "books.xlsx")) return book.sheet_by_index(0)