Ejemplos de readExcel en Python

Ejemplo n.º 1

Archivo: test17_balanceQuery.py Proyecto: 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

Ejemplo n.º 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

Ejemplo n.º 3

Archivo: test18_fullRefundApply.py Proyecto: 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

Ejemplo n.º 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

Ejemplo n.º 5

Archivo: test13_repayApplyQuery.py Proyecto: 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

Ejemplo n.º 6

Archivo: test11_repayTrail.py Proyecto: 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

Ejemplo n.º 7

Archivo: test16_withdrawApply.py Proyecto: 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

Ejemplo n.º 8

Archivo: test08_loanApplyQuery.py Proyecto: 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

Ejemplo n.º 9

Archivo: test19_transferApply.py Proyecto: 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

Ejemplo n.º 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

Ejemplo n.º 11

Archivo: test14_cardChangeApply.py Proyecto: 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

Ejemplo n.º 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

Ejemplo n.º 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