ui自动化数据驱动

最新推荐文章于 2024-07-08 22:02:17 发布

? 18379432324

最新推荐文章于 2024-07-08 22:02:17 发布

阅读量294

点赞数

分类专栏： ui自动化

本文链接：https://blog.csdn.net/weixin_47581508/article/details/107426167

版权

ui自动化专栏收录该内容

6 篇文章 0 订阅

订阅专栏

import xlrd

coding=utf-8

class ReadExcel():

def __init__(self,fileName,sheetName):
    workbook = xlrd.open_workbook(fileName)
    self.sheet = workbook.sheet_by_name(sheetName)

def getValue(self,rowx,colx):
    value = self.sheet.cell_value(rowx,colx)
    if isinstance(value,float):
        return int(value)
    else:
        return value

coding=utf-8

from dcs47.config.conf import *
from dcs47.public.ExcelRead import ReadExcel

url = ReadExcel(data_path,“Sheet1”).getValue(0,0)
username = ReadExcel(data_path,“Sheet1”).getValue(0,1)
username_error = ReadExcel(data_path,“Sheet1”).getValue(1,1)
password = ReadExcel(data_path,“Sheet1”).getValue(0,2)
password_error = ReadExcel(data_path,“Sheet1”).getValue(1,2)