python+excel+unittest接口测试

#coding:utf-8 import xlrd from xlutils.copy import copy class readExcel(object): def __init__(self,path): self.path = path def getSheet(self): #通过索引获取一个工作表 data = xlrd.open_workbook(self.path) sheet = data.sheet_by_index(0) return sheet #获取表的行数 def getRows(self): row = self.getSheet().nrows return row #获取列数 def getCol(self): col = self.getSheet().ncols return col #分别获取每一列的数值 def getUid(self): TestUid = [] #存放第一列数据 for i in range(1,self.getRows()): TestUid.append(self.getSheet().cell(i,0).value) return TestUid def getName(self): TestName =[] for i in range(1,self.getRows()): TestName.append(self.getSheet().cell(i,1).value) return TestName def getUrl(self): TestUrl = [] #存放url for i in range(1,self.getRows()): TestUrl.append(self.getSheet().cell(i,2).value) return TestUrl def getMethod(self): TestMethod = [] #存放接口类型 for i in range(1,self.getRows()): TestMethod.append(self.getSheet().cell(i,3).value) return TestMethod def getData(self): TestData = [] #存放接口传送数据 for i in range(1, self.getRows()): TestData.append(self.getSheet().cell(i, 4).value) return TestData def getCode(self): TestCode = [] for i in range(1,self.getRows()): TestCode.append(self.getSheet().cell(i,5).value) return TestCode def writeResults(self): #copy一个表，然后新建一个表保存结果 data = xlrd.open_workbook(self.path) book = copy(data) return book