python中使用excel读取文件

在python中使用excel读取文件进行自动化测试

1.先创建一个excel表格存放数据源


2.读取数据

import os
import xlrd

current_path = os.path.dirname(__name__)
excel_path = os.path.join(current_path,'..//elemnt_info_datas/element_infos.xlsx')
class ElementDataUtils:
    def __init__(self,page_name,element_path = excel_path):
        self.element_path = element_path
        self.workbook = xlrd.open_workbook(excel_path)  #打开存放的excel数据
        self.sheet = self.workbook.sheet_by_name(page_name) #按名称获取sheet
        self.row_count = self.sheet.nrows  #获取所有的行
        self.col_count = self.sheet.ncols  #获取所有的列

    def get_element_info(self,pagename):
        element_infos = locals()  #动态获取数据
        for i in range(1, self.row_count):
            element_info = {}
            for j in range(1,self.col_count):
                cell_value = self.sheet.cell_value(i, j)
                cell_value = int(cell_value) if isinstance(cell_value,float)else str(cell_value)
                #将字符串模式的时间数字转化为整型
                element_info[self.sheet.cell_value(0, j)] = cell_value
            if element_info['page'] == pagename: #按照每一页的所属页面分类进行查询，可以优化获取时间提高性能
                element_infos[self.sheet.cell_value(i, 0)] = {}
                element_infos[self.sheet.cell_value(i, 0)] = element_info
        return element_infos

3.进行调用

if __name__ =="__main__":
    try:
        elemenets = ElementDataUtils('项目').get_element_info('project_page')
        print(elemenets['story_menu'])
    except Exception as e:
        print('该页面无此参数')

学IT，上博学谷
https://m.boxuegu.com/inviteShare/invited?id=8a2c9bed6aa1c063016ab53099d00037&source=1&from=singlemessage