unittest + excel

import unittest
import requests
import json
import xlrd
class myapi():
    def login(self,name):
        data = {
            'loginType': 'xxxr',
            'name': name,
            'passwd': '9cx796xa550266021',
            'yzm': '7104'
        }
        r = requests.post('xxxxxx', data=data)
        dict = json.loads(r.text)
        # print(dict['message'])
        self.messege = dict['message']
        return self.messege#返回’登陆成功‘
    def name(self,table,nrows):#将返回的name 添加到list
            TestName = []
            for i in range(0, nrows):
                TestName.append(table.cell(i, 0).value)
            return TestName
    def open_excel(self, path):
        workbook = xlrd.open_workbook(path)
        table = workbook.sheets()[0]
        return table     #返回第一页
    def get_nrows(self, table):
        nrows = table.nrows
        return nrows#获取到一共有多少行

class TestUserLogin(unittest.TestCase):  # 继承unittest.TestCase
        api = myapi()
        excel_table = api.open_excel(r'C:\Users\Administrator\Desktop\login.xlsx')
        nrows = api.get_nrows(excel_table)
        name = api.name(excel_table, nrows)
        def test_1(self): #用例一
            messge = self.api.login(self.name[0])
            self.assertEqual('登录采购商成功！', messge)
            print(self.name[0] + '通过')

        def test_2(self):#用例二
            messge = self.api.login(self.name[1])
            self.assertEqual('登录采购商成功！', messge)
            print(self.name[1]+'通过')
        def test_3(self):
            messge = self.api.login(self.name[2])
            self.assertEqual('登录采购商成功！', messge)
            print(self.name[2] + '通过')
        def test_4(self):
            messge = self.api.login(self.name[3])
            self.assertEqual('登录采购商成功！', messge)
            print(self.name[3] + '通过')
        def test_5(self):
            messge = self.api.login(self.name[4])
            self.assertEqual('登录采购商成功！', messge)
            print(self.name[4] + '通过')
        def test_6(self):
            messge = self.api.login(self.name[5])
            self.assertEqual('登录采购商成功！', messge)
            print(self.name[5] + '通过')
        def test_7(self):
            messge = self.api.login(self.name[6])
            self.assertEqual('登录采购商成功！', messge)
            print(self.name[6] + '通过')
        def test_8(self):
            messge = self.api.login(self.name[7])
            self.assertEqual('登录采购商成功！', messge)
            print(self.name[7] + '通过')
        def test_9(self):
            messge = self.api.login(self.name[8])
            self.assertEqual('登录采购商成功！', messge)
            print(self.name[8])

if __name__ == '__main__':
    suite = unittest.TestSuite() # 继承unittest.TestCase
    for i in range(1,10):
        suite.addTest(TestUserLogin('test_'+str(i)))   #将所有的测试用例加载进去
    with open('执行结果.txt', 'a+') as f:
        runner = unittest.TextTestRunner(stream=f,verbosity=2)  # 关键在于stream=f   f是保存
        runner.run(suite)