RF框架-自定义库-数据插入表格

自定义库RfExcel2.py文件

# -*- coding: utf-8 -*-
from openpyxl import load_workbook
import sys


def write_excel(path, lm_num, xfj_num, cm_num):
    # 打开文件
    wb = load_workbook(path)
    # ws = wb['Sheet1']
    ws = wb.active
    rows = ws.max_row
    for i in range(rows):
        row_num = i + 1
        cell = ws.cell(row=row_num, column=5).value
        if str(cell) == "None":
            ws['E'+str(row_num)] = lm_num
            ws['F'+str(row_num)] = xfj_num
            ws['G'+str(row_num)] = cm_num
            break

    wb.save(path)


# if __name__ == '__main__':
#     path, lm_num, xfj_num, cm_num = sys.argv[1], sys.argv[2], sys.argv[3], sys.argv[4]
#     write_excel(path, lm_num, xfj_num, cm_num)

RF框架引用

*** Settings ***
Library    RfExcel2

RfExcel2.py文件单独调用

把下面的注释去掉，cmd命令行输入  python   RfExcel2.py  参数1   参数2    参数3    参数4

# if __name__ == '__main__':
#     path, lm_num, xfj_num, cm_num = sys.argv[1], sys.argv[2], sys.argv[3], sys.argv[4]
#     write_excel(path, lm_num, xfj_num, cm_num)