import unittest
import xlrd
# 打開接口用例excel文件
excel_data = xlrd.open_workbook('register.xlsx')
# 讀取excel文件中存放用例的sheet頁，命名無要求
sheet = excel_data.sheet_by_name('register')
print(sheet.nrows)
print(sheet.row_values(1))
# 將讀取到的用例全部追加到data列表中
data = []
for i in range(1, sheet.nrows):
    data.append(sheet.row_values(i))
    print(data)
class register(unittest.TestCase):
    def test_register_check(self):
        pass

import unittest
import xlrd
from ddt import ddt,data,unpack
excel_data = xlrd.open_workbook('register.xlsx')
sheet = excel_data.sheet_by_name('register')
# print(sheet.nrows)
# print(sheet.row_values(1))
data_ = []
for i in range(1, sheet.nrows):
    data_.append(sheet.row_values(i))
print(data_)
# 引入的裝飾器@ddt；導(dǎo)入數(shù)據(jù)的@data；拆分?jǐn)?shù)據(jù)的@unpack
@ddt
class register(unittest.TestCase):
    @data(*data_)
    @unpack
    def test_register(self, title, data, check):
        print(data)
if __name__ == '__main__':
    unittest.main()

# 從excel文件中讀取用例，name參數(shù)為sheet名稱
def read_excel_data(inputdir,name):
     dataframe = pandas.DataFrame(columns=['接口名','用例','請求地址','請求體','斷言','協(xié)議','請求方式'])	# 傳入?yún)?shù)就是excel文件中的列名
     try:
         datafile = pandas.read_excel(inputdir,sheet_name=name)
         dataframe = dataframe.append(datafile, ignore_index=True, sort=True)
     except:
         print("Warning:excel文件打開異常，請重試！")
     To_list = dataframe.to_dict(orient='records')	# 參數(shù)='records'時，轉(zhuǎn)化后是 list形式
     return To_list

from common.data import read_excel_data
import pytest
def getdata(path):
    getdata = read_excel_data(path, '編輯xx')
    print(getdata)
path = r'..\common\接口用例文檔.xlsx'	# excel文件的路徑，按實際項目結(jié)構(gòu)指明
getdata(path)

# 以下數(shù)據(jù)會以list形式被讀取
- testapi
- url
- get

# 以下數(shù)據(jù)會以dict形式被讀取
name: A
age: 1
spouse:
    name: B
    age: 2
slave:
 - name: C  # - 表示為列表
   age: 3
 - name1: D
   age1: 4

import os
import yaml
class LoadTestData:
    # 設(shè)置路徑，獲取yaml文件數(shù)據(jù)
    def load_data(self, file_name):
        yaml_path = os.path.join(os.path.join(os.path.dirname(os.path.dirname(os.path.abspath(__file__))),                                          'test_file'), file_name)
        yaml_data = yaml.load(open(yaml_path), Loader=yaml.FullLoader)
        # print(yaml_data)
        return yaml_data
def get_yaml_data(api_file, api_name):
    '''
    獲取yaml中 api_name的數(shù)據(jù)
    :param api_file:  api文件位置
    :param api_name:  api文件名稱
    :return: 文件數(shù)據(jù)
    '''
    data = LoadTestData().load_data(api_file)[api_name]
    print(data)
    return data
if __name__ == '__main__':
    file_name = 'api_data.yaml'
    api_name = 'test'
    # LoadTestData().load_data(file_name)
    get_yaml_data(file_name,api_name )
    print('讀取成功')