首页 > 学术百科

python自动生成excel报告_python自动化测试报告（excel篇）

python⾃动⽣成excel报告_python⾃动化测试报告（excel篇）# -*- coding: utf-8 -*-

书屋杂志import xlsxwriter

def get_format(wd, option={}):

return wd.add_format(option)

# 设置居中

def get_format_center(wd,num=1):

return wd.add_format({'align': 'center','valign': 'vcenter','border':num})

def set_border_(wd, num=1):

return wd.add_format({}).set_border(num)

# 写数据

def _write_center(worksheet, cl, data, wd):

return worksheet.write(cl, data, get_format_center(wd))

workbook = xlsxwriter.Workbook('report.xlsx')

worksheet = workbook.add_worksheet("测试总况")

worksheet2 = workbook.add_worksheet("测试详情")

def init(worksheet):

甘肃省人口与计划生育条例# 设置列⾏的宽⾼

worksheet.set_column("A:A", 15)

worksheet.set_column("B:B", 20)美的电磁炉电路图

worksheet.set_column("C:C", 20)

worksheet.set_column("D:D", 20)

worksheet.set_column("E:E", 20)

worksheet.set_column("F:F", 20)

worksheet.set_row(1, 30)

worksheet.set_row(2, 30)

worksheet.set_row(3, 30)

worksheet.set_row(4, 30)

worksheet.set_row(5, 30)

# worksheet.set_row(0, 200)

define_format_H1 = get_format(workbook, {'bold': True, 'font_size': 18})

define_format_H2 = get_format(workbook, {'bold': True, 'font_size': 14})

define_format_H1.set_border(1)

define_format_H2.set_border(1)

define_format_H1.set_align("center")

define_format_H2.set_align("center")

define_format_H2.set_bg_color("blue")

define_format_H2.set_color("#ffffff")

# Create a new Chart object.

<_range('A1:F1', '测试报告总概况', define_format_H1)

<_range('A2:F2', '测试概括', define_format_H2)

<_range('A3:A6', '这⾥放图⽚', get_format_center(workbook))

_write_center(worksheet, "B3", '项⽬名称', workbook)

_write_center(worksheet, "B4", '接⼝版本', workbook)

_write_center(worksheet, "B5", '脚本语⾔', workbook)

_write_center(worksheet, "B6", '测试⽹络', workbook)

data = {"test_name": "智商", "test_version": "v2.0.8", "test_pl": "android", "test_net": "wifi"}

_write_center(worksheet, "C3", data['test_name'], workbook)

_write_center(worksheet, "C4", data['test_version'], workbook)

_write_center(worksheet, "C5", data['test_pl'], workbook)

_write_center(worksheet, "C6", data['test_net'], workbook)

_write_center(worksheet, "D3", "接⼝总数", workbook)

_write_center(worksheet, "D4", "通过总数", workbook)

_write_center(worksheet, "D5", "失败总数", workbook)

_write_center(worksheet, "D6", "测试⽇期", workbook)

data1 = {"test_sum": 100, "test_success": 80, "test_failed": 20, "test_date": "2018-10-10 12:10"} _write_center(worksheet, "E3", data1['test_sum'], workbook)

_write_center(worksheet, "E4", data1['test_success'], workbook)

_write_center(worksheet, "E5", data1['test_failed'], workbook)

_write_center(worksheet, "E6", data1['test_date'], workbook)

_write_center(worksheet, "F3", "分数", workbook)

<_range('F4:F6', '60', get_format_center(workbook))

pie(workbook, worksheet)

# ⽣成饼形图

def pie(workbook, worksheet):

chart1 = workbook.add_chart({'type': 'pie'})

chart1.add_series({

'name': '接⼝测试统计',

'categories':'=测试总况!$D$4:$D$5',

modelsim'values': '=测试总况!$E$4:$E$5',

})

chart1.set_title({'name': '接⼝测试统计'})

chart1.set_style(10)

worksheet.insert_chart('A9', chart1, {'x_offset': 25, 'y_offset': 10})

def test_detail(worksheet):

# 设置列⾏的宽⾼

worksheet.set_column("A:A", 30)

worksheet.set_column("B:B", 20)

worksheet.set_column("C:C", 20)

worksheet.set_column("D:D", 20)

worksheet.set_column("E:E", 20)

worksheet.set_column("F:F", 20)

worksheet.set_column("G:G", 20)

worksheet.set_column("H:H", 20)

worksheet.set_row(1, 30)

worksheet.set_row(2, 30)

worksheet.set_row(3, 30)

worksheet.set_row(4, 30)

worksheet.set_row(5, 30)

worksheet.set_row(6, 30)

worksheet.set_row(7, 30)

<_range('A1:H1', '测试详情', get_format(workbook, {'bold': True, 'font_size': 18 ,'align': 'center','valign': 'vcenter','bg_color': 'blue', 'font_color': '#ffffff'}))

_write_center(worksheet, "A2", '⽤例ID', workbook)

_write_center(worksheet, "B2", '接⼝名称', workbook)

_write_center(worksheet, "C2", '接⼝协议', workbook)

_write_center(worksheet, "D2", 'URL', workbook)

_write_center(worksheet, "E2", '参数', workbook)

_write_center(worksheet, "F2", '预期值', workbook)

_write_center(worksheet, "G2", '实际值', workbook)

_write_center(worksheet, "H2", '测试结果', workbook)

data = {"info": [{"t_id": "1001", "t_name": "登陆", "t_method": "post", "t_url": "XXX?login", "t_param": "

{user_name:test,pwd:111111}",

"t_hope": "{code:1,msg：登陆成功}", "t_actual": "{code:0,msg：密码错误}", "t_result": "失败"}, {"t_id": "1002", "t_name": "商品列表", "t_method": "get", "t_url": "XXX?getFoodList", "t_param": "{}",

"t_hope": "{code:1,msg：成功,info:[{name:123,detal:dfadfa,img:product/1.png},{name:456,detal:dfadfa,img:product/1.png}]}", "t_actual": "{code:1,msg：成功,info:[{name:123,detal:dfadfa,img:product/1.png},{name:456,detal:dfadfa,img:product/1.png}]}", "t_result": "成功"}],

"test_sum": 100,"test_success": 20, "test_failed": 80}

temp = 4

for item in data["info"]:

_write_center(worksheet, "A"+str(temp), item["t_id"], workbook)

_write_center(worksheet, "B"+str(temp), item["t_name"], workbook)

_write_center(worksheet, "C"+str(temp), item["t_method"], workbook)

_write_center(worksheet, "D"+str(temp), item["t_url"], workbook)

_write_center(worksheet, "E"+str(temp), item["t_param"], workbook)

电视频道包装_write_center(worksheet, "F"+str(temp), item["t_hope"], workbook)

_write_center(worksheet, "G"+str(temp), item["t_actual"], workbook)

_write_center(worksheet, "H"+str(temp), item["t_result"], workbook)

temp = temp -1

init(worksheet)

test_detail(worksheet2)杨玉圣

workbook.close()

本文发布于:2024-09-22 11:34:54，感谢您对本站的认可！

本文链接：https://www.17tex.com/xueshu/124459.html

上一篇：自动化测试最佳实践（一）：从纺锤模型到金字塔模型

下一篇：CAN总线网络自动化测试平台应用

标签：测试条例测试报告动化设置总况杂志电路图

留言与评论（共有 0 条评论）