Python readExcelの例

コード例 #1

ファイル: test17_balanceQuery.py プロジェクト: caoyilong/cango-auto-test

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='balanceQuery')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_balanceQuery(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body

コード例 #2

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo
import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='preApply')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_preApply(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body, de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body
        self.de_server = de_server

コード例 #3

ファイル: test18_fullRefundApply.py プロジェクト: caoyilong/cango-auto-test

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='fullRefundApply')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_fullRefundApply(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body

コード例 #4

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN
login_xls = readExcel().get_xls(sheet_name='chargeApply')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_chargeApply(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body, de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body
        self.de_server = de_server

コード例 #5

ファイル: test13_repayApplyQuery.py プロジェクト: caoyilong/cango-auto-test

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='repayApplyQuery')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_repayApplyQuery(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body

コード例 #6

ファイル: test11_repayTrail.py プロジェクト: caoyilong/cango-auto-test

# -*- coding: utf-8 -*-
import unittest
import sys
import random
sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='repayTrail')


@paramunittest.parametrized(*login_xls)
class test_repayTrail(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body
        self.de_server = de_server

コード例 #7

ファイル: test16_withdrawApply.py プロジェクト: caoyilong/cango-auto-test

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='withdrawApply')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_withdrawApply(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body

コード例 #8

ファイル: test08_loanApplyQuery.py プロジェクト: caoyilong/cango-auto-test

# -*- coding: utf-8 -*-
import unittest
import sys
import random
sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='loanApplyQuery')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_loanApplyQuery(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body
        self.de_server = de_server

コード例 #9

ファイル: test19_transferApply.py プロジェクト: caoyilong/cango-auto-test

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='transferApply')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_transferApply(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body, de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body
        self.de_server = de_server

コード例 #10

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='firstApplyQuery')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_firstApplyQuery(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body

コード例 #11

ファイル: test14_cardChangeApply.py プロジェクト: caoyilong/cango-auto-test

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='cardChangeApply')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_cardChangeApply(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body

コード例 #12

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='finalApply')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_finalApply(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body

コード例 #13

# -*- coding: utf-8 -*-
import unittest
import sys
import random

sys.path.append("./page_obj")
sys.path.append("./user4element")
from page_obj.demo import demo

import paramunittest
from testcase.Excel import readExcel
from page_obj.is_de import is_de
import time
from page_obj import HTMLTestReportCN

login_xls = readExcel().get_xls(sheet_name='accountDrawApply')
print(login_xls)


@paramunittest.parametrized(*login_xls)
class test_accountDrawApply(unittest.TestCase):
    def setParameters(self, body, url, server, ass, is__de, de_key, de_body,
                      de_url, de_server):
        self.body = body
        self.url = url
        self.server = server
        self.ass = ass
        self.is_de = is__de
        self.de_key = de_key
        self.de_url = de_url
        self.de_body = de_body